Forum Replies Created

Viewing 15 posts - 46 through 60 (of 262 total)

  • RE: Email report as PDF with different name through subscription

    Thanks mate

    I am doing it in an SSIS package, a script task will do the necessary

    thanks for taking the time

    February 10, 2016 at 4:49 am

    #1857638

  • RE: the use of CTEs

    Lynn Pettis (1/11/2016)

    Sergiy (1/11/2016)

    Kedazs (1/11/2016)

    Yes. I also use CTE's to "clean up my code". Especially if it is something being called multiple times within the select. I do...

    January 12, 2016 at 12:11 am

    #1851242

  • RE: the use of CTEs

    ChrisM@Work (1/8/2016)

    erics44 (1/8/2016)

    ChrisM@Work (1/8/2016)

    erics44 (1/8/2016)

    Hugo Kornelis (1/8/2016)

    erics44 (1/8/2016)

    Hugo Kornelis (1/8/2016)

    Jeff Moden (1/7/2016)

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can be...

    January 8, 2016 at 4:38 am

    #1850454

  • RE: the use of CTEs

    ChrisM@Work (1/8/2016)

    erics44 (1/8/2016)

    Hugo Kornelis (1/8/2016)

    erics44 (1/8/2016)

    Hugo Kornelis (1/8/2016)

    Jeff Moden (1/7/2016)

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can be an rCTE...

    January 8, 2016 at 3:36 am

    #1850441

  • RE: the use of CTEs

    Hugo Kornelis (1/8/2016)

    erics44 (1/8/2016)

    Hugo Kornelis (1/8/2016)

    Jeff Moden (1/7/2016)

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can be an rCTE but the...

    January 8, 2016 at 3:15 am

    #1850435

  • RE: the use of CTEs

    Hugo Kornelis (1/8/2016)

    Jeff Moden (1/7/2016)

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can be an rCTE but the rather well advertised...

    January 8, 2016 at 2:15 am

    #1850422

  • RE: the use of CTEs

    Lynn Pettis (1/7/2016)

    You have to remember that many times threads go off on tangents, and sometimes the tangents actually impart knowledge that may not have been provided otherwise.

    I don't believe...

    January 7, 2016 at 8:24 am

    #1850204

  • RE: the use of CTEs

    Sergiy (1/7/2016)

    erics44 (1/7/2016)

    You spoilt a good thread boys!

    Define "spoilt".

    It's all the matter of preferences, you know.

    ha, very true

    thing is, unlike whether a CTE can spoil a nice bit of code,...

    January 7, 2016 at 2:16 am

    #1850123

  • RE: the use of CTEs

    You spoilt a good thread boys!

    January 7, 2016 at 12:35 am

    #1850114

  • RE: the use of CTEs

    Luis Cazares (1/6/2016)

    Been following this discussion, but I didn't feel like getting in it.

    I believe that over use of CTEs is as bad as the lack of CTEs. I'd rather...

    January 6, 2016 at 3:03 pm

    #1850051

  • RE: the use of CTEs

    Lynn Pettis (1/6/2016)

    erics44 (1/6/2016)

    Sergiy (1/6/2016)

    jaime.simancas 27970 (1/6/2016)

    but CTEs have their place in making these "Sets" easier to read..

    Very questionable. Very.

    CTE's break the structure of Structured Query Language, moving part of...

    January 6, 2016 at 2:56 pm

    #1850049

  • RE: the use of CTEs

    Alan.B (1/6/2016)

    erics44 (1/6/2016)

    Alan.B (1/6/2016)

    This is just silly. Every MVP and Certified Master whose article and/or book I have read uses CTEs. And I use them and I know how to...

    January 6, 2016 at 2:54 pm

    #1850048

  • RE: the use of CTEs

    Sergiy (1/6/2016)

    jaime.simancas 27970 (1/6/2016)

    but CTEs have their place in making these "Sets" easier to read..

    Very questionable. Very.

    CTE's break the structure of Structured Query Language, moving part of FROM effectively out...

    January 6, 2016 at 2:17 pm

    #1850033

  • RE: the use of CTEs

    Alan.B (1/6/2016)

    This is just silly. Every MVP and Certified Master whose article and/or book I have read uses CTEs. And I use them and I know how to design DBs...

    January 6, 2016 at 1:40 pm

    #1850023

  • RE: the use of CTEs

    jaime.simancas 27970 (1/6/2016)

    erics44 (1/6/2016)

    jaime.simancas 27970 (1/6/2016)

    Skill is not defined by how you write a query, but by how you solve the right problem.

    hmmmmmm, seems like a very profound thing...

    January 6, 2016 at 9:14 am

    #1849905

Viewing 15 posts - 46 through 60 (of 262 total)