Have you checked these?

It sounds like something's interfering with file access permissions. ...

It is correct, but Money is a field of four decimal places. It's working as expected.

Wrap the result with a CONVERT( DECIMAL (19,2), <function here>) to go to two...

Manjeshwar,

I've used a form of the serial update here which should cure your pain on this specific instance. If you want the 'full rules' to keep you safe from...

I think I'm confusing myself.

Here's my function checks so we all understand what the heck I'm talking about as I ramble on a bit here:

DECLARE @testDate DATETIME

SET @testDate = GETDATE()

--PRINT...

After this where clause in the cte...

WHERE

-- First, we only get...

WayneS (11/11/2010)

---

Formula: DATEADD(dd,DATEDIFF(dd,-7,DateOfPurchase)/7*7,-1))

select DATENAME(weekday, 0); -- = Monday

select DATENAME(weekday, -1); -- = Sunday

select DateAdd(day, -7, 0); -- = 18991225

So, take the number of days between 18991225 (Date=-7) and the date...

Using this article as a reference:

http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/

(Note, I searched here in the search box with the following: rows to delimited string)

Please note how I adjusted your data setup. This makes...

Websense hates me. Have to check that from home.

BWAHAHAHAHAHAHAHA. Dear gods, did I just generate a meme?

Thanks Gus, you just helped me understand a little bit more of it too. 🙂

ROFL. No, I hadn't. I tend to avoid Twitter, Facebook, et al. like they...

ejbatu1 (11/11/2010)

---

Hey Craig this was very slick and complex (not sure what you did in the case statement)... thanks.

How would I add the codes in this query. ...

Yeeps. I missed that. I blame a lack of coffee. Elliot and Steve are correct (as...

CELKO (11/11/2010)

---

LOL! You even used a physical count of insertions attempts in that table! No key, no way to have a key, insanely long columns to invite garbage...

CirquedeSQLeil (11/11/2010)

---

GSquared (11/11/2010)

---

GilaMonster (11/11/2010)

---

jcrawf02 (11/11/2010)

---

Nice sig 😉 To be perfect, should start with "Yea" instead of "'lo", and have an extra thy in "Thy...

This error is the key component:

"A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name...