can you post sample data and the table DDL and an exlination of what you are trying to achieve. right now i see a case statement and have no...

mohammed moinudheen (4/4/2012)

---

There is this server where a user is having only db_reader access and execute permissions only for specific procedures in a database. However, he has been able to...

please continue discussion in the original topic so your question does not get fragmented accross multiple threads.

duplicate post discussion is here

http://www.sqlservercentral.com/Forums/Topic1277841-391-1.aspx

if what jeff posted is not what you were looking for, here is the link to the microsoft download of the northwind and pubs sample databases.

http://www.microsoft.com/download/en/details.aspx?id=23654

just talked to my girlfriend she left the truckstop that got hit just down the road from the schneider yard about 20 min before the tornado came through. to...

Lynn Pettis (4/3/2012)

---

capn.hector (4/3/2012)

---

lukebaker (4/3/2012)

---

SOLVED!!

I have reformated the dates in my table and used the below query and it worked 🙂

SELECT *

FROM v_stafftrainingDetails

WHERE (expiry_Date...

Lynn Pettis (4/3/2012)

---

Evil Kraig F (4/3/2012)

---

Lynn Pettis (4/3/2012)

---

Not you either, but I...

pixelwiz (4/3/2012)

---

Humm, I wish I could do it in 3 queries. So far I have 8 unique ones and then 4 more that are repeated in loops. The...

lukebaker (4/3/2012)

---

SOLVED!!

I have reformated the dates in my table and used the below query and it worked 🙂

SELECT *

FROM v_stafftrainingDetails

WHERE (expiry_Date >= DATEADD(dd, DATEDIFF(dd,...

No problem

original / thread with replies is at http://www.sqlservercentral.com/Forums/Topic1277637-391-1.aspx

cant be me, i...

Stefan Krzywicki (4/3/2012)

---

GSquared (4/3/2012)

---

capn.hector (4/3/2012)

---

GSquared (4/3/2012)

---

Brandie Tarvin (4/3/2012)

---

Isn't that illegal?

I'm sure there's some sort of law against that... Or is the law for it? I...

GilaMonster (4/3/2012)

---

There are tools that claim to be able to defrag files while open. Some even can do what they claim. However if you use one and it's not written...

that is exactly what the auto growth does, when it hits the limit...