ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 10,143 total)

RE: Performance ISSUE by USING CURSOR HELP !!!!

ERIC CRUDELI (3/28/2013)
I ran the script on DI628SW
This is where it will be run from always?
The other server - DI81SW - this is a linked server?
^{“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 28, 2013 at 2:19 am

#1601485
RE: Reorder a custom order column

It's not really appropriate for a function, but a stored procedure could do the job - taking tablename, starting position and ending position as parameters. It would involve dynamic SQL....
^{“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 28, 2013 at 2:17 am

#1601484
RE: Performance ISSUE by USING CURSOR HELP !!!!

ERIC CRUDELI (3/25/2013)
I got some errors.
1 - easilyPatId unknow (easilyPadId come from #temp2)
2 -target table ' DI628SW.NOYAU_PATIENT.noyau. TELEPHONE_PATIENT ' of the clause OUTPUT INTO cannot be next to a...
^{“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 28, 2013 at 2:05 am

#1601480
RE: Count number of days that a doctor works

NineIron (3/27/2013)
My bad. The sample data was a bit too simple. The data I gave only had one patient per day.
😉
^{“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 27, 2013 at 10:30 am

#1601250
RE: Count number of days that a doctor works

You will probably have to aggregate by date then by month/docname to eliminate multiple visits per day. Follow Sean's advice - read the article, post ddl and dml to provide...
^{“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 27, 2013 at 8:03 am

#1601161
RE: how to insert datetime column into table

Steve JP (3/27/2013)
Steve JP (3/26/2013)
....
The issue with the convert is that the 3rd arguement is the style and is used to set the style when you convert from a datetime...
^{“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 27, 2013 at 7:42 am

#1601152
RE: problem with union

kayser.b (3/27/2013)
Hi all,
I have a problem with my "union" query, this a sample of my query. What I'd like to obtain is my 'effectif_enseignant' and my 'effectif_biatss' in two...
^{“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 27, 2013 at 5:37 am

#1601090
RE: Missing Lookup operator?

Hover over each of those clustered index seek operators and examine the columns output. What would you want a lookup for?
^{“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 27, 2013 at 5:34 am

#1601089
RE: how to insert datetime column into table

Steve JP (3/27/2013)
SELECT DateAsCharacter = CONVERT(VARCHAR(25),GETDATE(),100)
-- 'Mar 26 2013 12:49PM'
SELECT DateAsDate = CONVERT(DATETIME,'Mar 26 2013 12:49PM',100)
-- 2013-03-26 12:49:00.000
Dont totally agree with this as the following will error which is 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 27, 2013 at 5:06 am

#1601078
RE: Reorder a custom order column

You're welcome.
Taking it one step further (combining both queries into one, using variables for the current and new row id's), you might write something like this:
DECLARE @OldPos INT, @NewPos INT
--...
^{“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 27, 2013 at 3:44 am

#1601063
RE: Mixed joins

Here's a guess.
SELECT
CASE WHEN v.[Vendor Name] IS NULL THEN 'No Vendor' ELSE v.[Vendor Name] END AS TD,
e.TimesheetID AS TD,
e.UserName AS TD,
e.WorkOrderNbr AS TD,
format(e.ErrorDate, 'd')...
^{“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 26, 2013 at 8:53 am

#1600850
RE: Creation of auto Increment row

aaron.reese (3/26/2013)
I use ID fields to provide me with an absolutely unique (to the table) value that can be used as the Foriegn key to other tables. Its value...
^{“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 26, 2013 at 8:18 am

#1600825
RE: Extract Saturday through Friday as the weekly date range

fergusoj (3/26/2013)
I have found a code that brings back a weekly range, but it is not picking up the correct week. Also my week range is Saturday through Friday.
My query:
SELECT...
^{“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 26, 2013 at 8:16 am

#1600819
RE: how to populate month value equally to all business days value and help me to write Stored procedure for below scenario?

Experiment with the simple query I posted. Replace the ? with appropriate column names.
^{“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 26, 2013 at 7:36 am

#1600791
RE: how to populate month value equally to all business days value and help me to write Stored procedure for below scenario?

Table sales_month doesn't contain year. Start with something like this:
SELECT s.*, c.*
FROM Sales_Month s
INNER JOIN view1 c ON c.? = s.Month_Number
WHERE c.[year] = ?
Replace the question marks with something...
^{“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 26, 2013 at 7:27 am

#1600783

Viewing 15 posts - 4,951 through 4,965 (of 10,143 total)