Lowell (5/23/2013)

---

I have a certain fondness for doing solutions in TSQL, or at least be centered around TSQL, regardless of whether it's the right tool for the job or...

I would make one more change, in the WHERE clause:

SELECT

Category,

COUNT(Category) AS CatCount,

DATENAME(month, OpenDate) AS mopendate

FROM

...

I would like to point out that this function could be a performance killer if used with large data sets. There are two ways to fix this.

One, instead of...

Steve Jones - SSC Editor (5/23/2013)

---

Not that any of you care, but it's the last day of school.

I think I may be more happy than the kids to sleep in...

SQLSACT (5/23/2013)

---

Yes it will

Principal, Mirror and Witness constantly Ping each other - The Partner Timeout is how long after NOT receiving a reply must it perform an automatic failover. I...

It is also looking like open_date is stored in seconds since 1/1/1970, is this correct? That would also change my solution.

GOODS (5/23/2013)

---

Hi Guys,

I'm designing a report in SSRS,I need to pull that from DB from previous Friday till the end of the current Friday.

this is what I have on WHERE...

Sergiy (5/22/2013)

---

Lynn Pettis (5/22/2013)

---

One thing I learned in a Marketing class many years ago. If someone has a good experience with a product or company they tell 3 people....

Sergiy (5/22/2013)

---

By all means try to avoid datetime-char-datetime conversions.

Pretty efficient performance killer.

Develop a habit to use this...

patrickmcginnis59 10839 (5/22/2013)

---

Lynn Pettis (5/22/2013)

---

patrickmcginnis59 10839 (5/22/2013)

---

Lynn Pettis (5/22/2013)

---

patrickmcginnis59 10839 (5/22/2013)

---

Brandie Tarvin (5/22/2013)

---

patrickmcginnis59 10839 (5/21/2013)

---

L' Eomot Inversé (5/21/2013)

---

In response to Patrick, it would have better phrased something like "There is...

Evil Kraig F (5/22/2013)

---

Lynn Pettis (5/22/2013)

---

If anyone can find it a provide the url (by clinking and pasting from the message number) I would appreciate it. I have been...

Okay, if you list 33 database names how do you expect the procedure to backup 41 databases as you...

patrickmcginnis59 10839 (5/22/2013)

---

Lynn Pettis (5/22/2013)

---

patrickmcginnis59 10839 (5/22/2013)

---

Brandie Tarvin (5/22/2013)

---

patrickmcginnis59 10839 (5/21/2013)

---

L' Eomot Inversé (5/21/2013)

---

In response to Patrick, it would have better phrased something like "There is a lot of discussion...

This:

/*This command will get all Producation databases with any recovery model*/

DECLARE getdbname CURSOR FOR

SELECT nameFROM sys.databases

Where name in ('test1','test2','test3','test4','test5','test6',test7')

will get you 7 databases: test1','test2','test3','test4','test5','test6',test7'.

If this is a "Sanitized" script it...

Funny, and when did you...