No. It might weaken my argument in my management's eyes, but I would have...

Jason Crider (10/3/2008)

---

Matt Miller (10/3/2008)

---

This would be a textbook case for a "man in the middle" attack. Passing large amounts of data using a URL is essentially leaving yourself...

This would be a textbook case for a "man in the middle" attack. Passing large amounts of data using a URL is essentially leaving yourself VERY open to any...

jlp3630 (10/3/2008)

---

Matt Miller (10/3/2008)

---

Jeremiah is right on the compilation of the INNER process. That being said - a lot of functions tend to negatively impact the performance of the...

Jeremiah is right on the compilation of the INNER process. That being said - a lot of functions tend to negatively impact the performance of the OUTER process (meaning...

TheSQLGuru (10/3/2008)

---

>>Think "compound interest".

Think "read my post"! 😀

The default data file growth is ONE MEGABYTE, not TEN PERCENT (at least on all the servers I recall installing)....

mtassin (10/3/2008)

---

Matt Miller (10/2/2008)

---

Actually - if I were to ignore the cursor in your code for a minute, all you need to do to make your code work is to...

Jack Corbett (10/2/2008)

---

I also prefer separate procs. Of course with the new MERGE syntax in 2008 that would probably change. Then the name would be usp_MergeCustomer or something...

If you use the built-in tools within .NET - you can have it build you a database-driven version of a login scenario, using forms authentication. It will handle everything...

Todd Engen (10/2/2008)

---

Two options that would probably solve that. One, use a stored procedure instead of sending the query from the client side application. Two, change the...

Actually - if I were to ignore the cursor in your code for a minute, all you need to do to make your code work is to initialize the @outputstr...

You're right when dealing with ROW_NUMBER(). So, make the PARTITION BY and the ORDER...

Philip -

Jacob was very close. If you want each customer and sales order, then change the ORDER BY to a PARTITION BY.

Change is in bold in Jacob's code...

Yes - you have to create the temp table first. SELECT...INTO doesn't work with an EXEC call. INSERT INTO does not create the table.

If the service account doesn't have permissions to create a file (edit but not create), you might see something like that.....

You need to make sure that the account being used...