Sure This is my Sp and i need Check the BusinessBD If the @FDate

and @TDate is equal to GETDATE() else i need to bring the data from

ReportDB but am unable...

HI All,

am unable to retrieve a data between certain time

My table has a Data like this...

HI,

Thanks for your suggestion ,but i have tried this query

SELECT StartTime

FROM TicketTransaction

WHERE

convert(datetime,StartTime) <= '12:30 PM'

...

Thanks Shenel its executing the output but not exactly the record i need

for eg:

SELECT

StartTime

FROM

TicketTransaction

WHERE

StartTime <= '12:30 PM'

AND StartTime >= '05:30 PM'

The Output like :

05:45 PM

06:16 PM

06:16 PM

06:23...

Hi Ramesh,

Its working fine now thanks for your help

Regards

Karthik