Yes. So i just displayed in VArchar but sorted using Datetime.
Sorry for this post. I think without doing research on my code i just put in the forum.
Hi all, i have the following code SELECT CASE WHEN [Service Header].[Document Type] = 0 THEN 'Quote' ELSE 'ORDER' END AS [Doc Type], [Service...
Hi Madhivanan, Yes if there is no value for response dae it was assigning it 1/1/1753. Anyway with one the member of this forum helped me to solve...
Hi, Here is the full code. SELECT Item.No_, Item.Description, ILE.Inventory, SO.[Qty on Sales Order], PO.[Qty on Purch Order], Customer.Name,...
Thank you. This is done. So similarly i can do for NULL dates. I mean if the response Date field have no value it is printing 1/1/1754 now so i can...
Hi, I have the following query in which i have one integer type field called Status. But what i want to display is some meaningful data on this...
Hi All, I wrote the following Query SELECT Item.Description,Item.[No_],POC.[Qty on Component Line] FROM [Company Name$Item] AS Item LEFT OUTER JOIN...
I wrote the following code. But i m getting error that MIN is not a recognized built in function.SELECT [Prod_ Order No_],[Location Code],[Item...
Yup Now its working fine.
Hi Preethi, Thanks. I have modified the query. This is wat you were saying? SELECT ProdOrder.No_, ProdOrder.Description, ProdOrder.Status,...
Hi All, I wrote one query as SELECT ProdOrder.No_, ProdOrder.Description, ProdOrder.Status, ProdOrder.Quantity,ProdOrder.[Location...
Thnak you. Thats doubt i have but its clear now. Its working perfectly now.
I have the following query SELECT Item.No_, Item.Description, Table1.Inventory, Table2.[Qty on Sales Order], Table3.[Qty on Blanket Order] FROM...
Hi Preethi,I wrote the code like this but still not geeting the desired result what i am expecting and as explained in my previous mail.May i have...
Hi,Thnaks for your effort dear but this is not i want. With this first i am not getting all the lines for TRansfer Lines Tables second suppose if i...
HI, I think you didnt get my Point. I have 3 Tables as per above query. Transfer Line Document No. Item No. Item Description XYZ...
Hi, Thanks for your promp replies. Ok let me explain more about wat i want to acheive. I have a transfer Line Table with 37 records and have fields...
Yes Adriaan. The result is not as expected. I am using Navision Tables( Navision- Microsoft Dunamivs Nav). The transfer Line table contains 37...
Wats wrong in this query? SELECT [Transfer Line].[Document No_], [Transfer Line].[Transfer-from Code], [Transfer Line].[Item No_], [Transfer...
Separate names with a comma.
