SQLKnowItAll (4/4/2012)

---

Remember that a NULL is not "stored" per se. It is the lack of a value. As far as I can tell, a column uses a bit...

Here's my attempt, probably can be shortened or better versions posted by the experts.

select row, studentid, revision_cycle, grade_assigned, reason

from

(

select row_number() over (partition by studentid order by revision_cycle desc) row,

studentid, grade_assigned,...

Interesting problem! I've never run into that, and wonder if you could just either select around it???

Like select all columns by name from the openquery with criteria inside the...

you're welcome and good luck!

The best answer I could find was using a script of some sort to list files and directories that a windows user account has access to. This is one example...

user interface is hard! I like the idea of a "force" like keyword being required when bypassing all the safety checks, but its probably best to research combinations of keywords...

pharrell (2/7/2012)

---

To preface this question, I should give a quick overview of my current situation.

I have recently taken over the DBA position in place of our previous DBA/Lead Developer...

Could you try:

iif(filed=Empty , "?" ,filed)

Just curious, maybe " " isn't really in that field after all!

(Its worth noting that when I tried the expression for a column called "note",...

Sorry for my off topic post, and I will...

reefshark (3/28/2012)

---

Hello!

I have a new server that I have installed SQL Server 2008 R2 SP1 on. I created a single user database on it and ran a script (provided...

GilaMonster (3/28/2012)

---

patrickmcginnis59 (3/28/2012)

---

Ninja's_RGR'us (11/23/2011)

---

The most prolific poster post because it's the RIGHT thing to do. Not to get anything of...

Lynn Pettis (3/28/2012)

---

patrickmcginnis59 (3/28/2012)

---

GilaMonster (3/28/2012)

---

patrickmcginnis59 (3/28/2012)

---

Ninja's_RGR'us (11/23/2011)

---

The most prolific poster post because it's the RIGHT thing to do. Not to...

GilaMonster (3/28/2012)

---

patrickmcginnis59 (3/28/2012)

---

Ninja's_RGR'us (11/23/2011)

---

The most prolific poster post because it's the RIGHT thing to do. Not to get anything of...

Lynn Pettis (3/28/2012)

---

patrickmcginnis59 (3/28/2012)

---

Ninja's_RGR'us (11/23/2011)

---

The most prolific poster post because it's the RIGHT thing to do. Not to get anything...

daniel 40017 (3/28/2012)

---

The issue you presented regards an insert operation.

a query is a different thing - one might think you are referring to distributed query on multiple servers for...