Sean Lange (3/29/2016)

---

SQLRNNR (3/29/2016)

---

Sean Lange (3/29/2016)

---

Finally!!! Somebody who claims experience with sql server that knows getdate(). The response was much as I would expect. An immediate answer that sounded timid...

suggest you read this article on how to post.......makes it so much easier for all involved in helping you

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

<<deleted>> OP answered whilst posting

kaplan71 (3/25/2016)

---

Hello --

Thank-you for your posting, I ran the script you posted, substituting the actual patient ID in the appropriate slot. However, the query produced the following error for

each of...

ssisguy (3/24/2016)

---

I need to pick earliest Security Date for each Security Id ..see attached sample text..

for security id 10000 securutiy desc cahnged from abc to xyz and it should...

oop error in previous code

try this

USE tempdb

GO

-- create a temp table that unpivots the data you previously provided as "mytable"

-- only create records where there was actual attendance ...

heres a few thoughts

hopefully code comments explain

EDIT -- error in code posted...please new post below

maybe easier if we worked on the recordsource rather than the pivot me thinks.

can you supply sample data for the base recordset?

ok...will take a look later

can I repeat my earlier question please

is this...

having now looked at your sample data, I am none the wiser.

you have 39 rows...all of whom it "appears" attended in year 2013 (assume that "1" = attendance).....but none...

pk...based on your data that you have now supplied....what are your expected results, based on this data?

suggest you read this link and post back with suggested details

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

your question appears a bit sparse in detail...can you explain , maybe with examples, of what your...

does this help ?

Count(*) over(partition by av.CreatedBy,av.EventTypeID) Total

well you use it in your dynamic code

SET @query =...