assing result to a table column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

assing result to a table column

Author

Topic

sunilmahanti
Starting Member

4 Posts

Posted - 2011-01-07 : 00:02:54

ALTER function [dbo].[test2](@employee_id int) returns varchar(500)
as
begin
declare @n int
select @n = @employee_id
SELECT CASE (@n / 100000) % 13
WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
WHEN 3 THEN 'three'
WHEN 4 THEN 'four'
WHEN 5 THEN 'five'
WHEN 6 THEN 'six'
WHEN 7 THEN 'seven'
WHEN 8 THEN 'eight'
WHEN 9 THEN 'nine'
when 10 then 'Ten'
when 11 then 'Eleven'
ELSE ''
END
+CASE WHEN (@n / 100000) % 10 > 0 THEN ' Lakh ' ELSE '' END
+CASE WHEN (@n / 1000) % 100 > 0 AND (@n / 1000) > 100 THEN ' and ' ELSE '' END
+CASE (@n / 1000) % 100
WHEN 10 THEN 'ten'
WHEN 11 THEN 'eleven'
WHEN 12 THEN 'twelve'
WHEN 13 THEN 'thirteen'
WHEN 14 THEN 'fourteen'
WHEN 15 THEN 'fifteen'
WHEN 16 THEN 'sixteen'
WHEN 17 THEN 'seventeen'
WHEN 18 THEN 'eighteen'
WHEN 19 THEN 'nineteen'
ELSE
CASE (@n / 10000) % 10
WHEN 2 THEN 'twen'
WHEN 3 THEN 'thir'
WHEN 4 THEN 'for'
WHEN 5 THEN 'fif'
WHEN 6 THEN 'six'
WHEN 7 THEN 'seven'
WHEN 8 THEN 'eight'
WHEN 9 THEN 'nine'
ELSE ''
END
+CASE WHEN (@n / 10000) % 10 > 0 THEN 'ty' ELSE '' END
+CASE WHEN (@n / 1000) % 10 > 0 AND (@n / 10000) % 10 > 0 THEN ' ' ELSE '' END
+CASE (@n / 1000) % 10
WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
WHEN 3 THEN 'three'
WHEN 4 THEN 'four'
WHEN 5 THEN 'five'
WHEN 6 THEN 'six'
WHEN 7 THEN 'seven'
WHEN 8 THEN 'eight'
WHEN 9 THEN 'nine'
ELSE ''
END
END
+CASE WHEN (@n / 1000) % 1000 > 0 THEN ' thousand' ELSE '' END
+CASE WHEN (@n / 100) % 10 > 0 THEN ' ' ELSE '' END
+CASE (@n / 100) % 10
WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
WHEN 3 THEN 'three'
WHEN 4 THEN 'four'
WHEN 5 THEN 'five'
WHEN 6 THEN 'six'
WHEN 7 THEN 'seven'
WHEN 8 THEN 'eight'
WHEN 9 THEN 'nine'
ELSE ''
END
+CASE WHEN (@n / 100) % 10 > 0 THEN ' hundred' ELSE '' END
+CASE WHEN @n % 100 > 0 AND @n > 100 THEN ' and ' ELSE '' END
+CASE @n % 100
WHEN 10 THEN 'ten'
WHEN 11 THEN 'eleven'
WHEN 12 THEN 'twelve'
WHEN 13 THEN 'thirteen'
WHEN 14 THEN 'fourteen'
WHEN 15 THEN 'fifteen'
WHEN 16 THEN 'sixteen'
WHEN 17 THEN 'seventeen'
WHEN 18 THEN 'eighteen'
WHEN 19 THEN 'nineteen'
ELSE
CASE (@n / 10) % 10
WHEN 2 THEN 'twen'
WHEN 3 THEN 'thir'
WHEN 4 THEN 'for'
WHEN 5 THEN 'fif'
WHEN 6 THEN 'six'
WHEN 7 THEN 'seven'
WHEN 8 THEN 'eight'
WHEN 9 THEN 'nine'
END
+CASE WHEN (@n / 10) % 10 > 0 THEN 'ty' ELSE '' END
+CASE WHEN @n % 10 > 0 AND (@n / 10) % 10 > 0 THEN ' ' ELSE '' END
+CASE @n % 10

WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
WHEN 3 THEN 'three'
WHEN 4 THEN 'four'
WHEN 5 THEN 'five'
WHEN 6 THEN 'six'
WHEN 7 THEN 'seven'
WHEN 8 THEN 'eight'
WHEN 9 THEN 'nine'
ELSE ''
END
END words

how to divert this reasult to my payment table to selectd column

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-01-07 : 02:12:28

something like this


insert into payment ( somecol )
select dbo.test2 ( 1234 )

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources