ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,911 through 8,925 (of 10,143 total)

RE: IF THEN ELSE SQL STATEMENT

IF Cust_Address_v.ID IS NULL
Which row?
It's not immediately apparent from the code what you're trying to do here, because depending upon what your result is from this conditional - which...
^{“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 14, 2009 at 1:39 pm

#926920
RE: Select from String

Terence Keys (1/14/2009)
This is what I used but it returns everything AFTER the word Industry as well..
SELECT SUBSTRING(routingheader, charindex('funder',routingheader), charindex('industry',routingheader)) AS ROUTINGHEADER
All I need is what is between the two...
^{“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 14, 2009 at 6:20 am

#926513
RE: Are the posted questions getting worse?

Jeff Moden (1/13/2009)
Steve Jones - Editor (1/13/2009)
And here I was thinking pork chops were pork chops, not developers' heads.
Oooohhhh.... I might be in trouble... I've got buckets full of things...
^{“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 14, 2009 at 5:46 am

#926497
RE: how to query a variable of the column headers

Joe
Please post the results of the following two queries:
SELECT TOP 5 * FROM dbo.DECleared
SELECT TOP 5 * FROM dbo.SomaticMCCleared
Cheers
ChrisM
^{“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 13, 2009 at 8:11 am

#925912
RE: How to remove blank values and load data into one row

You might find this a lot easier to import into a staging table in the format you have, then selecting from there.
The query would look something like
SELECT AccNo, Firstname,...
^{“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 13, 2009 at 5:10 am

#925763
RE: how to query a variable of the column headers

josephptran2002 (1/9/2009)
below are the codes for adding all of these date format together in order to get TotalCleared and the date for each day showing how many cases have been...
^{“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 12, 2009 at 2:12 pm

#925581
RE: How to remove blank values and load data into one row

Phil Parkin (1/12/2009)
Is this a homework question from a college course, by any chance?
This thread looks too similar to be a coincidence:
http://www.sqlservercentral.com/Forums/Topic634303-148-1.aspx
Phil
Hey Phil, you might want to post this 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

January 12, 2009 at 7:22 am

#925252
RE: How to retrieve 2nd value of a user defined column in database

Dugi (1/11/2009)
Ok Jeff there is the simple code from me...so your code is in advanced level 😛
SELECT
SUBSTRING(Y,3,1) AS Y -- this retrieve allways the second...
^{“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 11, 2009 at 8:09 am

#924987
RE: Adding running number on groups of records in a table

Jeff Moden (1/9/2009)
Heh... ah yes... THAT one. And because I'm a professional, I'm also supposed to be nice in the face of such abuse. I rewrote that one...
^{“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 9, 2009 at 8:08 am

#924203
RE: Are the posted questions getting worse?

Jack Corbett (1/9/2009)
Grant Fritchey (1/9/2009)
GilaMonster (1/9/2009)
Grant Fritchey (1/9/2009)
There's about 3 inches of completely frozen snow in my yard and another 4-6 inches of the fluffy crap on the way tomorrow...
^{“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 9, 2009 at 8:04 am

#924199
RE: Adding running number on groups of records in a table

Jeff Moden (1/8/2009)
Chris Morris (1/8/2009)
Apart from anything else, the emphasis on teaching will give you quite a bit of leeway with the "give a man a fish" scenario. We've all...
^{“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 9, 2009 at 6:48 am

#924127
RE: writing function fordate

Good try Gary - but TimClosestatus comes from a table...
^{“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 9, 2009 at 6:43 am

#924120
RE: Update Problem Still Persists

Nicholas, can you please post the exact query that you are using to get the data from UserStats which shows these figures?
Cheers
ChrisM
^{“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 9, 2009 at 6:24 am

#924091
RE: Help needed to avoid dynamic SQL.

Use the query with the left outer join always there, and put the conditional into the SELECT list instead. If performance is a problem when the left outer join is...
^{“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 9, 2009 at 6:19 am

#924086
RE: Are the posted questions getting worse?

Grant Fritchey (1/9/2009)
Here in New England... it's a New England winter only a little more so. We could use a bit of global warming. There's about 3 inches of completely...
^{“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 9, 2009 at 5:52 am

#924063

Viewing 15 posts - 8,911 through 8,925 (of 10,143 total)