Yes Jeff Moden,

I'm back..!

The query i was thinking is similar to your query, and here is mine..

SELECT t1.zone,t1.Class,COUNT(Item) Cnt

FROM

(

SELECT zone,Class,Item,SUM(sales) sales

FROM sales

GROUP BY zone,Class,Item

)t1 INNER JOIN

(

SELECT zone,Class,SUM([sales]) sales

FROM...

Thats a little bit disappointing to here..:(

But Thanks a lot for spending your valuable time..!

Regards,

Ramu.

what do you mean by "single query".?

You can use sub queries to achieve this.

Regards,

Ramu

As of my knowledge, No you can not directly use GROUP by as you can not use aggregate functions in an UPDATE query.

But you can use a sub query which...

Hello there,

when i try to execute the procedure its throwing the following error,

" Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'. "

Can any one help me what is the problem?

Regards,

Ramu

Hi Nimdil,

I tried your query, and is perfect.

Anyway to delete duplicates either you should have a row number or one key column, right?

Dreamsz - Can you tell us how exactly...

You can try this (small modification to the above query),

select distinct Role_Code1 from temp

where Role_Code1 not in

( select Distinct Role_Code2 from Temp where Role_Code2 is not NULL)

probably b'cos of...

Hi brewmanz,

You are right, i did get the ...127 and not .128.

My apologies for posting wrongly.

Regarding,

Ramu

And actually there are two answers.

2009-01-31 00:00:00.000, 2009-01-31 00:01:01.000, 2009-01-31 12:59:59.128

2009-01-30 00:00:00.000, 2009-01-31 00:01:01.000, 2009-01-31 13:00:00.995

2009-01-30 00:00:00:000, 2009-01-31 00:01:01:127

2009-01-31 00:00:00.000, 2009-01-31 00:01:01.000, 2009-01-31 21:59:58.347

2009-02-1 00:01:01.000, 2009-01-31...

Thanks a lot hkphooey for your reply,

It worked exactly the way what i wanted.

But can u explain what is the difference between the functions ToString to CSTR and IsNothing to...

You can simply try without using cast and convert...

Eg: WHERE a.Created_date BETWEEN '01/04/2007' AND '01/06/2007'

Regards,

Ramu

Yes, i'm using SP2 and also Office 2007.

I've faced the same problem in the machine where SP3 installed.

For info: I'm using gif images in my report, those are the...

No, its a jpg image.

As of my knowledge, we can not edit a pdf file unless we have a pdf editor.

Regards,

Ramu

Use RowNumber(Nothing)