ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,686 through 8,700 (of 10,143 total)

RE: T-Sql rant

Bob Hovious (3/16/2009)
Isn't it nice that we can end this particular rant on a pleasant note?
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

March 16, 2009 at 11:10 am

#960433
RE: T-Sql rant

Bob Hovious (3/16/2009)
I am starting to cringe. Two threads
Sacrilege!!
Heresy!!
There can only be One!!
I think I need to go take my meds, now...
You'll be oblivious, Bob Hovious, that's...
^{“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

March 16, 2009 at 9:45 am

#960368
RE: T-Sql rant

Gaby Abed (3/16/2009)
Bob Hovious (3/16/2009)
All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.
Let us make great sacrifice of cursors and recursive CTEs....
"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

March 16, 2009 at 9:26 am

#960343
RE: -Cannot resolve collation conflict for UNION operation.

Once you've noted the server & column collations, you can take care of your collation conflict by following this example:
DROP TABLE CollationTest1
CREATE TABLE [dbo].[CollationTest1](
[CT1ID] [int] IDENTITY(1,1) NOT NULL,
[CT1] [varchar](30) COLLATE...
^{“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

March 16, 2009 at 7:57 am

#960235
RE: -Cannot resolve collation conflict for UNION operation.

karan457 (3/16/2009)
Hi iam not able to get can u explain please
A published article such as this will explain your problem far better than a single post in the forums section....
^{“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

March 16, 2009 at 6:04 am

#960143
RE: -Cannot resolve collation conflict for UNION operation.

There's an excellent article by Steve Jones here[/url] which describes the cause and the solution to your problem. If you're still unsure after reading the article, then repost for additional...
^{“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

March 16, 2009 at 4:58 am

#960113
RE: Are the posted questions getting worse?

RBarryYoung (3/14/2009)
OK, this is the most disturbing thing that I have read in a while. Read it closely. Brrrr...
Blimey - now ain't that a triumph of quantity over...
^{“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

March 15, 2009 at 1:33 am

#959874
RE: T-Sql rant

foxjazz (3/13/2009)
Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending on how 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

March 14, 2009 at 5:47 am

#959677
RE: What is wrong with this statement

ramadesai108 (3/13/2009)
If I run the proc with param 'Sp1' then i get the following:
Conversion failed when converting the nvarchar value 'Sp1' to data type int.
This could be a different issue...
^{“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

March 13, 2009 at 10:45 am

#959301
RE: Are the posted questions getting worse?

GilaMonster (3/13/2009)
Am I being too harsh here?
http://www.sqlservercentral.com/Forums/FindPost675279.aspx
Not really - he's prone to letting his enthusiasm get the better of him, but he's willing to learn and accepts corrections from others...
^{“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

March 13, 2009 at 9:17 am

#959225
RE: Are the posted questions getting worse?

Steve Jones - Editor (3/13/2009)
So do we teach people here? Or push them to get better? Or push them away and say you're not qualified" and you need to go...
^{“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

March 13, 2009 at 9:08 am

#959208
RE: Are the posted questions getting worse?

Ninja's_RGR'us (3/13/2009)
When you post a reply, there's a button with a green round icon and a link chain. That button posts up a javascript window to input the 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

March 13, 2009 at 8:54 am

#959180
RE: Splitting procedure text into a separate row

Here's a quick and dirty method for getting the content of a single sproc into a table, line by line:
IF OBJECT_ID('tempdb..#ProcedureLines') IS NOT NULL
DROP TABLE #ProcedureLines
CREATE TABLE #ProcedureLines (RowID INT...
^{“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

March 12, 2009 at 6:05 am

#958236
RE: CAST Statement - Month Conversion

Michael Valentine Jones (3/11/2009)
The code below is the standard way to get a date without the time in SQL Server.
Extensive testing (by me and many others) has shown that...
^{“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

March 11, 2009 at 10:31 am

#957660
RE: CAST Statement - Month Conversion

Michael Valentine Jones (3/11/2009)
Shorter.
select [Month] = right(100+month(getdate()),2)
Results:
Month
-----
03
Interesting...
Noticed this while messing with possible solutions...
SELECT
GETDATE(), -- Current Datetime
LEFT(GETDATE(), 19), -- StringDate 'Mar 11 2009 2:10PM'
CAST(LEFT(GETDATE(), 11)...
^{“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

March 11, 2009 at 8:17 am

#957511

Viewing 15 posts - 8,686 through 8,700 (of 10,143 total)