Yes I have reviewed that over and over. Asking for help is typically my last course of action. I know how to use the /SET option and the others I...

Can you provide some more information about what your procedures are doing. Code would be helpful. Are you using dynamic SQL? What is the Server Advance setting for Optimize for...

Nice question.

raulggonzalez (1/28/2013)

---

I don't see what this QotD is trying to test... It's not about how CHOOSE works but what data you have in a table that is not represented on...

Try not puting the quotes around the comma just use -s,

If that still doesn't work try -s"|"

and let me know the results.

This is interesting, when I run something very similar to this I get a comma delimated file. Are you sure that you are looking at the file in the correct...

Can you give an example of what you are running? I usually use the bcp command and use the option -t,

check out the 2 links below:

http://msdn.microsoft.com/en-us/library/ms191485.aspx

http://msdn.microsoft.com/en-us/library/ms162802.aspx

This is what I use to do that same thing. It is used in a SSIS package and the results are held in an object variable then I loop through...

This question does seem to be bringing up a nice discusion. Hopefully that was the idea of it and not to say that with little knowledge about the business and...

You could also have the last step in the job add a message in a queue for the service broker to pick up and execute the next job.

Or what i...

I take it that:

select sum(total) as NetTotal, (sum(total)/100)*3.2 as Gross from abc group by a

will not work?

I use the SSIS maintenance plans but they are owned by me (sysadmin) and operated by my service account which is a domain account.

But beyond that you also have...

That depends on a few settings. By deafult yes. When you reintialize a subscription it says I need a new fresh copy from a snapshot. Now it depends on how...

I would like to see more of this type, making them hard as they go. Up to 5 or 6 variables mixed with and without parentheses and numerous orders of...

nice question.