I think that my version (well Frank Kalis' version) is prettier and actually will run much faster on larger datasets... it's just a matter of understanding what's actually happening under...

Select * from dbo.MyTable where

dateadd (d, 0, datediff(d, 0, MyDateField))

=

CAST(dateadd (d, 0, datediff(d, 0, getdate())) AS SMALLDATETIME)

NP.. R U normalizing your tables or just doing the select?

PK, identity, indexes

SELECT O.Name AS ParentName, CASE RTRIM(O.XType)

...

Can you post the whole code snippet you execute? it's impossible to find the problem for sure with this info.

Happy to help.

Profiler would be one way to go..

another would be to make a log table an log the activity everytime the sp that loads the report is called... that way you...

Foreign keys :

SELECT TOP 100 PERCENT PTbl.name AS PkTableName, PCol.name AS PkColName, FTbl.name AS ConstraintName, dbo.sysobjects.name AS FkTableName,

...

This will get you started again :

use my 3rd post

Delete from dbo.Quick2 Q where exists (Select * from dbo.tmt2 T where Q.num = T.Num)

Select * from dbo.Quick2

most likely you are not using the same user in asp net than in QA. And that user most likely doesn't have the necessary permission to do the restore.

Insert into TableB (Tel, name, charge1, adress)

Select tel, name, charge1, adress from dbo.YourTable where Charge1 > 0

UNION ALL

Select tel, name, charge2, adress from dbo.YourTable where Charge2 > 0

UNION ALL

Select tel,...

There's still work to be done on this but you'll get the idea :

Select USER_NAME(uid) as Owner,O.Name as TableName, C.Name as ColName, Object_name(C.cDefault) as ConstraintName, substring(Text, 2, len(Text) -...

You don't actually need to do that, you can simply add a new column of the correct datatype and do something like this :

make sure that this statement returns...

Exactly.