ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,276 through 4,290 (of 10,143 total)

RE: Select variable based upon sub query

Why not use a percentage for the tolerance?
^{“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

July 29, 2013 at 7:36 am

#1636636
RE: Handle error record from User Defined Function

No you can't, but you can fix the function so that it doesn't pass invalid values to substring or whatever.
Can you confirm what the function is supposed to 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

July 29, 2013 at 6:39 am

#1636609
RE: Can you suggest some rewriting or indexes on this query...

Parameter sniffing is likely to affect your query. Goggle it and look for articles by known folks - I think Gail has one of the best articles.
More importantly, there...
^{“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

July 29, 2013 at 6:17 am

#1636602
RE: Fiscal Week in TSQL

Something to get the ball rolling. There are folks here who love date arithmetic and will come up with something quicker and more elegant, but you get the general idea;
;WITH...
^{“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

July 29, 2013 at 6:09 am

#1636599
RE: Can you suggest some rewriting or indexes on this query...

Why do you have
isnull(10172,0)=0
in your query at all?
^{“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

July 29, 2013 at 4:00 am

#1636572
RE: Can you suggest some rewriting or indexes on this query...

Use one query instead of two almost-identical ones.
^{“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

July 29, 2013 at 3:49 am

#1636568
RE: Convert Row to Column without using any other column for Pivot

It's not a brilliant script with the errors as they are: if you were to correct the ORDER BY (or better still, introduce a PK) and remove the ISNULLs from...
^{“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

July 29, 2013 at 3:31 am

#1636563
RE: Need T-SQL Query Help- Urgent

Thanks for the very generous feedback, Mr Kapsicum.
If you're interested in how the method works, here's an excellent article by Dwain Camps[/url].
^{“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

July 29, 2013 at 2:39 am

#1636556
RE: When NULL IS NOT NULL

No error on this platform:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit)
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

July 29, 2013 at 2:14 am

#1636546
RE: create table valued function

SQL_Surfer (7/28/2013)
Sorry, I cannot post the actual code for security reasons....
Then obfuscate column and table names! Your pseudocode is so full of errors that making sense of it is more...
^{“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

July 29, 2013 at 2:09 am

#1636543
RE: Need T-SQL Query Help- Urgent

DROP TABLE #MySampleData
CREATE TABLE #MySampleData (Employee_id INT, IS_Al INT, Attendance DATE)
INSERT INTO #MySampleData (Employee_id, IS_Al, Attendance)
SELECT 1998, 1, '2013-03-18' UNION ALL
SELECT 1998, 1, '2013-03-19' UNION ALL
SELECT 1998, 1, '2013-03-21'...
^{“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

July 29, 2013 at 1:31 am

#1636536
RE: Covering Index Question

Columns in the INCLUDE list are not part of the key. Crudely speaking and with the small amount of detail provided, your suggestion of an index with patientnumber as key...
^{“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

July 26, 2013 at 8:57 am

#1636200
RE: how to insert commma seperated vales as a input?

nitha jen (7/26/2013)
so there is a way to get a o/p using dynamic sql right..but how....i don't know many thing about dynamic sql....how do i insert the values in 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

July 26, 2013 at 8:04 am

#1636167
RE: SQL Query to subtract credit from Invoice Total

Should be straightforward from here, Bill:
DROP TABLE #Invoices
CREATE TABLE #Invoices (InvoiceNo VARCHAR(10), Amount DECIMAL(10,2))
INSERT INTO #Invoices (InvoiceNo, Amount)
SELECT '1001', $230.00 UNION ALL --
SELECT '1002', $135.56 UNION ALL --
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

July 26, 2013 at 7:28 am

#1636150
RE: Are the posted questions getting worse?

Koen Verbeeck (7/24/2013)
jcrawf02 (7/24/2013)
Koen Verbeeck (7/23/2013)
Lowell (7/23/2013)
Koen Verbeeck (7/23/2013)
Didn't know this site censored some words.
Hum. Whaddayaknow...
Oh man,so you've been added into the naughty list, then right?
Probably, if I wasn't already...
^{“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

July 26, 2013 at 6:43 am

#1636123

Viewing 15 posts - 4,276 through 4,290 (of 10,143 total)