Jeff Moden (1/14/2009)

---

Actually... I built a "cannon" to fire the potato part of the pork chop dinner. 5 foot barrel with a 5 foot extension (haven't tried the extension,...

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...

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...

Jeff Moden (1/13/2009)

---

Oooohhhh.... I might be in trouble... I've got buckets full of things...

Joe

Please post the results of the following two queries:

SELECT TOP 5 * FROM dbo.DECleared

SELECT TOP 5 * FROM dbo.SomaticMCCleared

Cheers

ChrisM

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,...

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...

Hey Phil, you might want to post this in...

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...

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...

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...

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...

Good try Gary - but TimClosestatus comes from a table...

Nicholas, can you please post the exact query that you are using to get the data from UserStats which shows these figures?

Cheers

ChrisM

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...