Viewing 15 posts - 8,911 through 8,925 (of 10,144 total)
Jeff Moden (1/14/2009)
January 15, 2009 at 4:03 am
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...
January 14, 2009 at 1:39 pm
Terence Keys (1/14/2009)
SELECT SUBSTRING(routingheader, charindex('funder',routingheader), charindex('industry',routingheader)) AS ROUTINGHEADER
All I need is what is between the two...
January 14, 2009 at 6:20 am
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...
January 14, 2009 at 5:46 am
Joe
Please post the results of the following two queries:
SELECT TOP 5 * FROM dbo.DECleared
SELECT TOP 5 * FROM dbo.SomaticMCCleared
Cheers
ChrisM
January 13, 2009 at 8:11 am
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,...
January 13, 2009 at 5:10 am
josephptran2002 (1/9/2009)
January 12, 2009 at 2:12 pm
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...
January 12, 2009 at 7:22 am
Dugi (1/11/2009)
SELECT
SUBSTRING(Y,3,1) AS Y -- this retrieve allways the second...
January 11, 2009 at 8:09 am
Jeff Moden (1/9/2009)
January 9, 2009 at 8:08 am
Jack Corbett (1/9/2009)
Grant Fritchey (1/9/2009)
GilaMonster (1/9/2009)
Grant Fritchey (1/9/2009)
January 9, 2009 at 8:04 am
Jeff Moden (1/8/2009)
Chris Morris (1/8/2009)
January 9, 2009 at 6:48 am
Good try Gary - but TimClosestatus comes from a table...
January 9, 2009 at 6:43 am
Nicholas, can you please post the exact query that you are using to get the data from UserStats which shows these figures?
Cheers
ChrisM
January 9, 2009 at 6:24 am
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...
January 9, 2009 at 6:19 am
Viewing 15 posts - 8,911 through 8,925 (of 10,144 total)