Hi Jeff,

I might consider using something like this approach

CREATE TABLE [dbo].[Months](

[MonthName] [nvarchar](10) NOT NULL,

[MonthCalendarSequence] [int] NOT NULL,

[MonthFinancialSequance] [int] NOT NULL

) ON [PRIMARY]

Insert into Months Values ('January',1,10)

Insert into Months Values ('February',2,11)

Insert...

weitzera and scott,

Thank you for the explanations, I have a much better understanding of "float" approximation issues now

Yip, worrying indeed.

Lets hope sanity prevails and they leave this feature alone

My Local BoL 2005 quote follows

"Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in the next release of SQL Server. Avoid using SET ROWCOUNT together with DELETE,...

Nice question, made me think about what "approximate" means.

Is always true to say, as in the explanation, that because the value of float variable is approximate, it can never =...

I guess that you're talking about a SQLServer-supplied auto-increment IDENTITY column?

If so, would now be a good time to discover the real key of the referenced table?

Otherwise, make sure you...

Hi,

You might like to consider using Euclid's Algorithm to find the Highest Common Factor (Greatest Common Divisor)

CREATE FUNCTION CalculateRatio(@numerator int, @denominator int)

RETURNS nvarchar(max)

AS

BEGIN

declare @ratio nvarchar(max)

declare @greatestcommondivisor int

declare @x...

This might also be a good place to start.

DECLARE @msg nvarchar(max)

set @msg = 'Merged Facility Id:6644- Patient Id:072505 with Facility Id:6645- Patient Id: 072506'

Select replace(replace(replace(replace(@msg, ' Patient Id: ', ','),...

Thanks for the perspective

Cute problem. Not really a real world situation though, a department will not always have a manager and being a manager is a role of an employee

does it help if you supply a port number (1414 or something) ?

Agreed, those extra little enhancements are really useful in most situations, and customizable as well.

Different countries having different public holidays is a good example.

One-time Setup and Simple Selects were the...

Not actually my article, but one I found.

The idea behind it is to incur a single , perhaps large, set-up cost and from then on just use the set-based capabilites...

Is there a reason why this would be better than selecting rows from a Calendar table?

Have a look at:

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html