hey i solved this problem , i used following code:

where     TransactionDate >=dbo.FormatDate(@TDate+'12:00:00.000 pm' )

AND   TransactionDate <=dbo.FormatDate(@TDate+'11:59:59.999 pm')

now just tell me is this a fine way to do that or not?...

hey terry thanx for ur reply, and the solution to do this with the other way, thanx once again, but the problem is ,

when i give a range of...

Hey Terry once again thanx for ur reply, but i dont need this format of the result, i was doing this at start but as i said u

earlier that...

Hi Terry, i didn't get ur point, i want to make count of pins that were sold on that day at each hour can u plz again define the Query...

Hey Adrian Nichols, thanx FOR ur reply, i didn't' get ur point , AS IF u see me query i used the comparison::

SELECT

COUNT(CASE WHEN datepart(hh,@datetest)= 10 THEN dbo.TransactionLineItems.PinID END)...

i solved the problem that i posted above, now the issues come abt data format.

now i want to pivot the data, how can i this , as if i...

here is my query, sorry i forgot to write this in my post, now i want to make a SP , check my previous post and then...

Thanx for replying but i need white papers in pdf format , i want to critical analyze one of the above follwing given topic as a my term project, i...

No homework and ofcourse no Quiz i want to make a Chart for this i want to take values in differnt styles and order . If u can help me...

No homework and ofcourse no Quiz i want to make a Chart for this i want to take values in differnt styles and order . If u can help me...

Heelo Ijaz, thankyou so much for ur reply,now its working fine, i mreally thankfull n greatfull to you.

Thanx again,

Hello, once again ijaz, sorry for disturbing again, but i need little bit help as i used ur query it reurns the result accurate but not 100 % , i...

Hi Ijaz, thanx for ur reply, actually at that time i m stucked in this problem and can't find any solution actually my dev is waiting for this SP so...

select top 1 (select count(*)  from suppliers where RegistrationDate='12/11/2006') as '7',

(select count(*)  from suppliers where RegistrationDate='11/11/2006') as '6',

(select count(*)  from suppliers where RegistrationDate='10/11/2006') as '5',

(select count(*)  from suppliers where RegistrationDate='9/11/2006')...

thanx ijaz, u got my point but not 100 % actually i already have a suppliers table, now i want to display how many suppliers login in 1 day .

as...