And now for the Window function solution with somewhat increased verbosity in order to explain how it works. It is more efficient than the previous code as it only scans...

Here is a slightly verbose and hopefully self explanatory set based approach.

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* To rebuild the table, first execute the line below by highlighting it + F5,...

Does anyone have the Crystal Ball, oops I mean Crystal Reports (help needed)

😎

Thank you Scott, Tom and Lynn, this was the discussion I wanted to get going in this context. The subject is far to dependent on the environment and the nature...

I agree with Luis, a while loop is not needed in this query.

😎

Good stuff, glad you got this resolved.

This is less of a problem on 2K8 R2 and later, not certain why, just my experience. As a rule of thumb, I try...

ScottPletcher (8/29/2014)

---

patrickmcginnis59 10839 (8/29/2014)

---

CELKO (8/22/2014)

---

I use the encoding that is being used. The IDENTITY property (not a column!) is the...

Within the SysInternals utility you can filter the output on a folder, the file handle will show up there during the Data Flow task execution. The question is whether SSIS...

Quick thought, grab the SysInternals utility which shows open files, cannot remember the name but should be easy to find. It will show if any process is accessing the file....

Duran (8/29/2014)

---

Thank you for reading and responding so quickly, Hmm, I'd have to check, but I'm fairly sure it's 2008 r2 64bit, I can confirm and come back Monday. Have...

Quick question, what SQL Server version are you on?

😎

Quick question, are you on SQL Server 2008 (not R2) 32bit?

😎

Quick suggestion, count each table content in a separate CTE and join them for the combined results

😎

USE tempdb;

GO

/* Test data */

WITH SYNCHMESSAGE (M_KEY,M_MSG) AS

(

SELECT

...

Evil Kraig F (8/28/2014)

---

Check to make sure your schema information is matching. I usually see that happen when I forget to slap dbo. onto the table name in the...

In my opinion, setting the actual port number for each instance should be avoided unless absolutely necessary. Leave this to the SQL Server Browser Service

😎