bugg (11/14/2012)

---

capnhector (11/14/2012)

---

We perform a nightly backup and restore to our standby server. the way we answered the "How long till i move it?" was to set up the...

We perform a nightly backup and restore to our standby server. the way we answered the "How long till i move it?" was to set up the backup and...

You need to convert the numeric value to a text value. http://msdn.microsoft.com/en-us/library/ms187928.aspx Once all the data is strings you can concat to your hearts content.

User permissions are stored in the database. If i take a backup of MyDatabase and restore it onto a different server all the permissions are going to be the...

Duplicate post see here http://www.sqlservercentral.com/Forums/Topic1384732-391-1.aspx

This works but some of the others on the forum may be able to make it better.

Here is how the code works: First we declare and set our start...

i have a question about #Working_Pattern. This table holds the days of the week an employee works with the start date being the date the new schedule became effective?

I...

I just wrote up a similar course and could not find any sample data to my liking. I started with Adventureworks but due to the multiple schema's decided against...

First thing we need to do is find the first of next month with the following:

DATEADD(MM,DATEDIFF(MM,0,GETDATE()) + 1,0)

Next we can just subtract a day to get the last day of...

glad to help. its one of those things that some days you just cant find on google untill you post the question. then the next search you run...

You need to change your case statement a little to be like this "CASE WHEN ABS (DATEDIFF(day, admitdate, dischargedate)) BETWEEN 0 AND 7 THEN 1"

A small optimization that may speed...

For the physical server you can run "net statistics server" and take a look at the time.

Nice DDL Trigger on the create database however you can avoid the cross join to sys.databases by using the following query:

SELECT DATEADD(DD,N,dateadd(dd, 0, DATEDIFF(dd, 0, getdate()))) AS backupdate,

...

Ok here is the answer to the actual question. What we have is the classic i need all the columns but only with the MAX(Date). There are 2...

When using a VARCHAR() or CHAR() column the MAX() on a field returns the highest letter (I think its based on the ASCII CHAR() value but i could be wrong,...