Thanks for the explanation... I still don't understand everything, but I'm beginning to :-). In short, you want to find all records in table q22004, that are already present (with...

Hello,

first thing I can see is that you have typos there.. I'm not sure whether it is just in the post or also in the real query, but one of...

I'm a bit confused... If the controller is in at least one of the 14 tables, you want to set IsActive = 0; if it isn't, you want to delete...

Hi Perry,

just an idea... I know it's obvious, but anyway I'll try. Besides the job owner, there is also "Run as user" setting in each step of the job (on...

krypton,

you say you need 2 before 12... that's something I can understand - but do you also need 2B9 before 12A?

I'm afraid that it is almost impossible to catch...

As far as I know, multiple data files solve mainly problems with storage space. You can have each file on a different drive, so if the database is say 200GB...

That's right, Ganesh's query is better in that it doesn't use temporary tables, but a plain select statement and I'd recommend it before the one I mentioned - if it...

Hello,

one way to do this is to select the records with your original query into a temp table with identity column, ordered as necessary - precisely as they should appear...

You're welcome :-). The "Edit" button is in the header of each post, on the right. Just click it, the post will open in edit mode (window is the same...

Ufff... quite complicated, especially if you want to make it use variable number of conditions - I suppose there can be more than two. 

Well, probably you could start thinking...

Hi Dinesh,

you can't mix both types of command in one step. The way to achieve what you need could be to create two steps - first with T-SQL, second with...

I'm not going to recommend anything, just want to mention the other possibility... We have a similar structure : central (about 60 users), 2 warehouses (10-20 users each) and 6 shops (2 users...

Hello Stephen,

the only problem is with the column names, but since you didn't explicitly mention that the column names have to be assigned as month names, this SQL could help...

Julie, just an idea... we had similar problem this week (query not running from EM, only from QA) The problem was, that the EM was running under different user. We assumed, that...

LOL, so it sometimes pays not to read BOL too carefully. I missed this part somehow, and I'm using the syntax mentioned by AJ quite often and for a long...