Forum Replies Created

Viewing 15 posts - 2,566 through 2,580 (of 13,459 total)

  • RE: Using Profiler to obtain SQL executed by an encrypted Stored procedure

    why don't you just decrypt the stored procedure instead?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 5, 2014 at 5:46 am

    #1686160

  • RE: Remote Stored Procedure call

    want to use a remote server, but don't want a linked server? I'm with Sean, your dismissing the #1 tool without an apparent reason.

    openrowset is disabled by default, whereas linked...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 5, 2014 at 5:43 am

    #1686156

  • RE: Trade Mark Symbol Loading Issues through SSIS2008

    oops

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 4, 2014 at 11:56 am

    #1685972

  • RE: Testing multiple columns in a table

    performance wise, this would be a little better, since the OR statement forces a table scan, and this would/could take advantage of existing indexes instead.

    but it's effectively the same approach.

    SELECT

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 4, 2014 at 10:42 am

    #1685943

  • RE: Testing multiple columns in a table

    first stab at the issue:

    SELECT OrdersTest.*,

    CASE

    WHEN RTRIM(ISNULL(OrderNo,'')) = ''

    THEN 'Blank Order Number'

    ELSE

    ''

    END AS OrderNumberIncorrect,

    CASE

    WHEN ISNULL(PalletCount,0) =...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 4, 2014 at 10:34 am

    #1685937

  • RE: Primary key to be the last row in the table.

    SQL is really good about not caring about the order of things, the order of columns, the order of data are not relevant to SQL, so having the PK as...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 4, 2014 at 10:11 am

    #1685928

  • RE: tsql NOT using INDEX when parameter value in use

    for that specific query, that index is not a good match for a parameterized query

    a new index, something like this would probably work immediately for your existing query and...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 4, 2014 at 8:06 am

    #1685887

  • RE: sql case when statement

    there's a lot of logic holes in here; are we trying to find the fiscal start date or something? is the 05 date a copy paste err, and it should...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 4, 2014 at 7:40 am

    #1685862

  • RE: tsql NOT using INDEX when parameter value in use

    what is the definition of the index?

    your query has three columns in the WHERE statement, is the index on all three columns?

    since you are doing SELECT *, at a minimum,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 4, 2014 at 7:02 am

    #1685839

  • RE: Trigger to capture changes into an audit table

    i cannot find it now, but Sean Lange posted an answer to a question that was near identical to this idea, and noted all the grievous, serious problems that were...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2014 at 2:19 pm

    #1685648

  • RE: Troubleshoot sp that hangs

    well the things i see so far are:

    you are joining other tables to a view vw_Return_Entity_Ops

    it is very common that a view will grab substatially more columns thyan you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2014 at 2:05 pm

    #1685641

  • RE: Is their a variation on RBarry Young's function that allows you to get the cities and states X miles from a long and lat value ?

    i have this saved in my snippets; it's calculating the min and max longitudes/latittudes for a specific point, which you then use to bracket in the values search a...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2014 at 1:48 pm

    #1685631

  • RE: Is their a variation on RBarry Young's function that allows you to get the cities and states X miles from a long and lat value ?

    certainly possible, i think it goes directly to your data;

    do you have polygon boundaries for your cities, or a simple single point per city?

    either way, you can build...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2014 at 1:11 pm

    #1685621

  • RE: Database Mail limitations in SQL Server 2012

    i baby sit a non profit that has a 6000 member email list, and we used send out various notifications just like you plan; the whole one at a time,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2014 at 12:15 pm

    #1685609

  • RE: Is there a better query criteria?

    djj (2/3/2014)

    Lowell, thanks for the reply. I am actually looking to delete the "bad" numbers so yes it is an IN.

    well going forward, you could add a check constraint...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 3, 2014 at 12:02 pm

    #1685602

Viewing 15 posts - 2,566 through 2,580 (of 13,459 total)