Forum Replies Created

Viewing 15 posts - 7,486 through 7,500 (of 8,731 total)

  • RE: Pattern match any 3 repeating letters

    Something like this?

    name LIKE '[a-z][a-z][a-z]%'

    Nevermind, I missed 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

    November 7, 2013 at 11:45 am

    #1664882

  • RE: Best way to determine tables which contain a list of specific columns

    Now I'm lost, I thought you just wanted to improve the query that ccame after "--Derive list of tables which contain all three column". Now I'm not sure what you're...

    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

    November 7, 2013 at 11:13 am

    #1664875

  • RE: Best way to determine tables which contain a list of specific columns

    What about using INFORMATION_SCHEMA.COLUMNS view? it will give you the names of columns and tables.

    Another option would be to use OBJECT_NAME() instead of querying sys.tables. 😉

    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

    November 7, 2013 at 11:02 am

    #1664870

  • RE: Cursor to Delete data

    steven.ensslen (11/6/2013)

    If I had to guess, the problem is that a single DELETE is too large to fit in the transaction log. DELETE is the wrong tool for the...

    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

    November 6, 2013 at 12:51 pm

    #1664549

  • RE: Function to format a datetime variable by a mask

    Maybe something like this could perform better, based on the following article:

    http://www.sqlservercentral.com/articles/T-SQL/91724/

    CREATE FUNCTION [dbo].[DateFormattedByMask]

    (

    @InputDate DATETIME,

    @Mask NVARCHAR(80)

    )

    RETURNS 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

    November 6, 2013 at 12:06 pm

    #1664537

  • RE: ?? CASE in a where statement

    Check this article, as it might help you to improve performance.

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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

    November 6, 2013 at 10:39 am

    #1664526

  • RE: DTS Package SAVE AS - Possible security vulnerability?

    It doesn't matter where the DTS is saved, because the connections aren't changed to the prod server.

    What are you afraid of?

    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

    November 6, 2013 at 8:52 am

    #1664492

  • RE: convert date time

    CONVERT won't help with the string as is. You need to format it a little bit.

    WITH SampleData( cid,eid,checktime,status,bid) AS(

    SELECT 1,'25850','201310311133','01','2' UNION ALL SELECT

    1,'17018','201310311135','01','2' UNION ALL SELECT

    1,'25850','201310311137','01','2')

    SELECT cid,

    eid,

    CONVERT( datetime, STUFF( STUFF(checktime,...

    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

    November 6, 2013 at 8:20 am

    #1664483

  • RE: Cursor to Delete data

    Tej_7342 (11/5/2013)

    There are 2.2 billion records in the table and we want to only keep 2 weeks data, as of now we are lagging behind so we want to delete...

    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

    November 5, 2013 at 1:37 pm

    #1664241

  • RE: Cursor to Delete data

    Please don't send private messages, you limit the help you can get.

    Tej_7342 (11/5/2013)

    It looks good, but can this be modified to be generic instead of hard-coded. Also the problem is...

    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

    November 5, 2013 at 1:06 pm

    #1664232

  • RE: Import Excel to Sql table

    What's the output you're getting? There are millions of reasons, but the error messages can help us to identify what's happening.

    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

    November 5, 2013 at 12:53 pm

    #1664226

  • RE: Cursor to Delete data

    Something like this might work, but you should test the correct numbers depending on your server.

    DECLARE @i int = 1

    WHILE @i > 0 ...

    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

    November 5, 2013 at 12:46 pm

    #1664224

  • RE: calculating a date in the future

    Be careful on using recursive CTEs to count as you did. Those won't perform fine and might be worse than a cursor as stated on this article: http://www.sqlservercentral.com/articles/T-SQL/74118/

    Another point is...

    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

    November 5, 2013 at 9:50 am

    #1664185

  • RE: Count

    Yes, there's a difference and you're duplicating rows on the second statement due to the join.

    I suggest you to change your joins to ANSI-92 standard (using JOIN keywords).

    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

    November 4, 2013 at 11:27 am

    #1663914

  • RE: how to create a loop???

    Why do you want a loop if you can do a very easy update without even needing a CASE?

    UPDATE tmp_MT_SE_Upload

    SET page21.serial = T.SERIAL + (Row_ID - 1)

    FROM (SELECT TOP 1...

    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

    November 4, 2013 at 8:40 am

    #1663852

Viewing 15 posts - 7,486 through 7,500 (of 8,731 total)