Fragmentation number

[samir]

Dear sir,
I have Number
@a Decimal (18,5) = 27.2500
I need Result tow Column

Column 1 = 27
Column 2 = 25

[harishgg1]

@samir

@a Decimal (18,5) = 27.2500

Hi

Please see if this works for you

SQL

-- Integer Part
select floor(@a)

-- Decimal Part
select PARSENAME(@a,1)

[ScottPletcher]

SELECT [column 1] = FLOOR(@a),
[column 2] = @a - FLOOR(@a)