It is a good reminder that no matter how simple or complicated anything gets, don't forget the basics. A comment is about as basic as you can get and...

Jeff Moden (9/23/2013)

---

dwain.c (9/23/2013)

---

Thank goodness for that. Someone has to keep us ol' submarine sailors from having too much fun. ...

Contempt

Abuse

Greg Edwards-268690 (9/20/2013)

---

Ed Wagner (9/20/2013)

---

jasona.work (9/20/2013)

---

On an unrelated note, so much fun working for government...

When said govm't seems heck-bent on going into shutdown, potentially leaving one payless for who knows...

Yeah, but government...

Spending

I've seen this very occasionally when I've left SSMS open too long. I rarely close it, so every so often it lets me know I should close it once...

Using the KILL command requires ALTER ANY CONNECTION. http://technet.microsoft.com/en-us/library/ms173730%28v=sql.100%29.aspx

Executing a procedure requires access to the database containing the procedure, EXECUTE on the procedure and whatever permissions the procedure code...

To sort your output, use an ORDER BY clause. I believe your column is checktime.

Koen is exactly right - we will need the basics in a reproducible form to have any chance of addressing the problem.

This looks like it's for a time and attendance...

Corruption

This should give you what you're after.

with cte as (

select c.customername, o.ordernumber, o.orderdate, row_number() over (partition by c.customername order by orderdate desc) rownum

from customer...

Good question, Ron. It really made me look at the square brackets and field names and think it through before answering.

bryan van ritter (9/17/2013)

---

Hi,

i am trying to convert a nvarchar column to a decimal value.

the nvarchar column has empty records as well as NULL values.

now when i try...