If you want to keep these results as dates, try replacing 'Perpetual' with '1900-01-01' OR '9999-12-31'

You are trying to cast some values as date and others as character data in the same result column. You can't do that. I don't know what working means....

My feelings are this:

1. Merge is best for keeping data "synced" between multiple database instances when connections are an issue; i.e. Sales people on tablets that do not have a...

Merge does not make sense to me, from my understanding of the requirements, because I believe merge is best used when connections are the issue; i.e. sales reps out with...

Brandie Tarvin (4/13/2012)

---

opc.three (4/12/2012)

---

tt-615680 (4/12/2012)

---

Brandie Tarvin (4/12/2012)

---

Why does the replacement user need similar privledges? You're just shooting yourself in the foot.

Remember, least permissions needed to do the job (figuratively and...

SSRSnewbie (4/13/2012)

---

Jared,

Thank you mate, looks like some progress. I'm really happy... thank you so much for the help.

I've been using SQL for about 10 years, but hidden behind a...

Either there or Start-->Windows Update

1. Windows Update is disabled on our servers. When we are going to do the updates, we start up the service and just do the updates.

2. If the server...

Yes. We do them once a quarter unless we deem them critical.

Were you asked this question or are you observing this somewhere. If you have observed it, can you please be more specific as to how and where?

So add a new column in your query:

DECLARE @datefrom datetime

DECLARE @dateto datetime

SET @datefrom = '2012-01-01'

SET @dateto = '2012-02-01'

SELECT a.databasename, a.date, a.spaceused, b.date, b.spaceused, (b.spaceused - a.spaceused)/a.spaceused AS pct_inc_dec

FROM table1 a

INNER...

lloyd.meyer (4/12/2012)

---

Hi,

I'm looking to calculate the % increase of our databases within a selected date range.

For example, the user runs the report for date ranges 01/01/2012 to 30/01/2012, and we...

Mark Fitzgerald-331224 (4/12/2012)

---

You have not given details of tables A and B. Assuming that tables A and B have not got a unique constraint on the memberID (as you...

You added the domain user to sql server logins? If so, did you add it as windows authentication?

There must be another unique constraint on the table. Please provide DDL for the 3 tables including indexes and constraints in accordance with the directions in the article referenced...