Fatal Exception Error (3/5/2010)

---

Chad Crawford (3/4/2010)

---

BTW - I thought of a few more assumptions that should have been included:

--Assume you are in the database containing tblUsers

--Assume you have been...

Chris Houghton (3/3/2010)

---

The complete results from the tblusers (lets assume 2 x users) are cross joined against the results from the CTE (which only selects 1 row from tblusers...

I have no problem with the question - I think the assumptions that needed to be made although not clear, were reasonable.

I do have a question about the answer though,...

Sorry Barry. 🙁

BTW - Jason, did you know that our resumes cross? We were at UBS at the same time, but I think in different offices so we probably...

RBarryYoung (2/16/2010)

---

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in the thread above, and...

Ahhh.... that might explain what looked like a contradiction. Maybe it is the GUI that accepts blank/zero but the XML underneath is always zero. That would make sense....

As Scooby would say, "Ruh rhow!" - there seems to be a conflict in the documentation. Timeout Element (SQL 2000) states:

The value for the Timeout element must be between...

I got it right, but for the wrong reason. Is it my imagination or is the UNION ALL in the wrong spot? Shouldn't it go between the SELECTs?

Chad

Maybe we could turn this into an April Fool question of the day.

Which of these methods can be used to restore a damaged database to the state it was before...

Try the asterisk (*). I'm using *.txt and it works, perhaps it will work for sqlserver_*.xls as well.

Chad

EDIT: Whooops - reread your post and I see that *...

sjimmo (1/29/2010)

---

Chad - You got me thinking.

I opened an OSQL session in DOS to a SS2K5 box, and running the code as is got the 0,1 answer.

BUT - how many...

Could the difference between 0,1 and 1,1 be due to the settings in the particular client you are using to connect? As one poster noticed, SSMS sends a whole...

I don't want to blame ColdFusion, especially since it kept me employed for a number of years, but it looks like there are some cases where it doesn't escape a...

I tried to write a query that was similar to yours, but would work on my system: ;WITHvs_data AS (

SELECTREPLACE( name,' ',') AS field_abbr

, id

, xtype

FROMsysobjects

)

SELECT* from vs_data

PIVOT (

MAX(id)

FOR xtype...

If you execute the query that was returned (without fixing the quote issue) do you get the same incorrect syntax error? What if you put the quote back in,...