Just don't get any glass in your glass! (Cracked, a bottle)...

TGIF

TGIF

Sean Lange (5/11/2012)

---

Lynn if you keep providing answers there is no incentive for the posters to provide the details for you. They will just learn that you will eventually do...

Sean Lange (5/11/2012)

---

This pretty simple but I am rather swamped at the moment. If you post ddl and insert statements I can knock this out in a couple minutes. I...

sqluser_8119 (5/11/2012)

---

I have this in one table (columns are Patient#, Name, EntryDate)

123456789, Jane Doe, 4/12/12

123456789, Jane Doe, 4/15/12

555666888, Alice Doe, 3/13/12

555666888, AliceDoe, 3/20/12

What t-sql can I use to pull the...

Just once it would be nice if someone would answer the questions they are asked.

DECLARE @Zip TABLE(ZipCode CHAR(5));

INSERT INTO @Zip (ZipCode)

SELECT '90000' UNION ALL

SELECT '90010' UNION ALL

SELECT '90020' UNION ALL

SELECT...

Welsh Corgi (5/11/2012)

---

At the bottom of the screen there is yellow bar that includes sections for Query Completed with Errors and a warning symbol followed by the Server Name 10.1...

Usually means as a whole, something is wrong. Can't really tell since we can't see what you see.

You seem to be demanding something for nothing. Don't you think it appropriate that you answer the questions asked? I can give you some code, but I'd like...

TravisDBA (5/11/2012)

---

Lynn Pettis (5/11/2012)

---

TravisDBA (5/11/2012)

---

If I didn't take dead time at work or my own time in the evenings (yes, I do that too), I wouldn't know what...

TravisDBA (5/11/2012)

---

When...

Sean Lange (5/11/2012)

---

Matt Miller (#4) (5/11/2012)

---

Lynn Pettis (5/11/2012)

---

Matt Miller (#4) (5/11/2012)

---

If you're dealing with messaging and responses - you're really in the realm of talking about a SQL Service Broker...

TravisDBA (5/11/2012)

---

Megistal (5/11/2012)

---

Easy question, none (no hour per whatever period) are officially allowed.

You are granted to read something if it's directly related to the work being done right now (not...

First two are Windows Server accounts, don't delete them.

The next three are created as part of the SQL Server 2005 install, again, don't delete them.

I'll stand corrected...