From the link Steve posted above:

--To Restore an Entire Database from a Full database backup (a Complete Restore):

RESTORE DATABASE { database_name | @database_name_var }

[ FROM...

You can probably accomplish this using a self-join to your table.

It's tough to say much more than that without seeing the data with which you are working.

If you...

Which version of Crystal Reports do you have?

There are several problems with building your own DBA. I've named a few below.

- You need at least two people

- You open your HR department up to harassment lawsuits

-...

Yes.

http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(BULK_INSERT_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(MISCELLANEOUSFILESPROJECT);k(DevLang-TSQL)&rd=true

Jeff Moden (7/31/2014)

---

Doug J. (7/31/2014)

---

Jeff-

This:

Steve Jones - SSC Editor (7/31/2014)

---

Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about me staring at him...

Jeff-

This:

Steve Jones - SSC Editor (7/31/2014)

---

Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about me staring at him from the login banner...

My normal response: "I convert coffee into software."

To paraphrase what Sean has already said, please provide CREATE TABLE scripts for all of the relevant tables, INSERT Statements to populate those tables with test data, and and example...

While you're at it, why don't you go ahead and post the query and definitions for the relevant tables here? I'd be willing to bet that you could get...

One of those days?

Eirikur Eiriksson (4/9/2014)

---

According to my findings (observed behavior) , using the minus "-" bypasses (for the lack of better word) the logical operator, select * from table where x >-...

Interesting question. Try putting together a CASE statement using the ROUND() function. Something like this:

declare @num numeric(10, 8) = 83.00381433 ;

SELECT CASE

WHEN round(@num, 5) - @Num...

robert.diley (2/26/2014)

---

How odd. I actually tried running this (copy/pasted the code) and got the following:

(1 row(s) affected)

Msg 8134, Level 16, State 1, Procedure TestProc, Line 6

Divide by zero error encountered.

No...