And you can have a single stored proc return two result sets. Look into table valued parameters. You have to set it up as type first but then you can...

You could do it in a single dataset but it is pretty craptastic. You would have to make your temp table allow for nulls in all columns. Include a rowNumber...

From looking at your sample you might want to look into nested sets. Do a search on google for nested sets and you should find plenty of examples. It is...

It really sounds like you want two result sets? Maybe you should just create two stored procs? One for each resultset. Would certainly keep it simple. I would suggest that...

Looks like you did that. You inserted some data into a single table with two different insert statements. If you want to be able to get a hold of that...

ahhh missed that. so for one set you want only 3 pieces of information and for the the other set you want 2? Still not really sure what the output...

Happy to help. I too have been thrown into those kind of systems. The learning curve is more like a vertical wall. Painful but once you understand and are able...

You have two insert statements.

INSERT INTO #Test (OfficeID, PatientCount, PatientCountUnique)

and

INSERT INTO #Test(ItemCount, ItemCountUnique)

They don't insert into the same columns. You will get a table that has 5 columns. 3...

tacy.highland (8/16/2011)

---

Another good point. Thanks for all the help.

Question though, if this column is in Date format and the other fields are smalldatetime and I do a DATEDIFF between the...

Maybe we could have sql server make dinner right after it gets done using Outlook? 😛

In all seriousness what exactly are you trying to do?

No problem. It is always best to store your data in the correct datatype for the value. Makes life so much easier down the road. Sorry if I sounded snippy...

The best (and only way imho) is to forget the date to int thing and put your date in a datetime field. You wouldn't put a character in an int...

You could use Jeff Moden's awesome splitter[/url] like this:

declare @Name varchar(50) = 'MOUSE, MICKEY X'

SELECT Item as FirstName, Left(@Name, CHARINDEX(',', @Name) - 1) as LastName

from dbo.DelimitedSplit8K(LTRIM(RIGHT(@Name, CHARINDEX(',', REVERSE(@Name)) - 1...

No problem. Feel free to come back anytime for sql help.

This really is not a vb.net forum. You should go to an asp.net forum for this kind of help. http://forums.asp.net/%5B/url%5D is a good place to start. I can guarantee you...