ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,011 through 8,025 (of 10,143 total)

RE: Multiple reference in a single field

How will you determine which lookup table the foreign key value is from, for each row of table c?
^{“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

April 12, 2010 at 5:33 am

#1149932
RE: Today's Random Word!

Dour.
^{“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

April 12, 2010 at 4:28 am

#1149900
RE: Recursive cross join to get all available combinaisons

Paul White NZ (4/12/2010)
Chris Morris-439714 (4/12/2010)
Heh in any case, it's a little sluggish...
But full of recursive awesomeness!!!
Great code.
But so slow! I've got a little library of rCTE's now for 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

April 12, 2010 at 4:05 am

#1149892
RE: Recursive cross join to get all available combinaisons

Ninja's_RGR'us (4/9/2010)
-- Maxrows = 16: (65,535 row(s) affected) / 00:00:02
-- Maxrows = 20: (1,048,575 row(s) affected) / 00:00:46
-- Maxrows = 21: (2,097,151 row(s) affected) / 00:01:33
-- Maxrows = 22: (4,194,303...
^{“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

April 12, 2010 at 3:02 am

#1149877
RE: Today's Random Word!

RBarryYoung (4/11/2010)
Tom.Thomson (4/11/2010)
mbricker-600840 (4/11/2010)
Tom.Thomson (4/11/2010)
hippopotomonstrosesquipedalian
Is that a hippo that uses long words?
No, it's a sesquipedalian autological autonym. :hehe:
??? Really? I thought that it was a giant 75-footed carnivorous...
^{“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

April 12, 2010 at 2:15 am

#1149859
RE: Recursive cross join to get all available combinaisons

Garadin (4/9/2010)
Chris Morris-439714 (4/9/2010)
Oh cr@p - Seth, let me know if you're still considering setting up a challenge and I'll edit this out.
I am, but I know Jacob already has...
^{“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

April 9, 2010 at 9:32 am

#1149219
RE: Recursive cross join to get all available combinaisons

Ninja's_RGR'us (4/9/2010)
Chris Morris-439714 (4/9/2010)
Hi Ninja
It would be better to change the string list from comma-delimited to fixed position, three character positions per item - that way, the upper limit would...
^{“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

April 9, 2010 at 9:25 am

#1149214
RE: Recursive cross join to get all available combinaisons

Hi Ninja
It would be better to change the string list from comma-delimited to fixed position, three character positions per item - that way, the upper limit would be 999 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

April 9, 2010 at 7:34 am

#1149087
RE: Select Query

vaibhav.tiwari (4/9/2010)
Thanks ColdCoffee for your that much efforts your query is working fine and giving me expected output
but i got the simpler solution from some another forum i 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

April 9, 2010 at 7:27 am

#1149079
RE: Today's Random Word!

Deflate
^{“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

April 9, 2010 at 7:04 am

#1149052
RE: Are the posted questions getting worse?

jcrawf02 (4/9/2010)
I need some inspiration, what do you guys do when you start to lose focus and don't have the time to go get the crap kicked out of you...
^{“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

April 9, 2010 at 6:44 am

#1149032
RE: How to ‘shuffle’ column data along to remove empty strings.

This might help. I'd recommend rejigging it to return all address elements.
ALTER FUNCTION [dbo].[udf_AddressShuffle]
(
@AddressElementID INT = 1,
@Address1 varchar(80),
@Address2 varchar(80),
@Address3 varchar(80),
@Address4 varchar(80),
@Address5 varchar(80),
@Address6 varchar(80),
@Address7 varchar(80),
@Address8 varchar(80)
)
RETURNS VARCHAR(80)
AS
BEGIN
DECLARE @AddressElement VARCHAR(60)
;WITH Stringer 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

April 9, 2010 at 6:20 am

#1149011
RE: Select Query

vaibhav.tiwari (4/9/2010)
thats what i have done earlier but
Note that for ID 2 there is not any entry with action 'U'
so for that i need to show null.
Here's the simplest...
^{“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

April 9, 2010 at 6:09 am

#1149002
RE: Select Query

This is very basic, is it coursework?
If so, the following should get you started:
SELECT
s.ID,
s.M_ID,
s.T_Name,
s.T_Desc,
s.Sch_time,
createdon = i.ModifiedOn,
createdby = i.ModifiedBy,
LastModifiedOn = s.ModifiedOn,
LastModifiedBy =...
^{“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

April 9, 2010 at 5:43 am

#1148974
RE: sort order

-- Method 1
DROP TABLE #InList
CREATE TABLE #InList (RowID INT IDENTITY(1,1) NOT NULL, JoinValue INT)
INSERT INTO #InList (JoinValue)
SELECT 5 UNION ALL
SELECT 1 UNION ALL
SELECT 3 UNION 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

April 9, 2010 at 5:31 am

#1148968

Viewing 15 posts - 8,011 through 8,025 (of 10,143 total)