ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,931 through 9,945 (of 10,143 total)

RE: Updating Excel - Syntax error in UPDATE Statement

Hi Jim
It's likely that your problem is down to column data types - either the column you're updating or the column you're using as row identifier in Excel isn't being...
^{“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

March 11, 2008 at 4:30 am

#787848
RE: Dynamic Variables in Dynamic SQL?

You could avoid the use of those pesky variables altogether if you want...
DECLARE @script nvarchar(max)
SET...
^{“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

March 10, 2008 at 6:19 am

#787306
RE: JOIN issue

Frank
SELECT batchid, description, merchantno, settlementdate, amount
INTO #batch_detail
In this table you have multiple rows...
^{“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

March 9, 2008 at 4:33 am

#787125
RE: UPDATING using a WHILE LOOP?

I'd really appreciate that, thanks Debbie.
^{“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

March 7, 2008 at 9:38 am

#786779
RE: I got burned today at a SQL Server Interview!

TheSQLGuru (3/7/2008)
I guess someone has to play devil's advocate here, so here goes:
Brandie, you are totally off the mark. Do whatever you can to make the most money so...
^{“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

March 7, 2008 at 9:36 am

#786778
RE: UPDATING using a WHILE LOOP?

It's looking good! And thanks for the feedback 🙂
^{“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

March 7, 2008 at 7:46 am

#786656
RE: I got burned today at a SQL Server Interview!

Brandie Tarvin (3/7/2008)
Lynn Pettis said:
I just wish the computer would do want I want, not what I tell it to do. It would be sooo much easier.
Amen to...
^{“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

March 7, 2008 at 7:36 am

#786649
RE: UPDATING using a WHILE LOOP?

Yep. It's called an UPDATE ... FROM and will look something like this when you've finished...
UPDATE b SET b.start_date = a.start_date, b.end_date = a.end_date
FROM dbo.ECAF a
INNER JOIN dbo.ECAF_IDEAR b
ON...
^{“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

March 7, 2008 at 5:36 am

#786578
RE: UPDATING using a WHILE LOOP?

Absolutely Debbie! So we build the UPDATE in two steps; the first step, which is a simple SELECT, is easy to test - you have output rows to look at...
^{“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

March 7, 2008 at 5:22 am

#786571
RE: UPDATING using a WHILE LOOP?

I'm guessing it will look something like this...
SELECT a.PersonID, a.start_date, a.end_date
FROM dbo.ECAF a
INNER JOIN dbo.ECAF_IDEAR b
ON b.PersonID = a.PersonID AND a.start_date IS NULL AND b.end_date IS NULL
WHERE a.start_date IS...
^{“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

March 7, 2008 at 5:15 am

#786569
RE: UPDATING using a WHILE LOOP?

Good, that makes things quite a bit simpler. Now, can you write a SELECT query from your source table which contains the rows and columns which you are using to...
^{“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

March 7, 2008 at 5:08 am

#786565
RE: UPDATING using a WHILE LOOP?

Hi Debbie
Your first step for this UPDATE should be a SELECT which returns the rows containing the data which you want to use as your reference, i.e. which will overwrite...
^{“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

March 7, 2008 at 4:57 am

#786557
RE: I got burned today at a SQL Server Interview!

Jeff Moden (3/6/2008)
Why is there always enough time to do it again but never enough time to do it right the first time? 😛
TSQL or your cooking? 😀
No matter...
^{“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

March 6, 2008 at 8:40 am

#786043
RE: enhancing sql command

Bob Fazio (3/5/2008)
The more I look at this, there is almost nothing that you are going to be able to do to help this query. The only suggestion I...
^{“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

March 6, 2008 at 8:17 am

#786017
RE: enhancing sql command

asmaa.sbaihi, you should run some experiments to establish exactly what you need in your query.
Something along the lines of...
This is your baseline, run it and record the results:
SELECT COUNT(DISTINCT(RecordedCalls.ID)) AS...
^{“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

March 5, 2008 at 10:19 am

#785621

Viewing 15 posts - 9,931 through 9,945 (of 10,143 total)