One possible solution ...

SELECT

AVG(dbo.fn_Business_Days_Between_Dates(dbo.GetLocalDateTimeFunc(FM.OpenedDate),dbo.GetLocalDateTimeFunc(FA.receiveddate))*1.0)

🙂

Whats are the details for that parameter? Default value, available values, etc...

You might look up SUMIF in BOL

Read the post in my signature on improving your answers please.

But for now....

DECLARE @testData TABLE

([Year] INT

,Cost MONEY

,Price MONEY)

INSERT...

You're on the right track. Just pivot in two queries and join together.

GSquared (2/6/2012)

---

Artificial status hierarchies are just that, artificial.

A Senior DBA will often be better paid than his manager is, so "promotion" becomes simply a change in role.

The list you gave...

It is indeed a matter or personal preference, but consider the results of the [text] field when queried directly. I also think this affects the way results are displayed in...

A recent article explains one approach that can be found here[/url].

Lowell (2/3/2012)

---

a related post from long ago implies the bar code font had to be installed on the client?

that part i'm not sure, but Gianluca and i slapped together an...

For simple (Code 39) barcodes, you can use a free font. It must be installed on the Report Server itself if I remember correctly.

You can find it here[/url]

This site's owner/sponser has a great set of tools. One of which is perfect for this task.

SQL Data Compare[/url]

They're even nice enough to let you use the full version for...

I believe you're looking for a running total. If so, Mr. Jeff Moden has a wonderful article explaining the process. It can be found --> here[/url]. <-- Enjoy! 😀

Are both databases on the same server?

Yes: Right click on one of the DB's in SSMS > New Query

- Test

- Test

- Test

- Run with COMMIT

No: Need to add servername...

ryetimothy (1/27/2012)

---

A couple of questions:

Does the code depend on the maximum value of the primary key in the Master database being larger than the maximum value in the data entry...

OK, here you go.

PLEASE ......

Read the code and try to understand it 100% before you run it.

Run in a TEST environment if you have one.

Run a full backup before hand...