Thanks Fitz. I will try this solution.

Why it is my query designer keeps hanging (not responding)

compiling this query. any idea guys. thanks.

While (1=1)

BEGIN

INSERT inTO ...

...

Hi Mark,

Sorry for my late reply.

I tried your solution upon running the query if my condition for @@rowcount is < 0 dynamically the date did not process the less...

Yes. I'm using t-SQL but inside the SSRS reporting tool. Tried already to place a keyword Set @PFromDate but still got an error. i already stuck for a few days...

got an error compling my query in query designer for my SSRS report.

Got an error , Incorrect syntax near '@PFromDate' . what wrong with this error.

i already declare this parameter...

This is what i do and its working.

=IIF(SUM(IIF(Fields!RESULT.Value LIKE "CHECK*",1,0), "DataSet2")>0,"Red","Green")

Here is my Query and it's already working. Thank you guys for the reply.

SELECT

p.itemid

,COALESCE(o.POReferencenum,u.vendref) AS POReferencenum

,p.PONumber AS UPSONumber

,o.USQtyOrder

,o.USQtyOpen

,p.PONumber AS RPPONumber

, p.RPQtyOrder

, p.RPQtyOpen

FROM #Purchase p

JOIN #Purchtable u ON

p.PONumber=u.ponumber ...

I got it..

Select

v.JOURNALID

,v.TRANSDATE

,v.ITEMID

,v.QTY

...

Guys,

Using this query, i got an error. any idea guys. thanks.

The variable name '@FromDate' has already been declared. Variable names must be unique within a query batch or stored procedure.

DECLARE...

Thank you guys for the reply.

Now my requirements is like this.

I have a parameter in SSRS report see sample.

i want to combine the fromdate,fromtime and todate,totime then stored

it...

Thank you guys for the reply.

I made some adjustment in the Query. put additional filter inside the Cross Apply and the process takes only seconds.

Thanks for the reply.

SOmething like this.

ESN----------------------Receiptdate--------returndate------Shipreturntype--SupplierID

001700001829830—2010-11-06---2011-05-23------7--------43

001700001829830—2010-11-06---2011-12-08------7--------43

001700001829830—2011-11-05---2012-03-08------2--------43

001700001829830—2011-11-05---2012-05-17------4--------43

Another Quetion:

What if i would like to get the max receiptdate from sample2.

here is my script but does not working properly.any idea. thanks.

Select

us.ESN,

max(asia.Receiptdate) as Receiptdate,

us.ReturnDate,

us.ShipReturnType,

...

THanks for the reply.

You mean like this..

Tablix properties ----Visibility-----then Show or Hide based on expression then i place this

scripts inside. and i try also the other one but still the...

I gave only the 3 months data as my sample.

I place having condition clause as i will run this scripts

for the past 3 month of the current month and...

Thank you guys for the reply.

I have to clear my requirements.

I want to pullout records based on date and time(hour).

In my samples i have date range from 2012/06/04 and 2012/6/5...