Actually, it isn't. Take a closer look, it is actually subtracting 1 for the day or month entered in the table.

LoosinMaMind (9/12/2012)

---

Hi

I have been given a new system to work on and the dates are held in three seperate columns


day number ;ie 1,2,3,4 etc
month number ; ie 9,10,11 etc
year; 2011, 2012 etc

The format of these is an INT

I need to somehow concatinate the 3 into a workable date format in a SELECT statement

Any help would be greatly appreciated.

Thanks in advance

SAMPLE DATA AND EXPECTED RESULTS SCRIPT BELOW.

CREATE TABLE PS_TestForOnline
(
DAY_ INT,
MONTH_ INT,
YEAR_ INT
);

INSERT INTO PS_TestForOnline
VALUES(1,1,2012);
INSERT INTO PS_TestForOnline
VALUES(1,2,2012);
INSERT INTO PS_TestForOnline
VALUES(1,3,2012);


SELECT * FROM PS_TestForOnline


--&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

--EXPECTED RESULTS

SELECT

'1-1-2012' DATE_EXAMPLE_1, '1-2-2012' DATE_EXAMPLE_2, '1-3-2012' DATE_EXAMPLE_3 -- NEED THESE TO BE IN DATE FORMAT DD-MM-YYYY


--&&&&&&&&&&&&&&&&&&&&&&

DROP TABLE PS_TestForOnline

Jeff Moden (9/12/2012)Just pray people named their columns for inserts or BOOM!

CREATE TABLE test (
	ID int,
	NAME nvarchar(50),
	DESCR AS (CONVERT(nvarchar(20), ID) + ' - ' + NAME )
	)


INSERT INTO test
SELECT 1, 'Number One'

SELECT * FROM Test