Viewing 15 posts - 8,116 through 8,130 (of 18,926 total)
Paul White NZ (4/9/2010)
Ninja's_RGR'us (4/9/2010)
Any luck on the clr routine?
Been busy on another thread - writing a SQLCLR routine to return the phase of the moon for a given date...
April 10, 2010 at 6:19 am
Ultimately, query optimisation is an art more than anything else...
April 9, 2010 at 4:08 pm
We can't answer that without seeing the query, table defs and .sqlplan.
Please send those over and we'll be able to point you in the right direction.
One point to have in...
April 9, 2010 at 1:52 pm
OVER (PARTITION BY UserLogon ORDER BY createdon DESC)
April 9, 2010 at 12:27 pm
Paul White NZ (4/8/2010)
April 9, 2010 at 10:13 am
Garadin (4/9/2010)
Chris Morris-439714 (4/9/2010)
Oh cr@p - Seth, let me know if you're still considering setting up a challenge and I'll edit this out.
I am, but I know Jacob already has...
April 9, 2010 at 10:10 am
Chris Morris-439714 (4/9/2010)
Ninja's_RGR'us (4/9/2010)
Chris Morris-439714 (4/9/2010)
It would be better to change the string list from comma-delimited to fixed position, three character positions per item - that way, the upper...
April 9, 2010 at 10:06 am
Chris Morris-439714 (4/9/2010)
It would be better to change the string list from comma-delimited to fixed position, three character positions per item - that way, the upper limit would be...
April 9, 2010 at 7:42 am
rpatil22 (4/9/2010)
Table contain following Columns
employeeId - uniqueindentifier ( primary key )
machine - nvarchar(100)
firstname - nvarchar(100)
lastname - nvarchar(100)
startdate - datetime
finishdate - datetime
location...
April 9, 2010 at 7:18 am
Chris Morris-439714 (4/9/2010)
Garadin (4/8/2010)
Chris Morris-439714 (4/8/2010)
Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe...
April 9, 2010 at 7:13 am
Garadin (4/8/2010)
Ninja's_RGR'us (4/8/2010)
Garadin (4/8/2010)
Chris Morris-439714 (4/8/2010)
Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe...
April 8, 2010 at 12:44 pm
Garadin (4/8/2010)
Chris Morris-439714 (4/8/2010)
Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...
April 8, 2010 at 12:42 pm
Garadin (4/8/2010)
Chris Morris-439714 (4/8/2010)
Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...
April 8, 2010 at 12:16 pm
Ninja's_RGR'us (4/8/2010)
Chris Morris-439714 (4/8/2010)
Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...
April 8, 2010 at 12:15 pm
Chris Morris-439714 (4/8/2010)
Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link table?
It's...
April 8, 2010 at 10:33 am
Viewing 15 posts - 8,116 through 8,130 (of 18,926 total)