😀

How could I have taken this: -

I'm...

Well, personally I am learning T-SQL by reading countless books and sticking around here answering questions posed by others. Often,...

Using this sample data: -

--Sample table

IF OBJECT_ID('tempdb.dbo.SampleTable', 'U') IS NOT NULL

DROP TABLE tempdb.dbo.SampleTable;

--Sample data

CREATE TABLE dbo.SampleTable (PK INT PRIMARY KEY CLUSTERED, C1 VARCHAR(10), C2 VARCHAR(10), C3 VARCHAR(10), C4 VARCHAR(10), C5...

I have no idea what you want me to send you. What "standard sql tutorial" ?

Don't really understand what you're asking.

Read more about the cross-tabs technique in Jeff...

Something like this: -

DECLARE @sql AS NVARCHAR(MAX);

WITH t1(N) AS (SELECT 1 UNION ALL SELECT...

Not going to comment on the table design, as I'm sure others will mention that it's not exactly "best".

BEGIN TRAN

SELECT CreatedBY, UpdatedBY

INTO TableWO

FROM (VALUES('user1', 'user2'),('user1', 'user1'),('user2', 'user3'))a(CreatedBY, UpdatedBY)

SELECT UpdatedBy, DataType...

Does it need to be dynamic? Or do you always know that there are no more than 3 HRA ?

I'd use CROSS-TABS instead of PIVOT, as I've found that...

Hmmmm, seems very very similar to this question from a few days ago.

As in the last post I made on that thread, if the sample data and ddl can be...

SQLKnowItAll (3/1/2012)

---

To the OP, although the semi-colon is used to terminate a preceding statement... a CTE must ALWAYS begin with one. This is why many people put it before...

Thanks Eugene for the data that the OP hasn't provided.

You mentioned a dynamic cross-tab solution, but didn't use a static cross-tab solution and instead hit the table a lot. Any...

Please read this article --> http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D, then post your sample data and DDL in a readily consumable format. Help the unpaid volunteers of this site to help you, and...

OK, I'll give it a go but I've been told before that my teaching method comes across as abrasive.

First, we want to figure out the counts for each organisationID and...

Also, read this article --> http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D, then setup your sample data and DDL script in a readily consumable format. After you've done that it's much easier to help. ...

Which above code? Did you use the CLR?