your sample code is not working for me.

i just need to find out rows that has more than 1 digit after decimal point

no its not working t sort out rows which has more than 1 digit after decimal point

the conversion part is working fine.

i just want to find fields where there is a value more than one digit after decimal point

I dont need a round value, what i need is

I have to enforce a constraint where the user has to enter only 1 digit after decimal point, if its...

Adding to that..

How can i make sure that after decimal point there should be only 1 digit?

sorry guys to add another doubt here

@dbname varchar(30),

@jDate DateTime

AS

Begin

exec(

'use ' + @dbname + ';

sql statements (14k lcharcters includes 30+ union operators)

'

end

when i try executing above proc i get a dead...

as you passing string and values... I have a doubt

in this proc

ALTER PROCEDURE spgetemp

@empname varchar(30),

@jdate datetime

AS

SET NOCOUNT ON

insert into #t exec spcheckemp @empname,@jdate

set @cmd='

select * from #t where joindate>='+ ''''+...

thanks jeff..

in the same situation how can i pass parameters to a store proc executed inside another proc.

inner proc will be like

ALTER PROCEDURE spgetemp

@empname varchar(30),

@jdate datetime

AS

SET NOCOUNT ON

insert into #t...

thanks jeff.

How can i enter time in tenths of an hour or has to check if the time entered is in tenths of an hour

Jeff..cud u pls elaborate your method, i didnt follow wht ur doing there?

MAdhavanan.. its not a date am storing but its a number which starts with 4 digit year and...

1st proc

CREATE PROCEDURE mailsecurity

@dbname varchar(20),

@name varchar(10),

@emp varchar(4),

@admin-2 char(1) output

as

begin

set nocount on

declare @SQLCmd nvarchar(4000)

set @SQLCmd = 'use ' + @DBName + ';

DO SOME STUFF

'

END

2nd proc

CREATE PROCEDURE ...

yeah when i do that am getting the following error

exec mailsecurity @dbname = @dbname, @name = @emp, @emp = NULL, @admin-2 = @admin-2 OUTPUT

error is

Msg 137, Level 15, State...

when i run like

exec mailsecurity @dbname,@emp,NULL,Admin output

it is asking to me to delcare @dbname but there is already a parameter @dbname for the second proc

A small change in the proc...

1st proc

CREATE PROCEDURE mailsecurity

@dbname varchar(20),

@name varchar(10),

@emp varchar(4),

@admin-2 char(1) output

as

begin

set nocount on

declare @SQLCmd nvarchar(4000)

set @SQLCmd = 'use ' + @DBName + ';

DO SOME STUFF...

so there is no way to run a view from any database?

is it possible by using master db?