June 3, 2002 at 3:45 pm
Hello everyone-
We recently migrated from Access to SQL 2000. We have a very complicated form that we use in Access, and some of the data in the form is dynamic pulling data from a "View Totals" query. The view totals query is based on another query, and i'm having a heck of a time trying to write T-SQL for these total queries. I failed to mention that we are currently using Access as the front end since we have our detailed forms in access. is there an easy way to do SUM, FIRST, LAST, GROUP BY, etc. type queries in SQL Server?
Also, in the upsizing wizard, many of the queries did not come across. What is the limiting factors on which queries translate across, and which don't? Thanks for any insight...
Dave Oakley
June 3, 2002 at 5:52 pm
There are a few syntax differences and sometimes requires you to rethink what was going on to come up with the right solution. As for
quote:
Also, in the upsizing wizard, many of the queries did not come across. What is the limiting factors on which queries translate across, and which don't?
I don't know, sorry. However, in regards to the queries if you want to post here we can look and offer help.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 3, 2002 at 5:56 pm
Please do not crosspost, duplicate message see http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4593&FORUM_ID=8&CAT_ID=1&Topic_Title=Easy+way+to+View+Totals%3F&Forum_Title=T%2DSQL for responses.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply