Forum Replies Created

Viewing 11 posts - 151 through 162 (of 162 total)

  • RE: DTUTIL Utility to Copy / Delete SSIS Deployed in MSDB to File System

    i think you would need to use sql loop through the msdb database to create a script which you can then save to a batch file and run that. ...

    Life: it twists and turns like a twisty turny thing

  • RE: Dynamically Generate Folders for File Output using Variables in SSIS

    Also, in the example in this article you can do away with the SQL statement and enter the expression directly into the variable.

    + Select the variable and go to it's...

    Life: it twists and turns like a twisty turny thing

  • RE: T-SQL query

    you could use a case statement:

    where

    case month(dob)

    when 1 then 1

    ...

    Life: it twists and turns like a twisty turny thing

  • RE: Adding Report parameter to Chart Title

    you can use the expression builder to do this.

    right click the text box that will hold your title, click expression builder on the context menu. you can then use...

    Life: it twists and turns like a twisty turny thing

  • RE: Embed Media Player in SSRS 2005

    That was my first plan, actually. I had a dynamic link that pointed to firstly the .wav file via a UNC path and secondly via http. Neither of...

    Life: it twists and turns like a twisty turny thing

  • RE: Join Predicate

    nice question. nice and sneaky.

    Life: it twists and turns like a twisty turny thing

  • RE: Question of the Day for 24 Apr 2007

    Assuming the author does mean a CASE expression, and then the answer is "yes", you would have to wonder why you would use it at all, as (in the example...

    Life: it twists and turns like a twisty turny thing

  • RE: Time Off

    During the summer months here in Cornwall, UK, I like to nip down to the beach and go for a swim during my lunch. It wakes me up, invigorates...

    Life: it twists and turns like a twisty turny thing

  • RE: First Poll for 2006

    How about...

    "The older I get, the better I was"

    Tommy H

    Life: it twists and turns like a twisty turny thing

  • RE: Running a SP from ASP.net

    another problem could occur if you use the PRINT command in your sp. this sp will run fine in QA but will cause a web page to fail.

    Life: it twists and turns like a twisty turny thing

  • RE: Common Table Expressions in SQL Server 2005

    great article! CTEs were well explained and the examples demonstrated the application of CTEs effectively and succinctly. cheers.

    Life: it twists and turns like a twisty turny thing

Viewing 11 posts - 151 through 162 (of 162 total)