I agree with Gail. If you go this way, call it via an asyncronous call using Service Broker. This way you know that the users update (insert/update/delete) is...

Just remember, he also explained the difference. The chanllenged children have been taught. The "bad" posters, however, are supposedly responsible adults.

It is a problem in the documentation only, not the function.

Write your own CLR procedure to send the UDP message and then use service broker to implement it. That way you can use a trigger to send a message...

tosscrosby (1/14/2009)

---

Lynn Pettis (1/14/2009)

---

Nothing wrong with trying to fix a problem yourself. Some of us still do that as it also reinforces solutions. I learn better by doing...

I guess some people just want immediate gratification and if...

I'll throw another idea out. You said this data is cached in the application, perhaps the application should be rewritten to use query notification so that when a change...

rodjkidd (1/14/2009)I've been a member for some time, only posted a couple of questions, mainly due to the fact that by using the search faculty (yep there is one!) I've...

Jeff,

If I start slipping toward the dark side let me know. I really don't want to end up on the other end of your rapid fire pork thrower! ...

Two things I am wondering about.

The first, why do you have a row defined with 1000 nvarchar(max) columns?

The second, maybe I just can't find it, but I could not find...

David Reed (1/13/2009)

---

Steve Jones - Editor (1/13/2009)

---

OK, I'm really confused now. I was going to change the picture to a new shirt, but most people like the shirt.

Hmmmmm, I...

gcopeland (1/12/2009)

You have already stated you judge a persons technical expertise on thier appearance, these people would probably not pass your initial screening, even if they were the next Steve...

Chris (1/12/2009)

---

Lynn.. I have posted sample data this is the way i need it...

create table #temp2

(

crdate datetime,

Ban int

)

insert into #temp2 values ( '01/10/2009',1432)

insert into #temp2 values ( '01/11/2009',4134)

insert into #temp2...

First, you just changed your requirements from your initial post. Nothing there indicated a pivot. As the more data is added for additional days, does the number of...

I really think you are missing the point. No one is dismissing that you need to be properly attired for your interview, well-groomed, clean, etc. But this isn't...