In Script task i am using C# to validate text file.I have 3 rows validating all the rows using C# in scriptask and wrting Logfile and if i get error...

Hi,

I trying with pivot but getting error.

Msg 156, Level...

WHen i run the query i will rsult like 98.66% or 97.89% etc.This i am trying to round off with numeric datatype.

Instead of using varchar i am trying to use...

can u give me example on how to do that.

Hi,

CREATE TABLE #Test1(Rownum INT IDENTITY(1,1),empno VARCHAR(3), MatchingOff varchar(10),

atnDate datetime)

/* added column Rownum to table...

Hi Wayne,

I tried it but i am not getting result.

...

Hi,

I modified the table structure.

I want find no of employees who are getting off on same...

Hi,

I am not clear,can u elaborate it.

...

Hi,

Please find the attachment.How to genrate reports like that.

I have 4 weeks data...

Hi,

Please tell me how to use this function ISNULL(value as null, 0) in the stored procedure.

Hi Chris,

Can u tell where i can u in the above stored procedur.

Hi,

In the above stored procedure if i dont have HeadCount for particular date i am getting value as null but i should...

Hi,

This is Table data

Empcount Startdate

...