Viewing 15 posts - 166 through 180 (of 252 total)
RBAR shouldn't be necessary here; give this article a read:
Once you create the DelimitedSplit8K function, you can toss it at your table, like so:
SELECT * FROM YourTable
CROSS APPLY YourDB.YourSchema.DelimitedSplit8K(YourDB.YourColumn,'!!!')
WHERE Item...
September 24, 2013 at 10:19 am
It's a bit hard to tell from your description, but I'm assuming that [xxxxxx] is a table. Is this correct? If so, you'll either need to specify the...
September 23, 2013 at 1:42 pm
I could be wrong on this, but from what I can tell, the WHERE clause will induce a table scan; this part in particular:
OR org_code IN (SELECT * FROM getValuesAsTable(@L_ORG,...
September 23, 2013 at 12:36 pm
This should work fairly well:
SELECT name, MAX(last_executed_step_date) AS LastRunDate,MAX(next_scheduled_run_date) AS NextRunDate,
CASE WHEN DATEDIFF(HOUR,MAX(last_executed_step_date),MAX(next_scheduled_run_date)) <= 24 THEN 'Daily'
WHEN DATEDIFF(DAY,MAX(last_executed_step_date),MAX(next_scheduled_run_date)) = 7 THEN 'Weekly'
WHEN DATEDIFF(MONTH,MAX(last_executed_step_date),MAX(next_scheduled_run_date)) = 1
AND DATEPART(DAY,MAX(last_executed_step_date)) = DATEPART(DAY,MAX(next_scheduled_run_date)) THEN...
September 23, 2013 at 7:54 am
Lynn Pettis (9/21/2013)
hisakimatama (9/21/2013)
Lynn Pettis (9/21/2013)
September 23, 2013 at 7:32 am
Lynn Pettis (9/21/2013)
September 21, 2013 at 11:12 am
Thanks for the welcome, everyone! It's great to be able to finally chat in The Thread with some context, not that it was needed. I just tend to...
September 21, 2013 at 6:03 am
Hm, I came up with this in the end. Doubtlessly, there's a cleaner solution, but it seems to work:
WITH CTE(LastName,Code) AS(
SELECT LastName, CASE WHEN MedBen = 'M' AND DenBen...
September 20, 2013 at 2:34 pm
I think I might have a rough idea of how to do this, but I too am a bit lost on the details. From the solution I cobbled up:
SpBen...
September 20, 2013 at 12:03 pm
I may be misguided on this, but I believe a server-side trace would help here; try this link:
I would recommend reading the article, and perhaps a few others on...
September 20, 2013 at 11:25 am
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been lurking around here, being...
September 20, 2013 at 10:18 am
chrisn-585491 (9/11/2013)
Degrees are not a sign of competence. There are many folks with CS degrees that can't problem solve and many MBAs that can't manage. The best programmer I...
September 11, 2013 at 7:25 am
I'm not usually too fond of engaging in political discource, but here goes...
Replacing legislators is indeed part of our system, yes; but who they're replaced by isn't a matter of...
September 9, 2013 at 8:10 am
Gah. I heard about this whole mess yesterday in the water cooler thread. It's a shame. From what I've seen of Gail and a few other MCM...
September 4, 2013 at 7:16 am
Viewing 15 posts - 166 through 180 (of 252 total)