Forum Replies Created

Viewing 15 posts - 166 through 180 (of 252 total)

  • RE: Convert a single column into multiple rows

    RBAR shouldn't be necessary here; give this article a read:

    DelimitedSplit8K[/url]

    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...

  • RE: Invalid object name ??!

    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...

  • RE: CLUSTERED INDEX SCAN (EmpNonPrjTime)

    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,...

  • RE: job history check

    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...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/21/2013)


    hisakimatama (9/21/2013)


    Lynn Pettis (9/21/2013)


    Well, by reading The Thread from start to now you also got to learn some interesting things about many of the regulars here on SSC....

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/21/2013)


    Well, by reading The Thread from start to now you also got to learn some interesting things about many of the regulars here on SSC. Hopefully you...

  • RE: Are the posted questions getting worse?

    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...

  • RE: Comparing records against multiple rows

    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...

  • RE: count

    When using aggregates (COUNT,SUM,AVG, etc.), you need to use a GROUP BY statement. In this case, it seems you need Prodmonth, and a count of the number of times...

  • RE: Comparing records against multiple rows

    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...

  • RE: Connection issue

    I may be misguided on this, but I believe a server-side trace would help here; try this link:

    Server-Side Tracing

    I would recommend reading the article, and perhaps a few others on...

  • RE: Are the posted questions getting worse?

    *Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been lurking around here, being...

  • RE: The Future of Knowledge Measurement

    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...

  • RE: The Loss of Trust

    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...

  • RE: It's not you; it's us

    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...

Viewing 15 posts - 166 through 180 (of 252 total)