Yes jason, very silly of me.. there were no join in that query.. i just watched that group by and said that.. thanks for pointing it out though 🙂

OMG, so many replies whilst i was decorating my code.. lol...:-D

Great going at SSC...

Cheers..

Buddy, dint your subquery (which u used for the lookup alias) give the result u wanted?

Else, try this.

SELECT

T1.FIELD1 , COUNT(T2.FIELD2) COUNT_VAL

FROM

...

I am getting closer to what u need of that string.. but still bit unclear though.. u have around six parameters in your string that need to parsed and stripped...

Hmmm.. cool.. but before u could post question, i hope that u had looked over that link i specified in my earlier post on how to post question to get...

Kingston's code will also work but for a small change..you...

Hey buddy, i really had free time, so i created all the DLLs and some sample rows..

AND, the QUERY for you as wel..

DDLs

--===== CREATE TABLES

IF OBJECT_ID('OWNERS') IS NOT NULL

DROP TABLE...

Hi Buddy,how about you going through this following article and helping us help you?? 🙂

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do so, i am sure a...

This will give you what u wnat mate..

WITH MIN_MODIFIED_DATE_FOR_EACH_ID (ID, MIN_DATE)

AS

(

SELECT

ID,

MIN(ModifiedOn)

FROM

#Schedule_Audit

WHERE

...

precisely.. 😀

You wil have to use dynamic SQL for this.

Like

if object_id ('tempdb..#t1') is not null

drop table #t1

if object_id ('tempdb..#t2') is not null

drop table #t2

create table #t1(ID numeric identity(1,1), Product varchar(10))

go

Insert into...

Buddy go thro this article

http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/adc78696-9b31-4ffd-b881-5a2f87249cfd

Oh yes.. 🙂

:-D, Lynnn, thats very basic , isnt it.. 😛 ... wonder how the OP missed filtering the rows directly by WHERE clause..

Wow... awesome question.. i misread "while" to "If" in the question and was thinking why this one will end up in a loop.. lol..:-D

good loopy question :w00t: