ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,986 through 9,000 (of 10,143 total)

RE: UPDATE from CTE

Philip Horan (1/6/2009)
Thanks guys and yes I am an old git 🙂
Old Dogs, new tricks....possible?
Thanks,
Phil.
'Course! I'm an old git and I learn something new here every day - see above,...
^{“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

January 6, 2009 at 10:02 am

#921935
RE: problem in query

Cool.
Now, change thisIF @test1 + @test2 + @test3 > 0
to this IF ISNULL(@test1, 0) + ISNULL(@test2, 0)+ ISNULL(@test3, 0)> 0
Also, put a new line in as follows...
...
^{“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

January 6, 2009 at 9:52 am

#921927
RE: problem in query

Pat, are you able to answer the questions?
Chris Morris (1/6/2009)
pat (1/6/2009)
thanks for reformating.
It needs to go on to end of last insert!!
Thanks
What does?
How many times does the PRINT statement execute?
What...
^{“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

January 6, 2009 at 9:32 am

#921900
RE: problem in query

pat (1/6/2009)
thanks for reformating.
It needs to go on to end of last insert!!
Thanks
What does?
How many times does the PRINT statement execute?
What values do you get for @test1, @test2 & @test3?...
^{“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

January 6, 2009 at 8:50 am

#921855
RE: problem in query

How many times does the PRINT statement execute?
Here's the whole thing reformatted a little for readability:
[font="Courier New"]ALTER PROCEDURE [dbo].[testproc]
@srcFilename VARCHAR(256)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
--...
^{“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

January 6, 2009 at 8:37 am

#921840
RE: Are the posted questions getting worse?

GilaMonster (1/6/2009)
Chris Morris (1/6/2009)
GilaMonster (1/6/2009)
I recommend a 20-sided dice.
Six is sufficient...http://en.wikipedia.org/wiki/The_Dice_Man
Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.
I have 4, 6, 8, 10...
^{“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

January 6, 2009 at 7:21 am

#921769
RE: Are the posted questions getting worse?

GilaMonster (1/6/2009)
Grant Fritchey (1/6/2009)
URGENT!
How do you pick indexes... Oh lordy
I recommend a 20-sided dice.
Six is sufficient...http://en.wikipedia.org/wiki/The_Dice_Man
^{“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

January 6, 2009 at 7:08 am

#921752
RE: Take off matching invoice from list

SELECT s.name, s.PHC_ID, s.[Contact Date], s.[Referral Date], s.activity__2
FROM dbo_pod_surgery s
WHERE s.PHC_ID IN ('22/15729', '23/13278')
AND s.activity__2 <> 'AS0630'
^{“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

January 6, 2009 at 3:58 am

#921653
RE: need a simple query

shiwani2002sg (1/5/2009)
and its stated that the value of A would be same in both the tables , row-by-row.
This looks like homework, but at least you're putting in 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

January 6, 2009 at 1:59 am

#921610
RE: UPDATE from CTE

RBarryYoung (1/5/2009)
See that Update solution that I just posted in the "Cursors Be Gone" thread. It's got a derived table, that arguably could/should be a CTE: http://www.sqlservercentral.com/Forums/FindPost630181.aspx
Thanks Barry, I...
^{“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

January 6, 2009 at 12:31 am

#921593
RE: UPDATE from CTE

Philip Horan (1/5/2009)
Chris I was just playing with the CTE concept as I am quite new to TSQL.
Moving forward part of the learning process is to know when to employ...
^{“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

January 5, 2009 at 3:08 pm

#921456
RE: SELECTing from Excel using OPENROWSET

Check that the file is not already open.
^{“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

January 5, 2009 at 2:01 pm

#921424
RE: Stripping alpha numeric charecters

GSquared (1/5/2009)
A single-pass, hard-coded replace command, on the other hand, only took 194 milliseconds to do the same thing:
update #T
set Col4 =
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(col1, '1', ''),
'2', ''),
'3', ''),
'4', ''),
'5', ''),
'6',...
^{“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

January 5, 2009 at 1:32 pm

#921405
RE: What Server Am I Running From

Hi Mattie
This is how I've implemented your scenario:
I have a reporting db on each server instance, call it say ReportingDB. The reporting db contains sp's, functions and tables which relate...
^{“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

January 5, 2009 at 12:44 pm

#921373
RE: What Server Am I Running From

MattieNH (1/5/2009)
Steve,
Not that I had tried that, but no. It would be nice to get something like MyServer.MyDomain.OurSystem, but I'd settle for 181.50.144.3. We're trying to build 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

January 5, 2009 at 10:04 am

#921267

Viewing 15 posts - 8,986 through 9,000 (of 10,143 total)