Viewing 15 posts - 466 through 480 (of 1,183 total)
I would think Mark's solution with a range table and using an INNER join would be better. I would also move the ORDERing out of the procedure and into the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 16, 2008 at 9:31 am
No questions are stupid, they're just sometimes "untimely" as in the answer comes to you right after you ask it.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 16, 2008 at 9:04 am
adam (6/16/2008)
Thanks. I would like to actually convert these permanently to upper case.Carolyn Richardson (6/16/2008)
Try SELECT UPPER('John Doe')
UPDATE yourTable
SET yourColumn = UPPER(yourColumn)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 16, 2008 at 9:00 am
SELECT UPPER('yourText')
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 16, 2008 at 8:52 am
This is NOT a direct answer to your question, but perhaps it will get you thinking towards a "compact" solution.
This requires the use of a numbers or "tally" table described...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 16, 2008 at 8:24 am
In your case, just plug the numbers into your query.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 5, 2008 at 2:04 pm
With all due respect, this community is for people looking for assistance, not complete solutions.
I think I speak for eveyone here in saying that we would more than happy to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 5, 2008 at 1:42 pm
ramaanujamr (6/5/2008)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 5, 2008 at 1:16 pm
James Raddock (6/4/2008)
Select the results in a temp tableOpen a forward on read cursor and concatenate into a varchar(max) variable.
OUCH, stay away from cursors!!!!
I would suggest ...
DECLARE @concatRow VARCHAR(MAX)
-- create...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 4, 2008 at 11:44 am
DECLARE @t TABLE (testData VARCHAR(50))
INSERT @t
SELECT 'ghghgh ghghgh ghghg' UNION ALL
SELECT 'ghghgh ghghxxxhghg' UNION ALL
SELECT 'ghghgxhghg' UNION...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 3, 2008 at 1:45 pm
Hmmm, not off the top of my head.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 3, 2008 at 1:23 pm
You also need to think about the special case when E.OBSERV_VALUE = @VALUE. 😛
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 3, 2008 at 12:51 pm
SELECT
DISTINCT C.TEST_DESC AS LAB_TEST_DESC
,E.RESULT_DESC
FROM .....
WHERE
(C.TEST_DESC = @test-2 OR @test-2...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 3, 2008 at 12:38 pm
That is indeed correct.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 3, 2008 at 8:45 am
CREATE PROCEDURE dbo.PrepTickets_GET_ALL(@partialKey VARCHAR(12) = NULL)
AS
BEGIN
SET NOCOUNT ON
SELECT
*
FROM
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 3, 2008 at 8:08 am
Viewing 15 posts - 466 through 480 (of 1,183 total)