ChrisM@Work

Forum Replies Created

Viewing 15 posts - 10,126 through 10,140 (of 10,143 total)

RE: Linking rows

Hi Stewart
Peter Larsson recently posted an elegant solution to this problem, see
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=367397&p=4
Cheers
ChrisM
^{“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

June 19, 2007 at 10:13 am

#713888
RE: Workplace Sabatoge or Incompetance. . .

Hi EM
This wouldn't be a metal-plating company in Harlow, Essex by any chance? I had the exact same experience there about 7 years ago. It was infuriating! Management wouldn't listen...
^{“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

June 15, 2007 at 5:52 am

#713215
RE: Round to Even (aka Banker''''s Rounding) - The final function

Heh heh lovely job lads!
^{“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

June 14, 2007 at 6:20 am

#712896
RE: Burnt Out

Hi Loner
You may be sliding down the slippery slope of Clinical Depression, a place where you really don't want to go. Make a few enquiries and find yourself a local...
^{“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

June 12, 2007 at 4:48 am

#712209
RE: Subqueries
```
And since there's only one SELECT from #temp...
```
```
 
```
```
select
        MetroCity as City,        
    ...
```
^{“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
June 12, 2007 at 4:04 am

#712201
RE: INSERT/EXEC With multiple returned datasets

Hi Dark Angel
<< I have a stored procedure (SP1) that returns multiple data sets.
i.e., the last 3 lines read:
SELECT * 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

June 5, 2007 at 8:13 am

#710854
RE: seperate city and state/province tables?

Hi Bobs
Creating a separate table for city and province/state is probably over-normalization - you will still need a pointer (fk) in your customer table (and of course the pk in...
^{“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

June 5, 2007 at 5:32 am

#710823
RE: Update leading Zeros
Found this on our dev server:
```
-- Author:  Igor Nikiforov,  Montreal,  EMail: udfs@sympatico.ca   
 -- PADL(), PADR(), PADC() User-Defined Functions
 -- Returns a string from an expression, padded 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
June 5, 2007 at 2:38 am

#710808
RE: Case statement Question

Hi Mike
Yes, you can use CASE (simple or searched) in a WHERE.
What are you comparing to [('A','E','I','O','U') else ('B','C','D','F')]?
Cheers
ChrisM
^{“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

June 4, 2007 at 8:45 am

#710611
RE: Select And Count Consecutive Numbers

<proprietary UPDATE clause of SQL Server... magic... and blows cursor speed away>
This solution is really cute, and timely too - there are several current threads looking to a sequential...
^{“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

June 4, 2007 at 8:31 am

#710607
RE: comparing rows of the same table

Lovely! Nice way to end a friday.
^{“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

June 4, 2007 at 3:42 am

#710545
RE: comparing rows of the same table
No problem Ganesh -
```
--===== Create a test table and populate it with test data
 CREATE TABLE #MyHead (userid INT, logintime DATETIME)
 INSERT INTO #MyHead (userid, logintime)
```
```
 SELECT 1234, '2007-05-10 17:18:00' UNION...
```
^{“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
June 1, 2007 at 9:15 am

#710365
RE: DateTime Query
sql2day
Here's a stub query
```
SELECT * FROM TableName t
WHERE DATEPART (hh, t.DateTimeColumn) = '23'
 AND DATEPART (mm, t.DateTimeColumn) = '59'
 AND DATEPART (ss, t.DateTimeColumn) = '59'
```
but as Jeff pointed out, if you want...
^{“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
June 1, 2007 at 7:41 am

#710330
RE: Get Error when using Execute command
<<There is no way for to split the string I received to do what you write.>>
There's always a way...
```
DECLARE @STR AS VARCHAR(8000), @substr VARCHAR(500), @Statement CHAR(6), @EndPos INT
```
```
SET @STR =...
```
^{“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
June 1, 2007 at 6:24 am

#710303
RE: grouping without aggregates

Hi Jeff
We're on SQL2k here. Can't wait to play with CTE on the next contract though.
Regarding matching on dates - good point. If an identity column is available, the same...
^{“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

June 1, 2007 at 5:07 am

#710282

Viewing 15 posts - 10,126 through 10,140 (of 10,143 total)