ChrisM@Work

Forum Replies Created

Viewing 15 posts - 421 through 435 (of 10,143 total)

RE: Looking to sort two queries by Date, Time

<<Scratches head>>
There are three queries...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 30, 2018 at 9:25 am

#1977887
RE: SQL Probe Bitmap 1008 high CPU

Actual execution plan is always preferred over estimated plan - more information.
What proportion of CAVOLS_Keys is duplicated on REQUIS
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 30, 2018 at 9:17 am

#1977884

RE: Help me in update - complex

JoNTSQLSrv - Monday, January 29, 2018 7:24 AM

subramaniam.chandrasekar - Monday, January 29, 2018 6:23 AM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 29, 2018 at 7:32 am

#1977688

RE: Help me in update - complex

JoNTSQLSrv - Friday, January 26, 2018 9:50 AM

ChrisM@Work - Thursday, January 25, 2018 2:57 AM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 26, 2018 at 9:58 am

#1977554

RE: merging time-series period records

INSERT INTO...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 26, 2018 at 9:52 am

#1977552

RE: A Different Problem with Full Details

xtrmus2319 - Thursday, January 25, 2018 9:27 AM

drew.allen - Thursday, January 25, 2018 9:24 AM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 25, 2018 at 9:30 am

#1977376

RE: get the last active data

Or maybe this:

SELECT lv.*,

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 25, 2018 at 7:55 am

#1977342

RE: get the last active data

sindhupavani123 - Thursday, January 25, 2018 7:09 AM

Iâ€™m trying to get the last active data and insert that in the current...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 25, 2018 at 7:28 am

#1977333

RE: Session temp tables not visible

Not really - the temp table will be dropped when the stored procedure completes, because this isn't the correct code for identifying whether or not a temp table exists.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 25, 2018 at 7:04 am

#1977317

RE: Help me in update - complex

JoNTSQLSrv - Wednesday, January 24, 2018 10:30 PM
Sorry , is it too hard guys ?

Not at all. The problem is, there are...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 25, 2018 at 2:57 am

#1977277

RE: Help me in update - complex

-- try this

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 24, 2018 at 9:52 am

#1977144

RE: Update Table A when table B columns are updated and vice versa

komal145 - Monday, January 22, 2018 2:21 PM

How do i Update Table A columns when Table B is updated. Also I need...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 24, 2018 at 3:04 am

#1977063

RE: Question Regarding Date logic

below86 - Tuesday, January 23, 2018 7:47 AM

ChrisM@Work - Tuesday, January 23, 2018 1:23 AM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 23, 2018 at 7:52 am

#1976908

RE: Tying MAX() value to <= value from another table

How about this, Brandie. You could use DATEDIFF() to find which of two address rows is closest in date to the invoice.
SELECT i.InvoiceNo, i.AddressCode, i.PayDate, '#' '#', a.LastAccountDate,...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 23, 2018 at 7:50 am

#1976905

RE: Question Regarding Date logic

below86 - Monday, January 22, 2018 10:58 AM

In a follow up post KGJ-dev wanted to be able to pass any number of...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

January 23, 2018 at 1:23 am

#1976861

Viewing 15 posts - 421 through 435 (of 10,143 total)