December 5, 2003 at 6:49 am
Hi All,
I want to know whether a carriage return can be added for a column data, to show up 2 values one after the other (for example word wrap which automatically adjusts the text to the next line), when selected.
For example, by mistake a user submits 2 times (may be slightly different in their millisecond values) like 08:24 and 08:25.
Here the data will be looking as
User Time Status
---- ----- ------
xyz 08:24 Office Time In
xyz 08:25 Office Time In
abc 08:26 Office Time In
bbc 08:27 Office Time In
My ultimate requirement is to show up these values in a single row when selected should be like
User Time Status
---- ---- ------
xyz 08:24 Office Time In
08:25
abc 08:26 Office Time In
bbc 08:27 Office Time In
Overall, i should get only 3 rows as against 4 rows of data.
Any help would be highly appreciated as i have to implement the same for different status types.
Ravi
Lucky
December 5, 2003 at 7:56 am
If you just need info on CR or CRLF,
then maybe something like:
SET @NewString = @Str1 + Char(13) + Char(10) + @Str2
Once you understand the BITs, all the pieces come together
December 5, 2003 at 8:16 am
If I understand your need, this is difficult in T-SQL but easy in any programmable front-end. If you can't manage this on the front-end, then perhaps just using some aggregate functions would suffice; i.e. instead of listing the times, just return the first time and the number of total like submissions:
SELECT [User], MIN([Time]) FirstPunch, COUNT(*) Punches, Status
FROM TodaysPunches
GROUP BY [User], Status
ORDER BY FirstPunch, [User]
--Jonathan
--Jonathan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy