Wow!!! bt....

this is an unbelievable code man.. I think I can use this part and find an answer let me give it a try..

thank you so much...I have been trying...

OMG...thanks,its very complex code........ I know how to pivot /crosstab data, I can do that and post it here but first this is not happening at all...

the code is great...

Thanks for your reply,

Actually The result looks good but still there is something that I want to eliminate , i have to use the order coming from source, i cannot...

actually this table is not for actions it is for transaction, how many transactions came everyday, so for one transaction there may be 2-5 actions but I have to show...

Hi

thanks for your reply but the actions are not specific or pre defined...I cannot hard code the actions as I dont know what action I may get....

Let me put it like this...

from the source i may get more than one row for a tran id but I need to load the destination based on tran id...

you can do this using

UNION (if you want no duplicates)

or UNION ALL (if you want duplicate rows too)

you can do this using corelated join

select r.rxno,r.patid,h.sig.h.posted from reoders r

inner join hrxs h on

r.rxno = h.rxno

where hrxs .postedate = (select max(b.posteddate) from hrxs b

...

declare @amt nvarchar(60)

set @amt = '-10299.50'

select convert(decimal(9,2), @amt ) as Result

Thanks all for your reply,

I cannot use SUM as I am counting a Key column here and if I use sum it will sum up the columne instead...

I have to...

thank you all it is counting fine,,

actually I was joining witha table for this col1 so it was excluding NULLS there...but now i am using coalese so it works...thanks again

Thanks for quick response,

I need a case statement and need to count another column based in first column is null or not, I have many cases but this NULL...

Hey Rex,

I have not recieved exact answers to put into my post, Please provide me I will add them to my post then.

Its just that I have got...

Hey 🙂

Thanks a lot Imu,

It works like a charm....... 🙂

Thank you again.

Hi,

Thanks for your quick response...

I need to show month also but as i include month in query count goes down,I need to show the keys (order and cust) along with...