I would request a couple of extra monitors in a private meeting area as I'm sure there would be someone I would want to chat with at a conference and...

I work for a software vendor and we have both encrypted and non-encrypted procedures in our db. Usually we use it to denote something that is critical to the...

You don't need to include the AmtSign in the group by (as your code shows) and once you don't include it in the group by (which is unnecessary as it...

Brandie,

I have yet to find an instance where copying the CASE statement to the GROUP BY clause has not satisfied the need for grouping, but you mentioned you have experienced...

Brandie,

Having a field referenced in a CASE within the SELECT statement does not specifically require the field to be part of the GROUP BY clause. It will work if...

Thanks so much. Worked like a charm.

What was the problem and how did you solve it? If you leave it up, you may help the next person that encounters the same issue.

didn't see this was underway in a different forum before i posted, sorry about that. also, the code isn't tested so i apologize for any typos and syntax errors...

assumptions: you want to use lname, fname to order your results for selection or order does not matter, fname/lname combo is the primary key in masterlist

DECLARE @iStartPosition INTEGER

SET @iStartPosition=3

WHILE (SELECT...

The posted solution may not return all data. If the date doesn't exist in the first view, it will not be used in the output.

Do any of the views have all of the dates you will need?

Do you need all of the rows or are you looking for a particular subset of the data?...

This might work for you

SELECT DISTINCT WM.Woman, GY.Guy

FROM Woman WM

INNER JOIN Guy GY ON GY.Char=WM.Desired

WHERE (SELECT COUNT(1)

FROM...

This is a possible solution. I am not sure how to avoid it, but I'm sure someone will post another solution that doesn't go RBAR which would definitely be...