Koen Verbeeck (5/24/2012)

---

Sean Lange (5/24/2012)

---

Koen Verbeeck (5/24/2012)

---

Sean Lange (5/24/2012)

---

Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to...

blampe (5/24/2012)

---

Thank you for your input!

SSCommitted,

There is no real correlation between the SSN and the new value ........ The purpose of this is to mask the SSN because it is...

Fly Girl (5/24/2012)

---

The Bücker is a load of fun. There is pretty much nothing practical you can do in it: it sucks for transportation (2 hrs of fuel max, little...

Koen Verbeeck (5/24/2012)

---

Sean Lange (5/24/2012)

---

Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to start answering. This helps...

SQL Kiwi (5/24/2012)

---

Yikes, no. You're thinking...

I suspect Paul will link to this article. One I keep close at hand myself.

http://www.sqlteam.com/article/datediff-function-demystified

CptCrusty1 (5/24/2012)

---

Lynn Pettis (5/24/2012)

---

Actually, you didn't eliminate the NOLOCKS hint, you just hide them in the view.

What is with the hint any way? You do know the issues with...

Lynn Pettis (5/24/2012)

---

CptCrusty1 (5/24/2012)

---

Lynn Pettis (5/24/2012)

---

Actually, you didn't eliminate the NOLOCKS hint, you just hide them in the view.

What is with the hint any way? You do know the...

tobinare (5/24/2012)

---

I'm very new to SQL Server and am programming a front end to a database using c++ and ADO. I've noticed that while submitting a SELECT query to...

You do not need a cursor to do this. Cursors are the bane of t-sql development.

If you can explain what you want for output I can help. Unfortunately so...

To understand this you first have to break it apart.

The second parameter inside...

na1774 (5/24/2012)

---

Oh yes It can be. I am sorry.

But I would like to know why a 'CREATE DATABASE' Statement cannot be a part of Transaction. At the same time what...

From the details your provided? Nope.

If you actually want some help you need to help us to help you. Take a look at...

So what really is the question here? At first is seems you need help with an insert statement, then you say something about a job.

The sql statement is pretty simple.

insert...

Then you will either need to tweak the query or explain what "not working as per rules" means.