Forum Replies Created

Viewing 15 posts - 4,921 through 4,935 (of 8,731 total)

  • RE: Here are some SQL Server Interview Questions

    SQLRNNR (5/19/2015)

    Along the lines of interview questions, let's just throw this question out there.

    If you are hiring for a senior position, you create an exam for the position, you require...

    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

    May 19, 2015 at 9:48 am

    #1799074

  • RE: implicit conversion failure varchar to numeric using DelimitedSplit8K function

    rossa (5/18/2015)

    I should have mentioned that it's a SQL 2000 database attached to a SQL 2005 instance. That is, it's running in SQL 2000 compatibility mode.

    FYI, an SQL Server...

    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

    May 18, 2015 at 4:51 pm

    #1798869

  • RE: Skipping group with FOR XML Path('')

    Both solutions run fine. If you're getting an error, it would be because you changed something and we don't know what it is.

    You need to review your code for any...

    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

    May 18, 2015 at 11:51 am

    #1798747

  • RE: Want to create all procedures located in a folder one by one and creating/saving output file in a folder.

    Have you tried a ForEach Loop in SSIS? Would you be interested?

    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

    May 18, 2015 at 11:36 am

    #1798737

  • RE: Skipping group with FOR XML Path('')

    Something like this?

    SELECT *

    INTO #Test

    FROM (Values

    (1, 'A'),

    (1, 'B'),

    (1, 'C'),

    (1, 'D'),

    (1, 'E'),

    (2, 'A'),

    (2, 'C'),

    (2, 'D'),

    (2, 'E'),

    (3, 'A'),

    (3, 'B'),

    (3, 'C'),

    (3, 'F'),

    (4, 'A'),

    (4, 'B'),

    (4, 'D'),

    (4, 'F'),

    (4, 'G'))x(id, value);

    SELECT id,

    ...

    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

    May 18, 2015 at 11:33 am

    #1798736

  • RE: Need Ammunition for Developers Doing Select *'s

    Vyper426 (5/18/2015)

    Ed Wagner (5/15/2015)

    A SELECT * in a cursor...So that means if a column is added to a table the system uses, the interface breaks at every point where 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

    May 18, 2015 at 11:18 am

    #1798732

  • RE: Tuning SQL Server query

    This might at least help a bit, but it won't address the main problems of the query (user defined scalar function and function on columns in the where clause or...

    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

    May 18, 2015 at 10:48 am

    #1798719

  • RE: Alternate to CASE in SQL

    You can use a subquery or CTE.

    SELECT col1

    FROM (

    SELECT col1,

    case when upper(col3) like '%HTEST%'...

    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

    May 18, 2015 at 10:05 am

    #1798692

  • RE: implicit conversion failure varchar to numeric using DelimitedSplit8K function

    Sean Lange (5/18/2015)

    There is something missing here for sure. You stated that you use the DelimitedSplit8K function in your 2000 instance. In the original format it would NOT work in...

    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

    May 18, 2015 at 10:01 am

    #1798689

  • RE: Here are some SQL Server Interview Questions

    xsevensinzx (5/16/2015)

    What's wrong with this picture?

    It's incomplete.

    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

    May 16, 2015 at 10:58 am

    #1798429

  • RE: Rounding is Inconsistent

    Changes in the data between runs?

    If you run a query over a static set of data, it will always return the same result (except for nondeterministic functions).

    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

    May 15, 2015 at 12:59 pm

    #1798311

  • RE: Here are some SQL Server Interview Questions

    Eric M Russell (5/15/2015)

    Sean Lange (5/15/2015)

    Luis Cazares (5/15/2015)

    It's important for us that you'll be a good fit in our team, so the following question will define if you get 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

    May 15, 2015 at 11:29 am

    #1798287

  • RE: Here are some SQL Server Interview Questions

    Grant Fritchey (5/15/2015)

    Sean Lange (5/15/2015)

    Luis Cazares (5/15/2015)

    It's important for us that you'll be a good fit in our team, so the following question will define if you get the job...

    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

    May 15, 2015 at 11:27 am

    #1798286

  • RE: Date issue in dynamic SQL

    Or you could prevent all that casting by parametrizing your query.

    SELECT @sql = 'SELECT *

    FROM #Temp

    WHERE DocDate BETWEEN @EndDate AND GetDate()'

    EXEC sp_executesql @sql, N'@EndDate date', @EndDate

    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

    May 15, 2015 at 11:25 am

    #1798285

  • RE: Here are some SQL Server Interview Questions

    It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

    Leading commas or trailing commas?

    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

    May 15, 2015 at 9:36 am

    #1798246

Viewing 15 posts - 4,921 through 4,935 (of 8,731 total)