blasto_max (1/14/2014)

---

Please tell me more about this and how it...

A simple queue system should work for you. There are plenty of SSIS queue frameworks on the internets. 😀

Posting this here...knowledge is wealth.

I tried to start different packages simultaneously and started receiving dead-lock errors.

I finally found a solution to the dead lock issue and my original post after...

Why not start with something like this to build your query or inserts around...?

SELECT name,addy,ph,subject,grade

FROM #test CROSS APPLY (VALUES('subject 1',grade1),('subject 2',grade2),('subject 3',grade3),('subject 4',grade4),('subject 5',grade5)) AS x(subject,grade)

Lynn Pettis (8/28/2012)

---

Greg Snidow (8/28/2012)

---

Now let's not be too hasty. Some of us do care. In fact, I'd hazard a guess that if the...

^^^ lol. I need to change the moniker.

Here is a revised version eliminating the GROUP BY and/or DISTINCT clauses. I especially dislike using either of those to return non-aggregated data....

The code below ran pretty fast on my desktop. Give it a try:

SELECT DISTINCT @holder1 = s1.SaleID,@holder2 = LocationID

FROM #Sale s1

INNER JOIN #SaleLocationXref SLX1 ON S1.SaleID = SLX1.SaleID

INNER JOIN #SaleItemXref...

Can you provide some more sample data of the following?

PARENT

/ ...

I could be wrong but Celko's method is the fastest. One thing to keep in mind is the LEN function's limit is 8000 characters or in other words the sum...

This is the first thing that came to mind...try this:

IF OBJECT_ID('tempdb..#MapIDs') IS NOT NULL

DROP TABLE #mapids

CREATE TABLE #MapIDs

(

ID INT IDENTITY(1,1),

WonkyID CHAR(8) NOT NULL,

Client VARCHAR(50) NULL,

Identifier1 VARCHAR(12) NULL,

Identifier2 VARCHAR(20) NULL,

CONSTRAINT...

Here are two different methods for accomplishing the same goal. One uses hierarchyid, while the other uses a simple LEFT join. Excuse my bad grammar on my lack of coffee....

I really am having fun with hierarchyids but here is a solution assuming there are only 5 levels. 😛

I had to tweak the code I wrote earlier.

DECLARE @TEMP AS TABLE

(Orgunitcode...

You need to flatten out your dates to use Jeff's methods using something similar to this code:

declare @Dates table

([Row] int NOT NULL,

[OrgID] varchar(50) NOT NULL,

[StartDate] date NULL,

[EndDate] date NULL)

Insert into...

Jeff Moden (7/23/2012)

---

SQL Padawan (7/23/2012)

---

^^^ Too much text for me to read right now 😉 But here is a solution using Hierarchyid just for the heck of it. I'm not...

^^^ Too much text for me to read right now 😉 But here is a solution using Hierarchyid just for the heck of it. I'm not the best at writing...