cheers guys, i found my issue, used try catch and realized i have a typo mistake in set identity table and the table im inserting into long table name  i...

unfortunately i cant, i must be missing something, if i create 2 new tables and run my queires in the same way everything works fine, so im guessing its something...

Cheers Guys,

Lowell, 
i am executing my script exactly in the way you explain however, i still get the error

Cannot insert explicit value for identity column...

cheers for the reply but i have tried that also and i still get the error, whats more strange is, i know that only 1 table can have identity insert...

Thanks guys , in the documentation on licensing It says,

Each user and/or device accessing a licensed SQL Server requires a SQL Server CAL

When I say there will be...

I just come across an issue with bad design but development think its fine.

On an inherited database from external company their Dev have added a number of triggers to...

Database size, performance express can only use 1gb memory. Cost is not that bad for 1 server and 10 cals so I just need to make sure I'm licensed correctly

SET @sql=REPLACE(@Sql,'@IncomeAmount','@InComeAmountB')

Try

Set @sql=Select substring(@Sql,0,charindex('>',@sql))+cast(@InComeAmountB as varchar)

Exec (@sql)

This example @sql is that the string stored in db?

What about using a vbs script executed by windows scheduled task? I use this method and write out my results to text file.

Be easier to help if you provide some Ddl and how are you calling stored procedure or setting the variables. Initially i would look up dynamic sql perhaps do you...

Look up row_number () over ( partition) run through a cte and return only the rows you need

SELECT cast( DATEDIFF(m, CarsDate, GETDATE()) as int )

Or perhaps if you just want to return a number create a function or perhaps populate a variable

HI I have just implimeted something a little similar in excell however, instead of exporting from SQL i import from excel.

I created a button on spreadhseet then create some VBA...

what is the aim of what your doing? are you just inserting everything from one table into another in a batch of N as thats what it looks like to...