Sorry, just saw your way using cte...let me try this and I will get back to you.

Thanks again.

Hi Lowell,

I see your point. As soon as I ran that query using a temp table instead, it ran like in 2 secs. But my problem is I would have...

Thanks. I will issue a ticket then.

Just to be more specific about the sql server 2005 that I am using,

Product version - 9.00.4028.00

Product Level - SP3

Edition - Standard Edition

Thanks John! I found an article on codeproject which helped me a lot. But thanks for your help too.

http://www.codeproject.com/KB/database/Pivot2Columns.aspx

Sid

I think I got to a point where I can display the result by date.

SELECT[1/7/2009],

[1/9/2009],

[1/11/2009],

[1/13/2009],

[1/15/2009]

FROM(SELECT[Date],

[Count],

MediaBuyer

FROM#t

) p PIVOT (SUM([Count])

FOR [Date]

IN ([1/7/2009], [1/9/2009], [1/11/2009], [1/13/2009], [1/15/2009])

) As pvt

I...

Now I get it. Thanks a lot for your help on this.

Sorry to confuse you but I would need to update tableB with data from tableA thats not in tableB.

Since, in this case, a dealerid and ISCI fields make a row...

I am sorry not to provide you enough samples. In most cases, multiple dealers have the same ISCI codes.

Your example:

DECLARE @tableA TABLE (DealerId varchar(10), ISCI varchar(10))

DECLARE @tableB TABLE (DealerId varchar(10),...

Thanks GSquared. Awesome!!

Thanks GSquared. The only question is how would i handle for cases when a row has one zipcode. So it will be something like

ID ZipCode

1 51254

Would...

Duh! I didn't look at the data closely after I changed the datatype to memo in access. All the zips are coming in now and I successfully imported that data...

I looked at this forum :

and did the same. First imported the data to access and then imported to Sql. This time it worked but still there is a...

Hi SilverFox,

Do I have to do that manually or is there a way to...

Hi Matt,

Thanks a bunch for the script. That worked like a charm. I tried the script and it worked great. Now,...