Quick thought, have a look at this page Enable Network Access Securely for MS DTC, guess this is your problem.

😎

Here is a quick "set based loop" method using an inline Tally table to count the hours.

😎

USE tempdb;

GO

DECLARE @TEST_DATA TABLE

(

TEST_DATA_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY...

Lynn Pettis (8/30/2014)

---

I am jaded. I just read a reopened old thread by one of my favorite people. How, I ask you, can you work with SQL Server...

Quick thought, use a combination of replace and convert with the 110 format directive

😎

USE tempdb;

GO

DECLARE @MMDDYY VARCHAR(20) = '01 20 1950'

SELECT CONVERT(DATETIME,REPLACE(@MMDDYY,CHAR(32),CHAR(45)),110)

Result

1950-01-20 00:00:00.000

He he,...

techmaark (8/30/2014)

---

OLE DB provider "SQLNCLI10" for linked server "REPLLINK_TECHMARK952933815_TEST_CLIEN-672667892_REPUPDSUB2109712029_TEST_SERVE-1760219189" returned message "The transaction manager has disabled its support for remote/network transactions.".

Msg 7391, Level 16, State 2, Line 1

The operation could...

Quick thought, rather than a iterative for loop use foreach table in tables.

😎

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...