Jeff,

Thank you very much for your help. Just curious to know how to make it as dynamic SQL?

Helal

Yes, I understand the parameters and have done parametized reports. I was hoping for a little more glamorous page where users select the filters and the fields they desire and...

Thank you all...worked great.

Not much benefit rather it's a requirement for the report...that if names are repeated with the same id, then add a counter.

I am not sure what you mean by logic error! I think the code I am suing is not suitable for what I need...is that what yo urefer to logic...

Lynn,

you were right, I should have provided descriptons as what I am tryin gto do. Here is the when running the query:

Name1Name2Total

X1 Y1 8

X2 ...

Thank you for yuor quick response...but as you indicated, figures don't match up and tha's what I need

Helal

Thank you so much for your quick response. With your tip, I found the problem in where clause. Thax again.

I have yet to try what MM posted. But I foudn this solution and it's working:

ISDATE(A) = 1and len(A)=10

Anyway, thank you for sendin gme the right direction.

Helal

I undrestand, but I am only the developer and don't have much control. And yes, all date are stored as MM/DD/YYYY.

Thx Lowell, I received this error after applying the codes

"Conversion failed when converting date and/or time from character string"

after looking at the data in A, all codes are excluded excpet...

Awesome....worked liek a charm.

Thank you for catching that. Here is the corrected and tested DDL. I did try left join but can't get them lined up the way presented in results (MergedTab).

IF OBJECT_ID('TempDB..#table1')...

Awesome...Thank you so much. Worked like a charm.

Helal

it's in the post right after test data. I indicated that the result should like this:

The Result should look like this with Status assigned as New, Active, nad Inactive.

CREATE...