how to use stuff function

Question

1.00/5 (1 vote)

See more:

SQL

DECLARE @GetAbsenteeDate TABLE
( 
	TM_UserID INT,
	FullName VARCHAR(255),
	AttendanceDate DATETIME
)

 
D

Posted 4-Mar-14 23:34pm

Member 10501509

Updated 5-Mar-14 19:30pm

v4

Add a Solution

Comments

Member 10501509 5-Mar-14 5:37am

Excepted output
311 Aditya Mahapatro 05 Mar 2014,06 Mar 2014
560 Aishwarya Shekar 05 Mar 2014,06 Mar 2014

2 solutions

Solution 1

I hope it will help you

try your self

SQL

-- Day first
SELECT CONVERT(VARCHAR(12),GETDATE(), 103)  -- 25/11/2011
SELECT CONVERT(VARCHAR(12),GETDATE(), 105)  -- 25-11-2011
SELECT CONVERT(VARCHAR(12),GETDATE(), 104)  -- 25.11.2011
SELECT CONVERT(VARCHAR(12),GETDATE(), 106)  -- 25 Nov 2011

-- Month first
SELECT CONVERT(VARCHAR(12),GETDATE(), 101)  -- 11/25/2011
SELECT CONVERT(VARCHAR(12),GETDATE(), 110)  -- 11-25-2011
SELECT CONVERT(VARCHAR(12),GETDATE(), 100)  -- Nov 25 2011
SELECT CONVERT(VARCHAR(12),GETDATE(), 107)  -- Nov 25, 2011


-- Year first
SELECT CONVERT(VARCHAR(12),GETDATE(), 102)  -- 2011.11.25
SELECT CONVERT(VARCHAR(12),GETDATE(), 111)  -- 2011/11/25
SELECT CONVERT(VARCHAR(12),GETDATE(), 112)  -- 20111125

 
-- Time only
SELECT CONVERT(VARCHAR(12),GETDATE(), 108)  -- 06:21:42
SELECT CONVERT(VARCHAR(12),GETDATE(), 114)  -- 06:21:51:610

--Only One
SELECT DATENAME(MONTH, GETDATE())   -- November
SELECT DATENAME(DAY,GETDATE())    -- 25
SELECT DATENAME(YEAR, GETDATE()) -- 2014

Posted 4-Mar-14 23:55pm

Amalraj Ramesh

Updated 5-Mar-14 0:11am

v3

Comments

Member 10501509 5-Mar-14 6:07am

where should i implement above code

Amalraj Ramesh 5-Mar-14 6:32am

You want nextdate with comma seperation im i right???

Member 10501509 5-Mar-14 6:43am

no
311 Aditya Mahapatro 05 Mar 2014 is Absentee for this date
560 Aishwarya Shekar 05 Mar 2014,06 Mar 2014 is Absentee for this for two date

Amalraj Ramesh 5-Mar-14 6:36am

Try this
SELECT TM_UserID
, FullName
, (CONVERT(VARCHAR(11),AttendanceDate,106) +','+ CONVERT(VARCHAR(11),DATEADD(day, 1, AttendanceDate),106)) AS AbsenteeDate

FROM
@GetAbsenteeDate
ORDER BY
FullName

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amalraj Ramesh · Accepted Answer · 2014-03-05T00:37:00

Solution 3

try this one

SQL

SELECT TM_UserID
     , FullName
     , (CONVERT(VARCHAR(11),AttendanceDate,106) +','+ CONVERT(VARCHAR(11),DATEADD(day, 1, AttendanceDate),106)) AS AbsenteeDate

FROM
    @GetAbsenteeDate
ORDER BY
    FullName

Posted 5-Mar-14 0:37am

Amalraj Ramesh

Comments

Member 10501509 5-Mar-14 6:45am

no
311 Aditya Mahapatro 05 Mar 2014 is Absentee for this date
560 Aishwarya Shekar 05 Mar 2014,06 Mar 2014 is Absentee for this for two date
i want to combine Absentee dates with comma if user have more than one Absentee date.

Amalraj Ramesh 5-Mar-14 6:50am

Verify this link

https://stackoverflow.com/questions/15742716/how-to-get-column-values-in-one-comma-separated-value

Member 10501509 5-Mar-14 7:07am

Not help full plz can give me code

Member 10501509 5-Mar-14 7:25am

help any one how do