ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,761 through 8,775 (of 10,143 total)

RE: Can any one tell me?

Write a function to do it. There are methods of converting numbers to text from 0 up to one million and all numbers in between, but you're working with quite...
^{“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

February 26, 2009 at 5:21 am

#950519
RE: How to find exact match of a value in a table

Samuel Vella (2/26/2009)
Chris Morris (2/26/2009)
See also here.
Nice circular reference there Chris 😀
Whens your next TV show coming out?
Cheers! Looks a lot like homework hey?
Nah that's a different Chris Morris,...
^{“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

February 26, 2009 at 4:07 am

#950498
RE: To replace exact match in sql server

See also here.
^{“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

February 26, 2009 at 3:47 am

#950493
RE: How to find exact match of a value in a table

See also here.
^{“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

February 26, 2009 at 3:47 am

#950492
RE: How to find exact match of a value in a table

Use the spaces before and after the word 'User', like this:
REPLACE(mycolumn, ' User ', ' Employee ')
^{“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

February 26, 2009 at 3:34 am

#950489
RE: Are the posted questions getting worse?

Grant Fritchey (2/25/2009)
I agree with Jack and Barry. Yes, I try to post that way all the time. No, I don't think we need to get into sweating standards like...
^{“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

February 25, 2009 at 8:41 am

#950031
RE: Are the posted questions getting worse?

Lynn Pettis (2/24/2009)
Alvin Ramard (2/24/2009)
Yesterday was an interesting day on here. I don't think any of the posters were picked on, except for a quick reference to a White.house...
^{“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

February 24, 2009 at 8:17 am

#949411
RE: Are the posted questions getting worse?

Bob Hovious (2/24/2009)
There was also an abortive discussion about the unreasoning prejudice of humans against short, scaly, lizard-looking aliens with big ears and bad grammar. Steve may have...
^{“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

February 24, 2009 at 7:22 am

#949335
RE: Stored procedure to Update the table

raveen4u (2/23/2009)
Can anybody help in writing a stored procedure to Update a table with ID as primary key
Thanks in advance
Yes, but you will need to provide much more information -...
^{“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

February 23, 2009 at 8:25 am

#948630
RE: Are the posted questions getting worse?

Some individual posts are gems and worthy of being saved as articles. It would be real handy to be able to put such articles into the "briefcase".
^{“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

February 23, 2009 at 4:08 am

#948498
RE: How to handle CASE related query??

mail2payan (2/20/2009)
What should I do??
You should spend a little time reading the earlier replies from Steve Jones and Bitbucket.
Also, check out "table alias" and "derived table" in BOL.
^{“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

February 20, 2009 at 1:32 pm

#947873
RE: Are the posted questions getting worse?

Grant Fritchey (2/20/2009)
Heck, he's gone full circle and started posting his first message all over again.
Yep...he's been working full-time on the same code - the same statement goddammit - for...
^{“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

February 20, 2009 at 1:21 pm

#947855
RE: How to handle CASE related query??

Thanks Bitbucket, that one's new to me! I assumed that the error was from this..
WHEN 'Deniel of Grade' then 'DN'
WHEN 'Absent' then...
^{“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

February 20, 2009 at 10:06 am

#947659
RE: How to handle CASE related query??

Start with something small and straightforward. Work with it until you understand it and you're comfortable with how it works, and progress from there.
Building a large complex query and...
^{“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

February 20, 2009 at 9:52 am

#947647
RE: how can i update multiple columns in one statement

You can only update one table in an UPDATE statement, but the answer to your question is yes -
EXEC my_stored_procedure_which_updates_800_tables
^{“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

February 20, 2009 at 6:55 am

#947461

Viewing 15 posts - 8,761 through 8,775 (of 10,143 total)