In your trigger , if you

'Select count(*) from deleted'

then you will get 4 back ( in this case).

How do you mean 'only getting one' , are you thinking...

Which reminds me , ive still got a half finished blog on forced parametrization hanging around.

Do you mean the procedure cache (DBCC FREEPROCCACHE) or the buffer cache(DBCC DROPCLEANBUFFERS) ?

Im guessing the former, could potentially be parameter sniffing http://www.sqlpointers.com/2006/11/parameter-sniffing-stored-procedures.html

See here on howto backup a database http://msdn.microsoft.com/en-us/library/ms187510.aspx

However, if you have not backed up this database , you have lost the value you have overwritten.

Did the spec of DBCC timewarp ever get completed ?

http://www.sqlservercentral.com/Forums/Topic897436-146-1.aspx

There is no backup 'value' , there are only database backups.

Is this within a transaction ?

Im guessing not. If it is , you simply have to "ROLLBACK".

If not , then there is nothing the system can do for you....

Head, Wall , Bang http://www.sqlservercentral.com/Forums/Topic897407-391-1.aspx

Give up....

So why state, "sqlscript programmatically through .NET" ?

You dont.

You need to send the commands batches ( ie each GO block) separately to SQLServer.

GO as a command means nothing to Sqlserver. It is used by management studio to break the commands into separate batches. You need to send you commands in...

IMO

select Date,

Sum(Case when Type ='Debit' then Amount else 0 end) AS Debit,

Sum(Case when Type ='Credit' then Amount else 0 end) AS Credit

From <Table Name>

Group by Date

Is Easier to...

Try taking the results of

SELECT StudentId

FROM fnGetStudentsWithMultiofficeSupportForHistoryChanges(@loginToken,@AreaID,@IsNodeMultioffice)

into a temptable and joining to that instead.

What does the plan look like with that ?

Looking at this loop in isolation , you should be able to build together two string.

One to Alter the table to add all the columns required in one hit :

ie

alter...

Have i just fallen hook line and sinker for some weird april fool's 😉

http://www.sqlservercentral.com/Forums/Topic894474-338-1.aspx