RBarryYoung (5/7/2009)

---

Lynn Pettis (5/7/2009)

---

The really sad part, he is probably working on an off-shore project for some sap company here in the US that thinks they have someone with a...

The really sad part, he is probably working on an off-shore project for some sap company here in the US that thinks they have someone with a Masters degree working...

RBarryYoung (5/7/2009)

---

Lynn Pettis (5/6/2009)

---

I refuse to post a link, but I really want to know what our favorite PhD candadate learned while in school for his current degrees.

I'm also curious...

karthikeyan (5/7/2009)

---

Lynn Pettis (5/6/2009)

---

karthikeyan (5/6/2009)

---

I tried the below code

DECLARE @Fixed1 decimal(8,4), @Fixed2 decimal(8,4), @Fixed3 decimal(16,8);

SET @Fixed1 = 5444.32;

SET @Fixed2 = 12121.03; <-- Problem is here. decimal(8,4) means you...

Really, and you know...

I'm sure I can help find an adapter or two if needed.

Somewhat unrelated, I would also suggest moving away from ORDER BY 1 and move to using ORDER BY column_name.

Check sp_trace_create in BOL. A problem I see withyour is options is set to 0, when it needs to be 2 for rollover.

Florian Reischl (5/7/2009)

---

Hi

I got it. You have to specify an alias for the outer table. Since your table name is "holddups" and you refer it within your sub-query you cannot...

Jamie Julius (5/7/2009)

---

I didn't mention the datetime stuff in the original post, because I wanted to simplify the question. Please note that the crux of the question is about concurrency....

Query your data for this just this IP: 10.1.8.0. See if there are duplicate services. If so, you either need to add a distinct or determine if there...

No. No reason to. Tempdb is recreated everytime SQL Server is restarted.

Glad to see that.

And what have you tried? Have you looked in BOL regarding...

mikesigsworth (5/7/2009)

---

Okay still no luck.

My query now looks something like this:

DECLARE @sql nvarchar(MAX),

@OP nvarchar(9),

@Name nvarchar(128),

@Value...