ColdCoffee (9/21/2010)

---

Ah , never CM.. i always enjoy reading through your innovative ideas of solving questions, makes me learn a lot.. i...

LOL but do you understand her? 😛

/*

Exampel table looks like this:

*/

DROP TABLE #Exampel

CREATE TABLE #Exampel ([id] INT, [from] NUMERIC(6,2), [to] NUMERIC(6,2), [procent] NUMERIC(6,2))

INSERT INTO #Exampel (id, [from], [to], procent)

SELECT 1, 0.00, 20.00, 7.90 UNION ALL

SELECT 2,...

No problem Johan, here's a modified query to return the correct age.

-- solution

DECLARE @TodayDate DATE

SET @TodayDate = GETDATE() --...

A small modification and your query will run:

select PerName, PerBirthDate,

CASE

WHEN DateDiff(yy,PerBirthDate,GETDATE()) > 60 THEN 60

WHEN DateDiff(yy,PerBirthDate,GETDATE()) > 55 THEN 60

WHEN DateDiff(yy,PerBirthDate,GETDATE()) > 50 THEN 50

WHEN DateDiff(yy,PerBirthDate,GETDATE()) > 45...

Not at all Johan, if you're unsure about anything, just...

Use CASE:

-- make some sample data to test the solution

DROP TABLE #Personal

CREATE TABLE #Personal (

PerID INT IDENTITY(1,1),

PerName varchar (50),

PerBirthDate datetime,

PerSex char(1))

INSERT INTO #Personal (PerName, PerBirthDate, PerSex)

SELECT 'A...

John Rowan (9/20/2010)

---

CirquedeSQLeil (9/20/2010)

---

John Rowan (9/20/2010)

---

Pheasant death....had a great hunt this weekend with a bunch of good friends. Shot a bunch of birds, clays, high-powers, and blew some stuff...

What exactly do you mean, "in a list, but not in a table"?...

Saravanan_tvr (9/20/2010)

---

Hi All,

Problem 1:

I have a table with 15 k rows of datam but when i upate the columns i got the below error,

Msg 511, Level 16, State 1, Line...

keith-710920 (9/20/2010)

---

Perhaps I'm missing something here, but no where in Dave's original query did he mention anything about parsing folder structures, parsing multiple strings or anything like that. He simply...

Brandie Tarvin (9/20/2010)

---

Yes. @=)

Our cat got shaved for surgery, the entire torso. Legs, tail, and head still have fur. Hence: Poodle-cat.

It's very fun....

Nicking ColdCoffee's setup:

-- Declare a temp table to hold the file names inside a folder

DECLARE @FolderAndFiles TABLE

(

Sl_Number INT IDENTITY(1,1)...

Something like this?

(SELECT CASE WHEN min(PriorityID) = 16 THEN 0 ELSE min(PriorityID) END

FROM dbo.ServiceOrdersJobs...

Requirements

SELECT TOP 1 Convalesce = COALESCE(Sleep, Food, Drink)

FROM (

SELECT '12 hours' AS Sleep, CAST(NULL AS VARCHAR(15)) AS Food, CAST(NULL AS VARCHAR(15)) AS Drink UNION ALL

SELECT CAST(NULL AS VARCHAR(15)) AS...