Or you could try doing it in a DTS package using ActiveScripting the same way Leon speaks of doing with VB.

"Don't roll your eyes at me. I will tape them...

Try something like this is the only way I see to do it without a temp table.

Note the where clause on the subquery to get the records up to...

Actually FREEPROCCACHE does not generally release the memory back to the OS and it is considered bad to run on a production environment as you are forcing data to be...

Ahhh...

So try this

SELECT

user_id

FROM

my_intersect

WHERE

user_id IN (SELECT user_id FROM my_intersect1 WHERE thing_id = 1) AND

user_id IN (SELECT user_id FROM my_intersect1 WHERE thing_id = 2) AND

`user_id IN (SELECT user_id...

Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071 for details on how to move the various system databases for both 7 and 2K.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

How is you connection defined and do you use TCP/IP or Named Pipes?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Not sure how Profiler fully does this but there is no particular command that I know of of that will let you do this.

"Don't roll your eyes at me. I...

All patch info can be found thru http://www.microsoft.com/sql/default.asp which also has a link to security resources on the right side to see security goto security patches.

"Don't roll your eyes at...

Clustered indexes cannot be created elsewhere in relation to the table as this sorts the table and the leaf pages are stored with the table. Sorry I should have been...

I see, can you post what you have currently done and I will see what I can come up with?

"Don't roll your eyes at me. I will tape them in...

Please do not cross post. Duplicate message please post/see response in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4089&FORUM_ID=19&CAT_ID=3&Topic_Title=BulkInsert+problem&Forum_Title=Data+Transformation+Services+%28DTS%29

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Please do not cross post. Duplicate message please post/see response in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4089&FORUM_ID=19&CAT_ID=3&Topic_Title=BulkInsert+problem&Forum_Title=Data+Transformation+Services+%28DTS%29

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Huh, did they say if they are replacing it with something else? Anyway I have not tried any of those but may when I have more time.

"Don't roll your eyes...

Kashif you are rigth in what you state as this is a bad way to reference especially the PK since it will be unique. As a friend here would say...

Problem with EBay is a lot of time it is OEM software which unless you bought the hardware you will get hit for license violation. Also a lot of the...