Hi Nevyn, pls don't blame yourself, we learn better everyday, if you blame yourself, what should i say of myself.

Take care.

Timotech

Hi, Thanks for your replies, but most books that we read use these conventions that i use, any way i tried something and its working but with a little issue....

Hi Nevyn,

Thanks for your help, Pls i need one more help, I need to add another column to the results that i have, this is the column i want to...

Hi Chris, you're the man, it worked perfectly, Thanks so much

Timotech

Hi thanks for your hints, let me repost the data like this, may be u'll understand, because there's no existing table for that query:

CREATE TABLE #mytable(

Category nvarchar(35),

Station nvarchar(20),

Brand nvarchar(20),

Sun INT,

Mon...

thanks for your reply, yes i want the days of the week to be column headers, with the count information below.

Thanks

Timotech

To me you're a genius, and i would like to have your email, incase i need to contact u personally. Thanks

Timotech timotech@yahoo.com

Hi Nevyn, you're more than the man, you're a genius, a guru. Thanks so much, i've finally achieved what i wanted.

Thanks it worked perfectly.

Timotech

Hi nev, Thanks so much for your help, after looking closely at the result, i discovered that some of the records were having nulls as description and category like this:

2187...

Hi Nevyn, you're the man, it worked perfectly, Thanks so much

Hi Nevyn, Thanks for your reply,

I tried the following code that you sent:

DECLARE @BeginDate datetime

DECLARE @EndDate datetime

Declare @ProductId nvarchar(6)

Declare @CategoryId nvarchar(3)

Set @BeginDate = '1/5/10'

Set @EndDate = '31/5/10'

Set @ProductId = 'dri006'

Set...

Hi Nev, thanks for your reply,

The code works wonderfully, the only remaining thing is that there are some Tele records and some radio records that are not displayed because of...

Hi, I tried to recreate the table and then saved from my application into the table, which succeeded, but when i try to search again, it did not return any...

Hi Vidya, thanks for your post, the query works fine, i also tried it with <= (a specified date) and it also brings result, but when i try it with...

Hi, thanks for your reply, its baffeling me also, this is the query:

SELECT PKID, ISNULL(Location,'') AS Location, ISNULL(BoardNumber,'') AS BoardNumber, ISNULL(FK_BoardSize,'') AS FK_BoardSize, ISNULL(FK_BrandId,'') AS FK_BrandId,...