470,833 Members | 1,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,833 developers. It's quick & easy.

working with multiple datasets

I currently have a vb.net application that reads ado datasets that are from
views withing sql 2000. To "cheat" for the moment I have a view that only
gets records within a certain time frame and then another view that SUMS
those records. My application creates a dataset from the second view.

However, now the time stamps used in the first view need to be dynamic. I
need to be able to choose the start and end dates, and some how get that
first view to only return records in timeframe.

I was thinking of creating a temp table in sql, but do not know how to pass
the dates into a stored procedure. Should I select and then insert into a
table and then work with that table?

Any ides would be appreciated. Thanks!
Jun 21 '06 #1
0 782

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Chumley Walrus | last post: by
3 posts views Thread by TomH | last post: by
reply views Thread by robin9876 | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.