Actually it's not a requirement yet...

That's how you should think about your db when you design it.

Greg's solution would work nicely... but if you ever need to add CC, DD, and EE to the in() clause you'd have to add 3 more inner joins.. I...

Or change it altogether and change the post to XXX just so that noone decides to try to hack your server.

check out this url

http://www.connectionstrings.com/

Unless you have a few 100s of millions of rows you don't need to do that. If your queries need to run faster I suggest moving the first part...

The trigger on system tables are not reliable... and not supported by Microsoft. The best way would be to do snapshots of that table every 5 minutes or so...

There's another way to achieve the same result without modifying any table design. You can create an indexed view on that column and create a unique index on...

Why do you need to create a table at run time?

Usually when you need a table for an application you just create it once and leave it there. If...

No.. Just the same problem over and over again. Can you rename the database so that it can't be an isse from now on?

I've already seen better but this might give you a clue

http://www.igoodsoft.com/download.htm (Super System Helper)

This software however doesn't seem to let you select a dll and see what process are using...

How were you supposed to debug yourself if you couldn't go online to do searches?

Yes yelena, your version will work just fine but since it converts to varchar and back to datetime, it takes more time to execute.

Your version does something like cast((cast as...

It would look something like this :

Select UserId from Mytable where ItemID in ('AA','BB') GROUP BY UserID having count(*) = 2

Please make sure you understand the logic. It's really not as obvious as it seems. It took me at least one hour to really catch this trick and be able...

Select * from dbo.MyTable where

dateadd(d, (datediff(d, 0, YourDate)) , 0)

=

dateadd(d, (datediff(d, 0, GetDate() - 1)) , 0)

Quick explanation :

datediff(d, 0, YourDate) counts the number of days since 1900/01/01

it then...