Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: the use of CTEs

    "If you do it more than once in a year - you need to rethink you approach to T-SQL programming, and probably take some lessons on how to do it...

  • RE: the use of CTEs

    2

  • RE: the use of CTEs

    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 not think there is...

  • RE: Where to start...

    Never be afraid to ask for help. Read about all the topics you can. I find that eventually things will start to click. Immerse yourself.

    You had one...

  • RE: Powershell Tool Time: The Tool Framework

    Agreed. I have watched some of the Microsoft virtual academy labs and they state that the are moving everyone to the ise.

  • RE: Powershell Tool Time: The Tool Framework

    This is great! I would love to start using powershell more!

    Question - Do you need to load the function every powershell session? Or, can they be stored somewhere...

  • RE: Conditional query

    Yes. Please provide more detail.

    TABLE A

    COLUMN 1 , COLUMN 2, COLUMN 3

    TABLE B

    etc.....

  • RE: Copy-Paste table from Excel to sql server

    How many records? I find that right clicking on an empty table and selecting edit top 200 rows. From there, you can past the contents of the excel...

  • RE: conver from access to sql server

    Hello,

    Are the tables in access imported into a sql server instance? Access sql likes to put a lot of unnecessary '(' in code.

  • RE: Every 3rd Friday of the Month

    I know that this is not the perfect answer. This requires use of the kimbal date dimension. If you have that, it's super simple. Use analytic functions. 🙂

    SELECT...

Viewing 10 posts - 1 through 10 (of 10 total)