Brandie Tarvin (5/16/2016)

---

I do not understand what you mean by this statement. Do you mean running via SSMS with...

Shawn Melton (5/16/2016)

---

You need to review how you are calling the packages, and under what account it is running. If you are using Windows Authentication then whatever account is calling...

I know most of you don't even want to spell SSIS, but for those that like it, I'd appreciate some help in here: http://www.sqlservercentral.com/Forums/Topic1786539-364-1.aspx

Have you tried COUNT(DISTINCT )?

SELECT myvalue = COUNT( DISTINCT TotalSalesAmt)

FROM SalesItem2

For a one time or manual process, you could choose the option "Results to File".

You might be able to go around the xp_cmdshell process by creating a job with a...

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

IMHO...

Use

...

Rin Tin Tin

Then don't use functions on the ORDER BY clause.

Just be aware that scalar udfs would prevent parallelism on all the queries they're used. A complex calculation won't have this problem.

jasona.work (5/11/2016)

---

Something like a "First post" column, or including it in the "Started By" column when viewing a forum / list of results.

It would certainly make it easier to filter...

Lynn Pettis (5/11/2016)

---

Luis's solution only has...

Phil Parkin (5/11/2016)

---

Eirikur Eiriksson (5/11/2016)

---

Sean Lange (5/11/2016)

---

WHY OH WHY can we not get the spam under control on this site? Every morning it is about 2 spams for every actual...

DuncEduardo (5/11/2016)

---

I've used mixture of "while", "getdate()", "datediff" and for the minute size of it, works well.

I'd consider tally table for something more substantial, but for the sake of 12...

Seriously? Do you understand what a tally table is? It's nothing more that a table (which could be a...