ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 10,143 total)

RE: Are the posted questions getting worse?

Jeff Moden (8/23/2012)
ChrisM@Work (8/23/2012)
Brandie Tarvin (8/23/2012)
... Tootsie Rolls...
Are we back on Clinton??
It Depends... are you wearing a blue dress? :-):-D:-P:hehe:
That blue dress? No, it's still in the wash. Besides, 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

August 24, 2012 at 2:22 am

#1529604
RE: Cannot get Left JOIN to work correctly

tshad (8/23/2012)
Hi Cadavre,
No problem.
I understand what Chris had explained about the CROSS JOIN. I was trying apply that to the situation I have which I couldn't make work so...
^{“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

August 24, 2012 at 2:18 am

#1529603
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

SQL Kiwi (8/24/2012)
...This is not a democracy....
Absolutely. The weight of opinion won't magically change the way SQL Server works, or anything else for that matter - and yet it's depressingly...
^{“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

August 24, 2012 at 2:15 am

#1529601
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

SQL Kiwi (8/23/2012)
mburbea (8/22/2012)
While this article is a bit old I did want to comment on a trick that I've discovered to build an itvf for a xml splitter. This...
^{“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

August 24, 2012 at 2:05 am

#1529596
RE: Are the posted questions getting worse?

Brandie Tarvin (8/23/2012)
... Tootsie Rolls...
Are we back on Clinton??
^{“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

August 23, 2012 at 8:40 am

#1529290
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Lynn Pettis (8/23/2012)
ChrisM@Work (8/23/2012)
mtassin (8/23/2012)
I'm not seeing the XML trouncing the Delimittedsplit8k tvf though.
....
Nor me. I've plugged it into the splitter test harness from the article attachent and on some...
^{“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

August 23, 2012 at 8:31 am

#1529280
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mtassin (8/23/2012)
I'm not seeing the XML trouncing the Delimittedsplit8k tvf though.
....
Nor me. I've plugged it into the splitter test harness from the article attachent and on some permutations of the...
^{“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

August 23, 2012 at 8:09 am

#1529266
RE: Need Create View Script for all tables

Ankur Bajaj (8/23/2012)
Heres the explanation given by my technical lead to the client for using views for reporting purposes while justifying no performance impact to App users accessing the base...
^{“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

August 23, 2012 at 5:33 am

#1529187
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Mark-101232 (8/23/2012)
ChrisM@Work (8/23/2012)
mburbea (8/22/2012)
While this article is a bit old I did want to comment on a trick that I've discovered to build an itvf for a xml splitter. This...
^{“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

August 23, 2012 at 5:01 am

#1529170
RE: Need Create View Script for all tables

Ankur Bajaj (8/23/2012)
People having a good laugh at my cost! +1 to that.
...
Nobody is laughing at you. Some of the folks who have responded on this thread may at some...
^{“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

August 23, 2012 at 4:35 am

#1529155
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mburbea (8/22/2012)
While this article is a bit old I did want to comment on a trick that I've discovered to build an itvf for a xml splitter. This will perform...
^{“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

August 23, 2012 at 4:07 am

#1529145
RE: Cannot get Left JOIN to work correctly

tshad (8/23/2012)
Actually, it isn't exactly the same way.
I was trying to figure out how to get your way to work with a middle table and couldn't get it to work.
You're...
^{“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

August 23, 2012 at 2:18 am

#1529089
RE: Are the posted questions getting worse?

Stefan Krzywicki (8/22/2012)
Brandie Tarvin (8/22/2012)
Allow me to correct myself.
ChrisM@Work (8/22/2012)
Brandie Tarvin (8/22/2012)
President Bill Clinton once said "Define intercourse" ... or maybe "define sex"... in an interview about a sex...
^{“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

August 22, 2012 at 9:41 am

#1528745
RE: T-SQL String manipulation - 2(Reading numeric values from String appended by '.')

Cadavre (8/22/2012)
Phil Parkin (8/22/2012)
Maybe I jumped to the wrong conclusion - I didn't spend much time considering the question itself. I just liked the fact that you had used fairly...
^{“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

August 22, 2012 at 9:36 am

#1528737
RE: T-SQL String Manipulation- Need help

Cadavre (8/22/2012)
ChrisM@Work (8/22/2012)
SELECT
Stringy,
Stuffy = STUFF(STUFF(STUFF(Stringy,x3.startpos+1,x3.endpos-x3.startpos-1,'n'),x2.startpos+1,x2.endpos-x2.startpos-1,'n'),x1.startpos+1,x1.endpos-x1.startpos-1,'n')
FROM (SELECT Stringy = 'A1(1).B22(10).C345(100)') d
CROSS APPLY (SELECT startpos = CHARINDEX('(',Stringy,1), endpos = CHARINDEX(').',Stringy+'.',1)) x1
CROSS APPLY (SELECT startpos = CHARINDEX('(',Stringy,x1.startpos+1), endpos = CHARINDEX(').',Stringy+'.',x1.endpos+1)) x2
CROSS...
^{“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

August 22, 2012 at 8:49 am

#1528687

Viewing 15 posts - 5,821 through 5,835 (of 10,143 total)