Forum Replies Created

Viewing 15 posts - 3,331 through 3,345 (of 6,486 total)

  • RE: Jobs and executing stored procedures in T-SQL

    etxeb (5/14/2008)

    Matt Miller (5/14/2008)

    If the CSV show up once per day/gets modified just once in a while, running something continuously in the hopes of catching the mod time is, well...

    May 14, 2008 at 10:00 am

    #815350

  • RE: Trigger Help

    Jack Corbett (5/14/2008)

    Matt Miller (5/14/2008)

    Jack Corbett (5/14/2008)

    SQL Server does not have before triggers. In SQL Server you would use an after trigger and then use the virtual inserted and deleted...

    May 14, 2008 at 9:49 am

    #815335

  • RE: dynamic variable?

    is250sp (5/14/2008)

    Jason Selburg (5/14/2008)

    Place a semi-colon at the end of the line immediately before the WITH statement.

    Jason, can you please be more clear on where I should put the semi-colon?

    While...

    May 14, 2008 at 9:40 am

    #815325

  • RE: Trigger Help

    Jack Corbett (5/14/2008)

    SQL Server does not have before triggers. In SQL Server you would use an after trigger and then use the virtual inserted and deleted tables. I will post...

    May 14, 2008 at 9:31 am

    #815310

  • RE: Jobs and executing stored procedures in T-SQL

    etxeb (5/14/2008)

    mtassin (5/14/2008)

    Not 100% sure I follow,

    1. You have an application that drops csv files to a specific folder on an ad-hoc type of basis

    2. You need to read...

    May 14, 2008 at 9:24 am

    #815299

  • RE: The CLR

    Solomon Rutzky (5/13/2008)

    developmentalmadness (5/13/2008)

    - the Table-valued functions need to materialize their entire recordset before being able to return anything, so they can quickly "swamp" the memory area.

    This is...

    May 14, 2008 at 8:13 am

    #815233

  • RE: The CLR

    Renato Buda (5/14/2008)

    Regexp Expressions

    Compression of Blobs

    Concatenate() aggregate function

    All the above have proved useful.

    **** The 8K limit is an urban myth!!! ****

    see the following for a sample:

    http://www.codeproject.com/KB/database/blob_compress.aspx

    Yup - I've...

    May 14, 2008 at 8:12 am

    #815230

  • RE: Report Parameters? or some other way for users to select criteria :unsure:

    yup - just like Jeff mentioned. Just make the values 'Dev','Prod', and 'test' (skipping the quotes when you type it in.)

    May 14, 2008 at 7:25 am

    #815156

  • RE: Report Parameters? or some other way for users to select criteria :unsure:

    1. get the report to something SQL static.

    2. once you're through the initial wizard, click on report, parameters, add a new parameter, and populate the drop down area (label and...

    May 13, 2008 at 10:01 pm

    #814931

  • RE: Uncomfortable situation at office

    jsheldon (5/13/2008)

    Ok this is ugly...we are a small company, we have gone through a lot of turnover (not in IT but in the company in general) one of our IT...

    May 13, 2008 at 9:41 pm

    #814928

  • RE: adding columns using derived column transformation

    thenepatsrule (5/13/2008)

    CAST STATEMENT? which transformation do i have to use for this

    thanks

    You'll need two different pieces. One is you need to use a derived column task so set up...

    May 13, 2008 at 9:25 pm

    #814925

  • RE: Report Parameters? or some other way for users to select criteria :unsure:

    SQL-Retard (5/13/2008)

    I have been tasked by our VP to create reports for the Server Information DB that I created... I am learning basic SQL as I go along, and now...

    May 13, 2008 at 9:15 pm

    #814922

  • RE: String comparison with trailing spaces

    Jack Corbett (5/13/2008)

    Matt Miller (5/13/2008)

    I know:) Concatenation is different.:D

    It just seems inconsistent behavior. As in -

    Primary Key - trim it

    comparison - trim it

    concatenation - don't trim it

    storage...

    May 13, 2008 at 7:26 pm

    #814912

  • RE: String comparison with trailing spaces

    I know:) Concatenation is different.:D

    It just seems inconsistent behavior. As in -

    Primary Key - trim it

    comparison - trim it

    concatenation - don't trim it

    storage - don't trim it

    group...

    May 13, 2008 at 2:26 pm

    #814792

  • RE: String comparison with trailing spaces

    GSquared (5/13/2008)

    I just checked my databases and servers, and ANSI padding is False on all of them, but per BOL:

    Important:

    In a future version of SQL Server ANSI_PADDING will...

    May 13, 2008 at 2:12 pm

    #814781

Viewing 15 posts - 3,331 through 3,345 (of 6,486 total)