CREATE PROCEDURE [dbo].[myProc]

@whereSql nvarchar(256)

AS

EXEC('SELECT [fields] FROM

WHERE ' + @whereSql)

GO

From stackOverflow website. This is what i was looking for. I am sharing this here because...

i know i can do the floor() on a decimal number and then store that to a variable and subtract it from the original number

example

@a = 2.75

i know i can do the floor() on a decimal number and then store that to a variable and subtract it from the original number

example

@a = 2.75

What if i want the other value not the floor value ...........

i mean if its 1234.4321

i want 4321 (values after the decimal place...)?

Cheers,

Chandra