Michelle,

I’m really not clear on what you are trying to achieve — what output are you expecting/wanting?

Can you tell me if the crm partners are known ahead of time? ...

Hi,

Here is a solution based upon tally table ( http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url) for normalising the structure of @abc.

First of all set up tally table

--=============================================================================

-- ...

I'm no expert, but I'd say patience — e.g. with inexact informational requirements.

oh, and an ability to google.

That's some time delay, if it's a cross post, I blame ZoneEdit

Hi there,

you need an INSERT with a SELECT clause.

Hi,

You’ll need an update statement, something like:

UPDATE tbl2

SET PID = tbl1.PID

FROM tbl1

WHERE PNUMR = tbl1.PNUM

Allister

Hi Michelle, the #PivotTable was created from the sample output from your first post.

The code you have posted in your last doesn't use this table, I'm guessing you want to...

Look for the Edit mapping button when your are selecting the source table, this should open a column mapping dialog, in the destination column select the <ignore> option for the...

Hi Michelle,

There's no guarantee that I can help, but if you post some sample data, the code that you are working on and the output you are wanting, I can...

You can find a good explanation of ROW_NUMBER at the following url: http://www.sqlservercentral.com/articles/T-SQL/66512/

I changed the structure of #Ranking, adding the ConsecutiveDays when the table is created, hope this helps.

drop table #Ranking

CREATE TABLE #Ranking

(

[Name] varchar(50),

[Item] varchar(7),

Variant varchar(3),

RegDate datetime,

AbsenceDate datetime,

ConsecutiveDays int

)

INSERT INTO #Ranking ([Name],...

?second iteration Lynn 😉

Thanks Lynn... Just here trying to learn stuff I should of got to grips a while back... answering (trying to) queries gives me excuse to play with sql...

also incomplete...

One statement to make the report... one to correct it!

Nice one Lynn, the null was killing me!