Please help need it urgently.. project is in process
What I have tried:
CREATE PROCEDURE [dbo].[OnelinePODate]
AS
BEGIN
Select Main.Ibill_no,
Left(Main.PoNo,Len(Main.PoNo)-1) As "PoNo",Left(Main.PoDt,Len(Main.PoDt)-1) As "PoDt"
From
(
Select distinct ST2.Ibill_no,
(
Select ST1.PoNo + ',' AS [text()]
From dbo.items_sold ST1
Where ST1.Ibill_no = ST2.Ibill_no
ORDER BY ST1.Ibill_no
For XML PATH ('')
) [PoNo],
(
Select cast(ST1.podate as char(11)) + ',' AS [text()]
From dbo.items_sold ST1
Where ST1.Ibill_no = ST2.Ibill_no
ORDER BY ST1.Ibill_no
For XML PATH ('')
) [PoDt]
From dbo.items_sold ST2
) [Main]
END
CREATE PROCEDURE [dbo].[OnelinePODate]
AS
BEGIN
Select Main.Ibill_no,
Left(Main.PoNo,Len(Main.PoNo)-1) As "PoNo",Left(Main.PoDt,Len(Main.PoDt)-1) As "PoDt"
From
(
Select distinct ST2.Ibill_no,
(
Select ST1.PoNo + ',' AS [text()]
From dbo.items_sold ST1
Where ST1.Ibill_no = ST2.Ibill_no
ORDER BY ST1.Ibill_no
For XML PATH ('')
) [PoNo],
(
Select cast(ST1.podate as char(11)) + ',' AS [text()]
From dbo.items_sold ST1
Where ST1.Ibill_no = ST2.Ibill_no
ORDER BY ST1.Ibill_no
For XML PATH ('')
) [PoDt]
From dbo.items_sold ST2
) [Main]
END
Midhun TpPosted Sep 14, 2016, 10:40 AM
Midhun TpPosted Sep 15, 2016, 12:08 AM
Pradeep ShetPosted Sep 14, 2016, 11:56 PM
Nirmal GhoshPosted Sep 14, 2016, 3:10 PM
Pradeep ShetPosted Sep 14, 2016, 2:39 PM
CONVERT(VARCHAR(10),GETDATE(),110)
CONVERT(VARCHAR(11),GETDATE(),6)
CONVERT(VARCHAR(11),GETDATE(),106)
CONVERT(VARCHAR(24),GETDATE(),113)