A.J. Wilbur (7/24/2012)

---

This is a forum for help, not for people to do...

Remember that bit is not boolean, so you have to compare it to 1.

e.g. bit_field = 1

+1

You're probably right and probably not.

As I understand, he's trying to summarize data from an already existing sales table. If...

The easiest way is:

IF @Condition = 'Something'

SELECT *

FROM MyTable

WHERE myfield = @Variable

ELSE

SELECT *

...

tbailey 19088 (7/19/2012)

---

The given answer is absolutely incorrect. http://msdn.microsoft.com/en-us/library/ms189281.aspx states explicitly how to revert to a selected snapshot if multiple snapshots exist.

1. Select the snapshot you wish to restore.

2. Drop...

coldfusion244 (7/19/2012)

---

Luis Cazares (7/19/2012)

---

Why is everyone so upset about the answer? It's clear that the question is if you can restore the database without deleting the other snapshots. Otherwise you...

Is this a reponse from a six year old?

After reading Lynn contributions on...

Ivan,

Si batallas con el inglés te puedo ayudar a traducir, aunque no puedo ayudarte con ese error.

Everyone else,

I can help with translation, but I'm not sure what's the error.

Translation for...

Why is everyone so upset about the answer? It's clear that the question is if you can restore the database without deleting the other snapshots. Otherwise you wouldn't have multiple...

There are plenty of ways, the...

You could solve this with Dynamic code or by writing different queries trough a condition (IF...ELSE...).

I'm not sure if that is what you need.

You must do the sum before you cast your values.

SELECT id,

nm,

CAST(REPLICATE(' ',16-LEN(SUM(AMT*1000))) + CONVERT(varchar(32),SUM(AMT*1000))...

Taken from BOL http://msdn.microsoft.com/en-us/library/ms188029.aspx

"You cannot create new_table on a remote server..."

Have you tried this?

select top 5 *

into [this.that].dbo.ztb_test

from zt_sysjobs