hi,

very basic piviting code,

try this

create table #temp

(

EmployeeID varchar(2),

StructureID varchar(2),

StructureAmount int,

DeductionID varchar(2),

DeductionAmount float

)

insert into #temp

select '01', '01', 13500, '01', 70.0

union all

select'01', '02', 1500, '02', 0.0

union all

select'01', '03', 1230, '03' ,500

union...

Hi,

Is this works in the SQL?

ref the post: http://www.sqlservercentral.com/Forums/Topic711409-338-2.aspx

ARUN SAS

Hi,

Why only Indian why not others?

ARUN SAS

Hi,

create the function like

CREATE FUNCTION AGE_ASOF_NOW (@EMP_DOB DATETIME,@curr_dt datetime)

returns varchar(1000)

AS

BEGIN

declare...

Hi,

Your output gives only the days,

The age may come in the format of years months and days like 34 years 10Months and 15 days

ARUN SAS

Hi,

try this

CREATE TABLE #tblAssessments

(

AssessmentID int IDENTITY(1,1) NOT NULL,

UserID int NULL,

AssessmentDate datetime NULL,

FollowUpCall numeric(1, 0) NULL,

HealthScore int NULL

)

insert into #tblAssessments (UserID,AssessmentDate,FollowUpCall,HealthScore)

values (1, '04-May-2009', 1, 5)

insert into #tblAssessments (UserID,AssessmentDate,FollowUpCall,HealthScore)

values (1, '06-May-2009',...

Hi,

Show some sample data with desired output.

ARUN SAS

Hi,

try this

declare @abc int

select @abc = 125

select @abc = 12*(round((@ABC/12),0) + (case when (cast(@ABC as int)%12)< 6.00 then 0 else 1 end))

-- assume that nearest to 6

select @abc

ARUN SAS

Hi,

from your codeing result for count of currency alwayes one,

--only the customer...

Hi Kishore,

When the value like 1.23999

Then it’s round the value

Select @input = 1.23999, @precision = 4

Result to 1.2400

For that better...

Hi,

try this

declare @abc varchar(10)

set @abc = '1234'

select substring(@ABC,1,case when (charindex('+',@ABC)-1)< 0 then 0 else (charindex('+',@ABC)-1)end)

select substring(@ABC,(charindex('+',@ABC)+1),(len(@ABC)))

ARUN SAS

Hi,

try this

DECLARE @abc VARCHAR(1000)

SELECT @abc = 'SELECT * FROM syssegments; SELECT * FROM sysconstraints;'

select @abc = replace(@abc,';',' GO')

exec (@abc)

ARUN SAS

Hi,

See the sysjobhistory table in the msdb,

In run_status col shows the status of the job or steps

ARUN SAS

Hi suresh,

Are you trying this?

first try to bulid the coding, then show it

ARUN SAS

Hi,

your code is correct

and try with close brackets

update emp_data

set firstname=substring(name,1,(charindex('+',name)-1)),

lastname=substring(name,(charindex('+',name)+1),(len(name)))

declare @abc varchar(10)

set @abc = 'ABCD+1234'

select substring(@ABC,1,(charindex('+',@ABC)-1))

select substring(@ABC,(charindex('+',@ABC)+1),(len(@ABC)))

ARUN SAS