Posted by Ed Murphy on 05/25/07 15:45

kyle.fitzgerald@gmail.com wrote:

> I'm just know basic SQL but not enough to write any complex queries.
> The problem I'm facing right now keeps me thinking to use a Cursor but
> I've seen a lot of posts on here saying Cursors are bad so I'm hoping
> there is a complex query that can give me the data I need.

First off, post CREATE TABLE statements for your tables. Often a
redesign of the data layout makes the query much simpler.

• Next in forum: Re: view of max values from many tables
• Prev in forum: Re: SUBSTRING in User Defined Function - Invalid column
• Thread view: Re: Need Help with a SQL Statement - Trying not to use a Cursor

[Reply to this message]