TheSQLGuru (6/19/2014)

---

I still think it is better to stop users from creating new logins as a mechanism to stop this form of attack. Well, unless the spammers have banked...

Area 51

I'm not sure what you're trying to do here. The subject says you want to rewrite the two into one, but the first is a SELECT and the second...

And don't check the "Overwrite" checkbox unless you really mean it. I also prefer using T-SQL as suggested above. It's harder to make a mistake there than in...

Management Studio

rodjkidd (6/19/2014)

---

Greg Edwards-268690 (6/19/2014)

---

Ed Wagner (6/19/2014)

---

rodjkidd (6/19/2014)

---

So for my current gig, I'm not a production DBA.

We have a very temperamental server which is being upgraded this week.

It also has spaghetti...

Visual Basic

melanie.townsend (6/19/2014)

---

About the Spam messages which have been flooding the forums -we're aware of the problem and are working to clear the posts as quickly as possible. I know they're...

When you restore to another server, you'll have to look at your logins. Both the SQL and Windows logins have to exist on the destination server in order for...

Lynn Pettis has a page with some common date routines posted at http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/ that will help give you the syntax you're after in an efficient way without having to parse...

rodjkidd (6/19/2014)

---

So for my current gig, I'm not a production DBA.

We have a very temperamental server which is being upgraded this week.

It also has spaghetti jobs / packages. You know...

Function

Grant Fritchey (6/18/2014)

---

Evil Kraig F (6/18/2014)

---

Heh, I don't mark...

I think I understand what you're after. If I'm interpreting it correctly, it sounds like a classical gaps and islands problem. There are a multiple approaches to it....

If you want to know all about the SUBSTRING function, it's covered at http://msdn.microsoft.com/en-us/library/ms187748%28v=sql.100%29.aspx. If you have any questions about it, that's a good page to read.