Suji,

You can use the System_User and HOSTNAME() function to return the logged in user and his host computer.

Your trigger should look something like this:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER dbo.MyDeleteTriggerName

...

I haven't had any problems with the transfer jobs task. SSIS...

Sorry did not read your post in full; I missed automated. Why does this process need to be automated? Are you moving the jobs to another server? ...

George,

Open SSMS click on jobs and in the Object Explorer Details Windows you will see a list of jobs. You can highlight all the jobs and right click -->...

Good solution Jeff, simply amazing. 😉

I got the string parser script from the script section of this site, I believe 😀

I forgot to mention that the solution I posted operates one record at a time. As all of the previous posters have suggested you will need a looping mechanism...

You could use a parse function with a select statement to do something like this.

Note: that this particular function strives off a numbers table which I have provided...

You can create a temp table, with an identity column and have it auto generate all the way down.

CREATE TABLE #tmp(

Row_ID BIGINT IDENTITY(1,1),

ID INT,

Col2 INT,

Col3 INT

)

INSERT INTO #tmp

SELECT ID,Col2,Col3

FROM MyTable

SELECT...

SQL Scripter is a free tool to dynamically create INSERT scripts. It works fast and well.

http://www.sqlscripter.com/

NP thanks for the feedback. 😀

I'd suggest you use a nested table expression, meaning

select nestedTSel.*, [Monthly Pac] ....from ( select 'Monthly Pac' = CASEWHEN tPolicyBillPrem.POL_BILL_TYP_CD = '4' AND tPolicyA.POL_CSTAT_CD = '1' THEN tPolicyBillPrem.POL_SNDRY_AMTELSE 0END,'Annualized Premium'...

This is actually much easier than you think just run the script as I have it below. This method works because you are converting all the floats to decimal(25,10)...

If I am understanding your correctly, you are saying...

Unfortunately, you cannot use derived columns to compute on other columns in the same query. You would have to put the MontlyPac case statement in the then section of...