Viewing 15 posts - 32,656 through 32,670 (of 59,102 total)
clubbavich (9/3/2011)
@jeffHere is how the devices are distributed.
Server_Id, Device_Id
1 has 1540 Device_Id's
2 has 742 Device_Id's
3 has 357 Device_Id's
4 has 26 Device_Id's
5 has 917 Device_Id's
Thanks. I'll put something together tomorrow....
--Jeff Moden
Change is inevitable... Change for the better is not.
September 3, 2011 at 8:22 pm
komal145 (8/31/2011)
Thank you for all responses...I got it!!!
Cool! Please post the code you ended up using so that we all may learn. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 8:19 pm
Michael Valentine Jones (8/31/2011)
It would be simpler to use dynamic SQL and just construct the exact ORDER BY clause that you need.
+1
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 8:15 pm
tamil.selvanmca (9/2/2011)
2058 01/02/2011 13:43
2058 01/02/2011 20:12
2058 01/03/2011 14:04
2058 01/03/2011 20:13
2058 01/04/2011 14:09
2058 01/04/2011 20:12
I Want Show Like This
EmpCode ShiftDateTime TimeDetail
2058 01/02/2011 13:43 13:43,20:12
2058 01/03/2011 14:04 14:04,20:13
2058 01/04/2011 14:09 14:19,20:12
Please...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 8:11 pm
sqlzealot-81 does the trick although you could get rid of the outer select.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 7:55 pm
What is the average number of Device_ID's you have per server? I'm asking because I think I see some major issues with the indexes on this table but don't...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 7:16 pm
Sean Lange (9/2/2011)
Jeff Moden (9/2/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 6:38 pm
There's one major problem that I see in all of this... [font="Arial Black"]why are we converting things that aren't dates into NULLs when the original data is SUPPOSED TO ONLY...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 6:32 pm
nellisjp (9/2/2011)
Select Case When Len(InputDate) <> 8...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 6:29 pm
Noooooooooooooo!!!! 😉
You don't need to even have a UDF to do this. Just cast the 8 character input field as a DATETIME datatype and you're done!
As a side bar,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 2:33 pm
You bet... thank you for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 2:25 pm
Darryl Wilson (9/2/2011)
Its in the following format:
GREEN,0016861779528,"Dembo, Ron C","""Roulette"" or the...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 2:25 pm
falcon00 (9/2/2011)
The purpose is simply to use it for a request, where user would physically...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 2:16 pm
The XML method won't work on NTEXT, period. Also be advised than NTEXT has been deprecated in favor of NVARCHAR(MAX). Since you're posting in a 2k8 forum, I...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 1:54 pm
First, welcome aboard! 🙂
There are 3 basic types of hierarchies... how are your hierarchies being stored? Adjacency List, Hierarchical Path, Nested Sets?
Since you're brand-spanking new to this forum, please...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 2, 2011 at 8:01 am
Viewing 15 posts - 32,656 through 32,670 (of 59,102 total)