Thank you both. Ran the code and makes perfect sense!!

Thanks so much. It was grouping them all by market, just that group header was choking. A fix that worked was doing the calculation at the data level in t-sql...

Super Thanks. I am working on what you perscribed!

OK so I added this:

SELECT Distinct GroupName

INTO #GroupNames

FROM MasterPatientIndex..tblMPICurrentData

WHERE GroupName IS NOT NULL

atthe end of course I dropped it.

Not exactly sure where I inner join Temp table?

Unfortunately, I am experienced with SSIS and front end apps, so even what you are talking about in the lookup table and report filter I would have to learn how...

Thanks all.

I understand now to the point where I know what needs to go down to the GROUP BY without guessing. Thanks to you all's help!

Ahh, I get how to use it now thanks!

ANSWERED and works fine:

I needed to declare the parms as = NULL up top, then use the ISNULL at the bottom where values are being passed in at the SET....

someone wrote on another forum to just use ISNULL in case nothing is being updated in that column, but this still is not workinf for me? STill get an...

Thank u all for the help! winhost.com supports asp.net 3.5 and has sql server 2008 4.95 per month plus 10 for a 1 uear domain name.

I ordered from amozon a...

Can someone still please help me with these 3 questions?

1. can I write a couple round trip events in c# asp.net, update a table in sql server, read from it,move...

I found one that looks good. win host.com is what I am going with. 4.95 per month $10 per year for domain name

Common ASP.NET Hosting Features - Included in Both...

Thanks very much. the links are helpful.

How is Dot Net Nuke related to all this.

Is it popular among windows based web developers and something I should consider employing?

Is...

Lynn and All, thank you for your help. I quit my job, moved my wife and I to Austin Texas (Texas is ranked high as having IT/IS jobs and one...

here is my basic table structure I used to pull data out using the above cursor if you get a chance to show hoe to do it your way.

As...