There's a line in the CompressName function that tests the value of @c. I think it may not have come across in the forum correctly, because it checks if...

You're right. That's what I get for not testing the way I should.

Replace this line:

'ID', ''), ',') as ID

with:

'ID', ''), ',', '') as ID

Just tested that part, and it...

The company I currently work for had a heat-related massive downtime issue a month or so before I started here. From what I understand, the AC failed, and alerts...

You can't exec inside a UDF. No dynamic SQL in them.

What's the end result you're trying to achieve?

IF (select * from [tpqaplantsql\plantdb].LoggerReport.dbo.logger2)=0

Should that have "count" in the select?

In Management Studio, you should be able to pop open the Activity Monitor, and see what connections are active and all that. That might be a good place to...

Lynn Pettis (2/20/2009)

---

Okay, don't call me Certifiable, call me Cynical.

Why are we getting such basic questions from someone with a "Master" in Computer Application, has been apparently working with SQL...

It's just an incrementing hex number.

I just created three temp tables from one connection and four from another. Then I selected the last 12 characters of each temp table's...

It really depends on what you'll be using the data for, and how you'll be querying it. Since that's what indexes are for, it's necessary to know that before...

Nope.

RJ (2/19/2009)

---

1. first place the database design was done to have these fields, at this moment we are not in a position to re-evaluate it hence I'm trying to find...

Steve Jones - Editor (2/19/2009)

---

I do think there's value for the cameras being there, even if they're not watched, or even hooked up. There's a bit of a deterrent, and...

Posting XML in the forum directly doesn't work.

Attach it as a text file.

I'm not exactly an expert on XQuery, but I might be able to help.

First, though, does the XML that needs to be updated, need to be updated, or generated?

It would...

paul.starr (2/19/2009)

---

ok what if five records are inserted, and i have another table customer value that reads this customertest table for the new records in the (custid) field and increments...