Comments by rakesh@bbspl.com

rakesh@bbspl.com 31-May-14 6:18am View

Resolved...
Thanks lot.

rakesh@bbspl.com 25-Jan-14 7:16am View

Hello Peter,

I just need to write a query which can result 10 rows as mention above.
and i have three variables @EmpCode=1, @Startdate='01 Jan 2014' and @Enddate='10 Jan 2014'

Thanks in advance...

rakesh@bbspl.com 25-Jan-14 3:18am View

I don't have table2, only need to insert the data inot table1

rakesh@bbspl.com 17-Oct-13 0:32am View

Thanks for the reply, but it will not fulfill the requirement. This only gives the SUM from least to upper.
I need to overwrite null values from last existing value.

rakesh@bbspl.com 5-Mar-13 5:58am View

Thanx lot.....

rakesh@bbspl.com 5-Mar-13 3:01am View

Please help...

rakesh@bbspl.com 10-Jan-13 3:28am View

I am not getting. Please check the query.

Create table Temp1(LeaveCode VarChar(2) Primary Key)

Insert into Temp1 Values('AL')
Insert into Temp1 Values('BL')
Insert into Temp1 Values('CL')
Insert into Temp1 Values('DL')
Insert into Temp1 Values('EL')

Select * from Temp1

Create table Temp2(EmpCode Int,FK_LeaveCode VarChar(2) references Temp1(LeaveCode),Balance Int)

Insert into Temp2 Values(1,'AL',3)
Insert into Temp2 Values(1,'BL',2)
Insert into Temp2 Values(1,'CL',1)

Insert into Temp2 Values(2,'AL',12)
Insert into Temp2 Values(2,'BL',12)
Insert into Temp2 Values(2,'CL',7)
Insert into Temp2 Values(2,'EL',8)

Insert into Temp2 Values(3,'DL',9)
Insert into Temp2 Values(3,'AL',22)

Insert into Temp2 Values(4,'CL',13)
Insert into Temp2 Values(4,'EL',14)
Insert into Temp2 Values(4,'DL',1)

Select * from Temp2

Select EmpCode,T1.LeaveCode,Isnull(Balance,0) from Temp2 T2
Full Outer Join Temp1 T1 ON T1.LeaveCode=T2.FK_LeaveCode

Drop Table Temp2
Drop Table Temp1

rakesh@bbspl.com 10-Jan-13 3:02am View

Not giving the exact result.
Need help

rakesh@bbspl.com 1-Aug-12 4:17am View

Thanks but i need the result like table2. I only have table1.

rakesh@bbspl.com 29-Jun-12 8:20am View

I got a new one now...

Declare @Str As VarChar(100)

SET @Str='Deependar'

Select REPLICATE('A',LEN(@Str))

But Thanks a lot again....

rakesh@bbspl.com 29-Jun-12 8:20am View

Thanks

rakesh@bbspl.com 31-May-12 7:34am View

Hi Rahul Thanks, but i don't wish to use IN statment. This will make the query execution time longer and i am working on a big one stored procedure. I want to use some like "WITH TIES".

Please Suggest

rakesh@bbspl.com 16-May-12 1:45am View

thanks lot...

rakesh@bbspl.com 16-May-12 1:45am View

thanks lot....

Comments by rakesh@bbspl.com (Top 14 by date)