use [DATABASENAME]
go
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'V' AND name = '[YourViewName]')
BEGIN
  PRINT 'Dropping View [YourViewName]'
  DROP VIEW  [YourViewName]
END
GO
CREATE VIEW [YourViewName]
AS
-- your select statement
GO
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = '[YourViewName]')
BEGIN
  PRINT 'View [YourViewName] greated'
  GRANT SELECT ON [YourViewName] TO PUBLIC
END
  ELSE
BEGIN
  PRINT 'View [YourViewName] not greated!'
END
GO