Forum Replies Created

Viewing 15 posts - 5,356 through 5,370 (of 8,731 total)

  • RE: Easy script help (I think!?)

    jrodriguez 62807 (1/7/2015)

    I am somewhat new and for that please forgive me but I need to create this script and it is driving me crazy that I can't figure it...

    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 7, 2015 at 1:29 pm

    #1768592

  • RE: Struggling with query to retrieve five most recent

    This should do the trick.

    WITH cteMP AS(

    SELECT MachineFk,

    IsValid,

    PartType,

    ...

    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 7, 2015 at 12:18 pm

    #1768572

  • RE: Addition of NOLOCK to subquery causes slower query execution

    SomewhereSomehow (1/7/2015)

    Investigated some detailes here:

    http://www.queryprocessor.com/nolock-and-top-optimization/

    Note that this is a 3 years old thread.

    The information might be useful if someone arrives here with the same problem.

    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 7, 2015 at 10:56 am

    #1768541

  • RE: Locking issues

    UPDATES will always generate locks (and any other DDL and DML statement). You might have been concerned about blocking instead of locking.

    I'm not an expert on this subject, but 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 7, 2015 at 8:37 am

    #1768478

  • RE: Are the posted questions getting worse?

    dwain.c (1/6/2015)

    Lynn Pettis (1/6/2015)

    ... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go, ...

    I'm going to miss...

    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 6, 2015 at 7:21 pm

    #1768314

  • RE: Problem Escaping Quote Characters

    Polymorphist (1/6/2015)

    Oh my god, could SSIS be any more of a PITA? Amazing anyone even uses this POS tool.

    I need quotes in my expression. Everything i'm reading out...

    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 6, 2015 at 7:19 pm

    #1768313

  • RE: Convert to Datetime in Datediff

    You need to create validations for your data.

    CREATE TABLE cDatesTest(

    Record_Created varchar(30));

    INSERT cDatesTest VALUES

    ('21 Dec 2014 00:16:15'),

    ('25 Oct 2014 00:16:18'),

    ('30 Dec 2014 00:16:53'),

    ('90000'),

    ('23 Oct 2013 00:16:27')

    SELECT Datediff(dd,Clean.Record_Created,getdate())...

    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 6, 2015 at 12:09 pm

    #1768196

  • RE: Hiding the Row?

    If you want to prevent that people read certain rows from a table, you can remove access from that table, create a view with the correct filters and give permissions...

    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 6, 2015 at 11:55 am

    #1768193

  • RE: Convert to Datetime in Datediff

    sharonsql2013 (1/6/2015)

    Its bad data... No I don't have access to changing datatypes

    And the answers for the first 2 questions?

    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 6, 2015 at 11:34 am

    #1768185

  • RE: Convert to Datetime in Datediff

    What's the problem? Could you post sample data? Could you change the column to be a date/time data type?

    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 6, 2015 at 11:24 am

    #1768179

  • RE: Date format conversion

    Phil Parkin (1/3/2015)

    Eirikur Eiriksson (1/3/2015)

    Luis Cazares (1/3/2015)

    DECLARE @date date = '20140927'

    Be careful with the implicit conversion as the results will be depending on the system settings, no guarantee that it...

    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 5, 2015 at 4:23 pm

    #1767904

  • RE: Which memory is SSIS using

    Yes and no.

    Memory for transformations comes from the SSIS server, but you'll use some resources from the other servers to read and write. If you have complex queries, that would...

    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 5, 2015 at 3:12 pm

    #1767892

  • RE: Need help in refreshing some tables in a database from one server to another server

    v4vaas 19815 (1/5/2015)

    Hi, I need some help in refreshing process some of the tables in a database from a sql server (running 2008) to another database in a destination sql...

    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 5, 2015 at 2:47 pm

    #1767887

  • RE: Date format conversion

    I'm not sure which data type you're using. Here's an example with 3 possible types.

    Please, store your dates as dates and avoid using strings or numbers to store dates.

    DECLARE @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

    January 3, 2015 at 1:12 am

    #1767522

  • RE: nested stored procedure

    No, you can't use two result sets from a single procedure to insert data into a table.

    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, 2015 at 11:28 pm

    #1767519

Viewing 15 posts - 5,356 through 5,370 (of 8,731 total)