Lynn Pettis (4/7/2014)

---

First, I have never used IronSpeed, but I take exception to you blaming the tool. It comes down to the person using the tool not knowing how...

Sean is right, you're overcomplicating things. You can use INSERT INTO...SELECT instead of values.

INSERT INTO dbo.HemTransfer (

TraTrtId

,TraAniId

,TraDate

)

SELECT 2

,ha.AniId

,ha.AniBirthday

FROM HemAnimal ha --This is a guess

WHERE ha.AniUserNumber = 123456

You might be overcomplicating yourself. Grouping by page will give you one row per page value. Using COUNT(DISTINCT column) will count for each unique value.

You'll end up with a code...

Sean Lange (4/7/2014)

---

Ed Wagner (4/7/2014)

---

Sean Lange (4/7/2014)

---

Greg Edwards-268690 (4/7/2014)

---

Sean -

Is the grass green?

I still see white and brown around here. 🙂

Sad about the refs - kids need to learn...

I was expecting to use an explicit transaction that will roll back at the end of the code within a try...catch block. This might not be the best option all...

djj (4/7/2014)

---

Because I forget about CROSSAPPLY as I have not used it as often...

Why would you want to scan the table four times when you can do it just once?

CREATE TABLE #Test( customnr int, number int, wk...

How do you differentiate customnr & number from wk1, wk2, wk3, etc.?

This might work for you. You should study about recursive CTEs to understand what it is doing.

If you have questions, please ask them.

WITH rCTE AS(

SELECT Id

,[NewId]

,1 AS n

FROM #Temp1

UNION...

Can you post your variables declaration?

You might have a truncation problem. Check the following code that looks the same but has an important difference.

DECLARE @ExtType varchar(10) = 'X',

@PhoneNo varchar(20) =...

Or try it without the NOLOCK hints which will...

What's your problem? You just need to remove the CTE and replace it with your table. You've mentioned that on the comments, so I can't see the problem.

That's a horrible way to do it. You're reading the table 4 times instead of one.

I gave you an example and an article that fully explains that method.

Check the following article on Cross Tabs: http://www.sqlservercentral.com/articles/T-SQL/63681/

WITH SampleData (PERSON, [DATA], [FIELD]) AS

(

SELECT 1234,'04/02/2014','Date'

UNION ALL SELECT 1234,'123','Department'

UNION ALL...

You need to cast Interval to a varchar value.