Forum Replies Created

Viewing 15 posts - 7,276 through 7,290 (of 8,731 total)

  • RE: Query for specific format

    caippers (1/2/2014)

    I do the only question I have is I don't see a consideration for the left and right parentheses. Wouldn't this miss that if a number was missing...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 2, 2014 at 8:31 am

    #1676934

  • RE: hi need advice on career

    The question would be, what do you want?

    SSIS and SSAS are great tools for BI development. If you already know SSRS, you can go all the way.

    You must evaluate both...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 2, 2014 at 8:24 am

    #1676925

  • RE: Double quotes on Bulk Insert

    Thank you for all of your recommendations. I will try all of them (I might not be able to use the error file because of permissions to write on disk).

    I...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 1, 2014 at 9:15 am

    #1676732

  • RE: Flat File validation of 20+ fields

    Yes and no.

    All import utilities from SQL Server (bcp, bulk insert, openrowset, SSIS) have options to handle errors. The first 3 have the errorfile and max errors options. SSIS has...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 1, 2014 at 9:05 am

    #1676729

  • RE: Flat File validation of 20+ fields

    You could use an errorfile during the import operation to validate your values. Be sure to have an acceptable value for MAXERRORS to avoid the import to fail.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 1, 2014 at 8:46 am

    #1676727

  • RE: ssis import export wizard

    Is there a formula to obtain the name for each week? or will someone define it manually?

    If you go to the connection properties, look for Expressions and use the expression...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 1, 2014 at 8:37 am

    #1676726

  • RE: will i be able to extract the year stamp from these strings?

    This seems to work fine, unless you have other 4 digits number in your string.

    If you have any questions on how it works or why did I used something,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 1, 2014 at 8:31 am

    #1676725

  • RE: Exec Trigger On Import

    Remember to use the option to enable triggers (FIRE_TRIGGERS) or the result will be the same.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 31, 2013 at 12:04 pm

    #1676658

  • RE: Stored procedure error resolution help

    Maybe this will avoid errors.

    CAST( CASE WHEN CHARINDEX('T', c3.value('@runDate[1]','varchar(30)')) = 0

    THEN STUFF( REPLACE(c3.value('@runDate[1]','varchar(30)'), ' ', ''), 11, 0, 'T')

    ELSE REPLACE(c3.value('@runDate[1]','varchar(30)'), ' ', '') END AS datetime2)

    But the best...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 31, 2013 at 12:01 pm

    #1676657

  • RE: Stored procedure error resolution help

    It's hard to give an answer as I don't know your table or xml structure. Could you give a sample of values for the following query?

    SELECT c3.value('@runDate[1]','varchar(100)') as runDate

    FROM xmlResults...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 31, 2013 at 10:08 am

    #1676629

  • RE: Exec Trigger On Import

    I believe that Lynn was referring to what command did you use (eg. INSERT INTO, BULK INSERT, bcp, etc).

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 31, 2013 at 9:46 am

    #1676623

  • RE: Stored procedure error resolution help

    Just a guess, but your runDate in the XML might not have the correct format or might be an invalid date.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 31, 2013 at 8:44 am

    #1676604

  • RE: Difference Between Maximum and Minumum Values

    Hi,

    To get better and faster answers, you should post DDL and sample data in a consumable format as I did this time for you. (It seems that you edited your...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 31, 2013 at 8:20 am

    #1676594

  • RE: Stored procedure taking too long to run

    petr.caslavka (12/30/2013)

    This is definitely a better way of doing it. However, I am not sure about the TRUNCATE TABLE ps_micros_e7_time_clock_details statement. I don't want/need to truncate the table altogether as...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 30, 2013 at 3:21 pm

    #1676490

  • RE: Stored procedure taking too long to run

    If there's no primary key, then performance won't be great. Even if there's no PK defined as a constraint, you could identify a PK that will help you identify duplicates.

    Here's...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 30, 2013 at 2:59 pm

    #1676485

Viewing 15 posts - 7,276 through 7,290 (of 8,731 total)