You can do this with a simple cast function, but I would ask why. If this is for presentation, then the presentation layer should format it, not from the...

I have the same issue and was wondering what you came up with for a sooution

I guess my question would be why are you doing this in a trigger. If you're worried about the number of records you are inserting or updating, why not...

I did get yours to work. I put a return after the first RaisError

alter proc spv_test

as

begin

declare @e nvarchar(200)

declare @f nvarchar(200)

set @e = 'Test Error Message'

set @f = 'Another Test...

This will work, you just have to change the severity levels. When I tried 25, I got an error about the error only being specified by sysadmin roles. ...

At least he's consistent. This is just as bad as his other post. 😀

Does this work for you?

declare @runStatus int,

@JobName nvarchar(300) = 'storedprocedures',

@Recipients nvarchar(300) = 'xxxxx@gmailcom',

@Message nvarchar(300) = ' All hourly jobs successfull on getdate()'

select @runStatus = run_status from (

select j.name

,Run_Date=convert(datetime,convert(varchar(8),jh.run_date))

,duration_in_Secs=jh.run_duration/10000*3600

+jh.run_duration%10000/100*60

+jh.run_duration%100

,jh.run_status

from...

It seems like a simple update

declare @t table (

ID int, Service nvarchar(30), Subservice nvarchar(30))

insert into @t

select 123, 'Surgery Service', 'Test' union all

select 123, 'Surgery Service', 'PEDI' union all

select 123, 'Surgery',...

Have you tried using SQLCmd?

I'm not sure what the results are that you are expecting. When I ran your query, it is showing the Value and taxes fields appropriately. I modified the...

Well Convert is a SQL Server function. Did you try Cast?

Put it all in a variable

DECLARE @Path NVarchar(500), @Syntax nvarchar(max)

SET @Path = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2K8R2\MSSQL\Backup\Restores'

--Backs up version DB that was just upgraded. This should always be one version...

Just a shot in the dark, but did you try to do an explicit convert when selecting it?

It's possible, but you have to answer our questions. The data sets look the same. If we compare table 1 to table 2, all the 8:30 entries are...

It sounded like a homework project, so I wanted to make sure you had at least tried something instead of just posting it here and looking for answers. When...