This is how I would write the original query:

DECLARE @HomeID INT

SET @HomeID = 2

SELECT utbHome.*, finfo.FileID, finfo.Name as 'FileName'

FROM utbHome

LEFT JOIN utbAmenities

ON utbHome.HomeID = utbAmenities.HomeID

LEFT JOIN

(SELECT HomeID,...

I'm assuming what you mean is a text file with rows and columns of data in it. Is that correct? (Some examples would be comma-delimited data, or fixed-width...

Is there a date or other sequence you can use for ordering this data? If so, then it becomes a relatively easy task for a running total calculation.

It would be easy enough to set up a proc that did something like "select 1 from database.dbo.table" for each database on your server. Have it send an e-mail...

Well, I have two choices for entering the building, the front door, or the other front door. Either way, all I usually get on the way to my desk...

For anyone doing either role, I'd say the zeroeth skill is the ability to wander around in Management Studio/QA+EM, without getting lost.

For an admin, I'd say the first skill is...

One of the major complaints I get from people on a relatively regular basis, is that I'm "in The Zone" too far and too often.

Any time I find something strongly...

Very cool. I wasn't aware of the Any/Some/All operators in SQL. Didn't even know they existed. Learned something from this one.

Glad I could help.

;with Alloys (A) as

(select alloy

from dbo.BOM

where material = 'xyz')

select Alloy, Material

from dbo.BOM

inner join Alloys

on alloy = a

That's SQL 2005. If you need an SQL 2000 version, move the Alloys...

If it were T-SQL, this part:

Select distinct folderno from FOLDERS where CLIENTPONO=?nCLIENTPO?

Would be more like:

Select distinct folderno from FOLDERS where CLIENTPONO like '%' + nCLIENTPO + '%'

No clue if that...

Jeff, he's not looking to parse out the whole string. Just grab the second word, and everything else.

String parser was my first thought too, but then I read it...

First, why update the "value" column? It's already equal to the thing you're updating it to.

Second, you have variables in the proc with different names than when you declared...

Jeff Moden (6/19/2008)

---

Honest to goodness... folks keep posting what they think is a solution to a problem instead of posting the actual problem. This particular one is RBAR on...

Indianrock (6/19/2008)

---

From my earlier post:"Tlog is doing nothing as far as I can see -- apparently that's because there is no full backup and thus no possibility of tlog...