Viewing 15 posts - 121 through 135 (of 1,183 total)
One possible solution ...
SELECT
AVG(dbo.fn_Business_Days_Between_Dates(dbo.GetLocalDateTimeFunc(FM.OpenedDate),dbo.GetLocalDateTimeFunc(FA.receiveddate))*1.0)
🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 24, 2012 at 9:03 am
Whats are the details for that parameter? Default value, available values, etc...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 21, 2012 at 6:43 am
You might look up SUMIF in BOL
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 15, 2012 at 12:50 pm
Read the post in my signature on improving your answers please.
But for now....
DECLARE @testData TABLE
([Year] INT
,Cost MONEY
,Price MONEY)
INSERT...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 6, 2012 at 1:33 pm
You're on the right track. Just pivot in two queries and join together.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 6, 2012 at 1:14 pm
GSquared (2/6/2012)
A Senior DBA will often be better paid than his manager is, so "promotion" becomes simply a change in role.
The list you gave...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 6, 2012 at 11:43 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 6, 2012 at 10:35 am
A recent article explains one approach that can be found here[/url].
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 6, 2012 at 9:24 am
Lowell (2/3/2012)
that part i'm not sure, but Gianluca and i slapped together an...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 3, 2012 at 9:24 am
For simple (Code 39) barcodes, you can use a free font. It must be installed on the Report Server itself if I remember correctly.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 3, 2012 at 9:09 am
This site's owner/sponser has a great set of tools. One of which is perfect for this task.
They're even nice enough to let you use the full version for...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 3, 2012 at 7:07 am
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! 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 3, 2012 at 7:01 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 27, 2012 at 8:09 pm
ryetimothy (1/27/2012)
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 27, 2012 at 9:54 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 27, 2012 at 8:51 am
Viewing 15 posts - 121 through 135 (of 1,183 total)