ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,521 through 5,535 (of 10,143 total)

RE: Function many arguments specified ? Need help . thanks.

SQL_path (9/28/2012)
Sean Lange (9/28/2012)
Not enough details to provide much of an answer. What is in @orders? What does the split function look like?
I would recommend using the splitter found...
^{“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

September 28, 2012 at 8:53 am

#1543459
RE: Function many arguments specified ? Need help . thanks.

SQL_path (9/28/2012)
Hi,
When I run the below query ...
Can you post the actual query you are attempting to run? There are several errors in the query you posted.
^{“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

September 28, 2012 at 8:44 am

#1543452
RE: Conversion failed when converting from a character string to uniqueidentifier.

What's the datatype of column [itt_jobcodeid], table [LibertyGasGroup_MSCRM].dbo.[FilteredITT_instruction]?
^{“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

September 28, 2012 at 7:38 am

#1543416
RE: Consolidate Overlapping Date Periods

dwain.c (9/27/2012)
Phil,
I think this is a pretty snappy query too.
;WITH Tally (n) AS (
SELECT TOP (SELECT 1+MAX(DATEDIFF(day, StartDate, EndDate)) FROM #RoomDates)
...
^{“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

September 28, 2012 at 7:21 am

#1543404
RE: Index consolidation

emile.milne (9/28/2012)
When I run this that missing index is top with 3BN advantage, server last restarted in June.
I use the DMV as a guide, and see if consolidation is possible...
^{“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

September 28, 2012 at 6:54 am

#1543391
RE: Which is better approach?

S_Kumar_S (9/28/2012)
Hi Friends
I do a check on a table if a particular record exists in table using IF EXISTS(SELECt 1 FROM tab1 WHERE id=1) inside a proc. Now if record...
^{“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

September 28, 2012 at 5:53 am

#1543360
RE: Sending list(of more than 50000 records) to the stored procedure as a parameter

gsd1 (9/28/2012)
Jeff Moden,
Thank you for the response.
I am receiving a list of 50000 records from a service.
I am planning to write a stored procedure with table-valued parameter and...
^{“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

September 28, 2012 at 5:39 am

#1543351
RE: Sorting multiple columns in various sort directions in a case statement

Barry Couch (9/28/2012)
opc.three (9/27/2012)
Is there a front-end? If so that is where I would put the sorting logic.
If not, or you must do this in the database, you could look...
^{“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

September 28, 2012 at 5:36 am

#1543346
RE: Index consolidation

emile.milne (9/28/2012)
Quick one I have the following index in place followed by a missing index. With a MASSIVE impact advantage missing index (second row).
How do I consolidate these 2 together,...
^{“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

September 28, 2012 at 5:35 am

#1543343
RE: Are the posted questions getting worse?

laurie-789651 (9/28/2012)
Grant Fritchey (9/28/2012)
anthony.green (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?
I missed the London...
^{“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

September 28, 2012 at 4:40 am

#1543316
RE: Are the posted questions getting worse?

laurie-789651 (9/28/2012)
ChrisM@Work (9/28/2012)
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?
If you do one...
^{“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

September 28, 2012 at 4:37 am

#1543314
RE: CAST (AS DECIMAL(30,5)) Behaving Differently

Shadab Shah (9/28/2012)
A is int, B is int and C is int in database
Thanks. Here's another way of looking at what Laurie posted;
DECLARE @A Int, @b-2 Int, @C Int;
SELECT @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

September 28, 2012 at 4:32 am

#1543310
RE: Are the posted questions getting worse?

Koen Verbeeck (9/28/2012)
laurie-789651 (9/28/2012)
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?
If you do...
^{“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

September 28, 2012 at 3:53 am

#1543284
RE: CAST (AS DECIMAL(30,5)) Behaving Differently

laurie-789651 (9/28/2012)
It's truncation of intermediate results.
Using Decimal data type will fix it:
-------------------------------------------------------------------------
DECLARE @A Int, @b-2 Int, @C Int;
SELECT @A = 9,
@b-2 = 3,
@C = 2;
SELECT Cast(SUM(@A*@B) / SUM(@C) AS DECIMAL(30,5));
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

September 28, 2012 at 3:51 am

#1543282
RE: Are the posted questions getting worse?

Koen Verbeeck (9/28/2012)
It still has the seat for the European Union/Committee. 😛
(always great traffic jams when they have a meeting)
I rest my case - room for only one seat 😀
^{“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

September 28, 2012 at 2:52 am

#1543255

Viewing 15 posts - 5,521 through 5,535 (of 10,143 total)