Search results for query: *

Hi , I would like to return a date based on today's date. Only the day and month should be same with yeAr part replaced by a field. On 3rd July date returned should be 03/07/"oeshdt.yr". I have tried cast(datepart(dd,getdate())+'/'+datepart(mm,getdate())+'/'+oeshdt.yr ) as datetime resulting...

That fixes it. Thank you

Hi , I need the prev doc number by date for record combination of item and customer. Below is returning the same top1 value for all main query result. TABLE CUST ITEM TRANDATE TRANNUM A CB 21/3/2012 IN20123 A CB 15/3/2012 IN20100 A XY...

Just what I needed.Many Thanks Jonfer.

Markros, SQL 2008 server. The whole query is selecting a Item from master item table, and adding subquery to return qty on sales order, PO and committed to production. In the above instance Table c Itemno Table a Itemno (master item) Bomn Qty Table b Itemno (master item) Bomno Component...

Hi All I need to use this query as a subquery select sum("A"."QUANTITY" * "B"."Qty") as Qty from A Inner Join B on "B"."ITEMNO" = "A"."ITEMNO" and "A"."BOMNO"="B"."BOMNO" and "A"."STATUS" = 1 group by "B"."Component" with the complete query returning "C"."ITEMNO" Qty with...

lbass, Thanks for the reply. I don't want to supress rows which dont have a value. I want the value if {OPTFIE} if it exists and return null if there is no value.

LB The existing sub is placed in detail b of main report and works as required. Now need a new field in the sub report from above table. I need to link the existing "Item No" field in the sub with the "Item No" in OPT table ( shown prev)and return the value when "OPTFIE" is 'GHI' Exisiting...

Hi I have a table like below ITEMNO OPTFIE VALUE 1 ABC XYZ 1 DEF UVW 1 GHI RST 2 ABC OPQ 2 DEF STU I need to get "VALUE" - RST for a subreport and place it as a column for each detail line...

SBS 2003, workstation running XP. Every week Netlogon has this msg on system log "No Domain controller avail for domain XXX. Not enough storage space is available to process this command. Make sure system is connected to network and try again........". "The server was unable to allocate from the...

markros, neat query, does exactly what i wanted. Thank you

Hi All I have one table as below POSeq Line Num ItemNO UnitCost UnitConv Date 1234 456 XYZ 20 10 2010,10,10 1255 496 XYZ 30 10 2010,10,20 1256 497 ABC 20 10 2010,10,21 Query to return ItemNo...