Thanks Antares686,

My Dataset is called 'No_Assignment' so to get a rowcount of the dataset on the report would it look something like this?

=countrows(No_Assignment)

Ok thank you for your help, I'll look into incorporating your suggestion.

Thank you qallan, is that a vb.net expression?

Wow, Thanks Andras, your reply was very quick and accurate.  Thank you for the expanation, it worked.

Thanks Aaron and Bob,

here was my final query that worked.  A Pivot would have been nice, but I am still trying to wrap my head around how to put one...

Yes you're right.  I just realized that.  I only need the update statement.  I am totally making my life more complicated than it needs to be.  Time to go home,...

Thanks for your response Bledu I've tried your suggestion which makes sense, but I'm getting a syntax error saying: 

 Incorrect syntax near the keyword 'group'. 

Here is my query...I...

Thank you Michael, you solution worked best for me.  I was also able to come up with this, which gave me the same result.

SELECT id, datevalue1, datevalue2

FROM tbl1

WHERE convert(decimal(19, 5),...

That worked Jeff!  You're my personal hero today. 

Thanks,

have a good weekend.

Hi James & Mark,

here is the actual code with the error message:

Code:

occ_archives

insert into asqcrr.occ_archives.dbo

Hi guys, thanks so much for your help, your suggestions make sense but I am receiving the following error message.