You can't have dynamic code in the view. But you can write dynamic script (or procedure) that will generate DROP and CREATE VIEW statements (or ALTER VEW) with all your...

There must be only one... ORDER BY... at the end of your query.

For existing objects you can search sys.sql_modules:

SELECT

o.object_id

,SchemaName = s.name

,ObjectName = o.name

,o.[type]

,m.[definition]

FROM sys.objects o

...

Perhaps you should choose "Operating System" for the Type as sqlcmd is a command line utility?

You can't sort on posteddate+companydid. You get the error, right?

So, you need to either convert posteddateto varchar and then concatenate:

CONVERT(char(8), posteddate, 112) + companydid

Or change your dynamic code to...

You can't convert string that contains non-numeric characters to INT. If you need to concatenate then you have to convert other datatypes to varchar.

What are you trying to achive? Are...

a4apple (4/10/2014)

What do you mean to say, when you want to pass 16 in the code. It's not even a...

The error occures when you build your dynamic query or when you execute it? What datatype is @OrderType? Assuming it's a VARCHAR, this

DECLARE @OrderBy VARCHAR(20) = 'Posteddate'

DECLARE @OrderType VARCHAR(20)...

Check this article: http://www.sqlservercentral.com/articles/T-SQL/62159/

Your dynamic code should look like this:

declare @CurrMo Varchar(30)

declare @CurrYe Varchar(30)

DECLARE @TSQL varchar(8000)

set @CurrMo = Month(dateadd(day,-1,getdate()))

set @CurrYe = Year(dateadd(day,-1,getdate()))

SELECT @TSQL = '

INSERT INTO [Srvr2].[dbo].[tbl_Rent_Uti2]

([Year],

[Month],

[Utilperiod],

[PL],

[BL],

[Store],

[Region],

[UnitsOR],

[FleetOR],

[UnitsTotal],

[NBVTotal],

[FleetTotal])

Select Year, Month...

The error you are getting is because this is syntactically invalid:

INSERT INTO TableA

SELECT @TSQL = 'select * from TableB'

You need to include the whole thing (including INSERT INTO part) into the dynamic code.

You can use OPENROWSET. Assuming you have ACE driver installed:

SELECT *

FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0;Database=C:\Test\MySheet.xlsx',

'select * from [Sheet1$]')

Make sure the file is not opened by any other program.

You do assignment, here:

SELECT @TSQL =

Should be in the job history (under SQL Server Agent if you use Object Explorer).

Or check here: msdb.dbo.sysjobhistory