Ed Wagner (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Alvin Ramard (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

SQLRNNR (8/14/2015)

---

Maybe he...

What does SELECT SERVERPROPERTY ( 'InstanceName' ) return?

😎

Alvin Ramard (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

SQLRNNR (8/14/2015)

---

Maybe he has coded it differently...

SQLRNNR (8/14/2015)

---

Maybe he has coded it differently than you guys? ...

It is implied that if there are two occurrences of the same [Name] element then one will have the AnnualizingFactor of 2080. It is also implied that under no other...

Brandie Tarvin (8/14/2015)

---

Jack Corbett (8/14/2015)

---

But you didn't do it...

owens.rusty (8/14/2015)

---

I have a table where we have created a column that has which contains a column which is a primary key tying back to another table. The problem...

Good stuff and have a great weekend:-)

😎

Sometimes one wonders what drives the responds when one points out that the posted solutions are not optimal.

😎

drew.allen (8/14/2015)

---

First,...

Chris.Hubbard4U (8/14/2015)

---

I queried that table but...

Fast food

Quick alteration to Lynn's good solution, handles values both higher and lower than the target value

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_TEST_SET_20150814001') IS NOT NULL DROP TABLE dbo.TBL_TEST_SET_20150814001;

CREATE TABLE dbo.TBL_TEST_SET_20150814001

(

...

Alvin Ramard (8/14/2015)

---

Lynn Pettis (8/14/2015)

---

Something like this:

declare @TestTable table(

EEID int,

Name varchar(64),

AnnualizingFactor int,

PercentFullTime decimal(3,2));

insert into...

Endangered