Viewing 10 posts - 1 through 10 (of 10 total)
The code below might help:
CREATE TABLE #Temp
(
[Column A] VARCHAR(10),
[Column B] VARCHAR(5),
[Column C] VARCHAR(10)
)
INSERT INTO #Temp VALUES
('XXXXXXXXXX','64856','Test001'),
('XXXXXXXXXX','64857','Test002')
SELECT [Column A] AS ColumnA
,[Column B] AS ColumnB
...
October 5, 2015 at 8:27 am
elham_azizi_62 (10/5/2015)
hello J Livingston.My output have more than 1 column and column's names are:
PersonelNumber,FirstName,LastName,BaseSalary,BaseSalaryAmount,ExtraSalary,ExtraSalaryAmount,SpecialSalary,SpecialSalaryAmount.
The script I placed in my post produce this results:
Personelnumber Name LastName ...
October 5, 2015 at 4:27 am
Try the code below and let me know if it will serve the same purpose as your desired output. Please replace the table name with your own.
[font="Comic Sans MS"]SELECT [Personelnumber]
...
October 1, 2015 at 4:22 am
Try the code below, always try to keep your code simple:
WHERE YEAR(roofyearbuilt) - 1991 > 17
October 1, 2015 at 2:38 am
DECLARE @bestdatum DATETIME
SET @bestdatum = '2015-09-21 15:49:28'
SELECT YEAR(@bestdatum) Year
,MONTH(@bestdatum) Month
,DAY(@bestdatum) Day
-------------------------------------------------------------------------------...
October 1, 2015 at 2:29 am
WHERE UpdateDate >= CONVERT(DATE, DATEADD(DAY, - DAY(GETDATE()) + 1, GETDATE()))
October 1, 2015 at 2:05 am
SELECT CONVERT(DATE, DATEADD(DAY, - DAY(GETDATE()) + 1, GETDATE()))
October 1, 2015 at 1:59 am
Why don't you use COLLATE DATABASE_DEFAULT on fields causing a the problem?
September 25, 2015 at 2:14 am
declare @temptbl table (ID bigint)
insert into @temptbl(ID)
values(99999999999999999)
select *
from @temptbl
try the script above. I just used a previously posted script and changed on data type only.
September 22, 2015 at 2:01 am
Why don't you use the Data Conversion transformation in SSIS?
September 15, 2015 at 6:57 am
Viewing 10 posts - 1 through 10 (of 10 total)