Hi Matak,

My Procedure is like

ALTER PROCEDURE [dbo].[Usp_UpdateLunchTime]

@StuID INT,

@StartDate datetime,

@EndDate datetime,

@StartTime varchar(20),

@EndTime varchar(20)

--@LunchStart varchar(20),

--@LunchEnd varchar(20)

--@DayName varchar(100),

AS

BEGIN

update tblTime set flag = 1

where StuID = @StuID and...

Hi,

I am having 5 columns as below.

Now I want to update selected data only depend upon lunch time. for example if lunch time of StuID 1 is between 1AM to...

Thanks Chris......... 🙂

Thank you Matak and Chris.

🙂 🙂 🙂

Thanks Matak,

PFB ddl. the requirement is resemble with the code which i posted. Starttime and endtime will select by front end and i want to add in the back end...

Thank you Chris.

I found below code some where else which is resemble to my requirement. Now i want to insert whole result set into my database table. 🙂

DECLARE @t...

Hi,

Still facing an issue while inserting records. I have created Tally table with N. If i use select by applying join then data is showing properly but while inserting giving...

Hi,

I tried but not able to insert data. 🙁

getting the same error. Do i need to create tally table?

Please help.

thanks

Abhas.

Hi Matak,

Could you please let me know the purpose of DATEADD(mi, (N-1)*15 as i am getting below error in your script.

Msg 207, Level 16, State 1, Line 11

Invalid column name...

Hi Matak/Chris,

I want to use starttime and endtime as varchar. is it possible?

Thanks

Abhas.

Thanks matak.

I will try this.But my actual requirement is to insert this data into table after selecting from front end dropdown. for example if user selects date like 2012/03/23 and...

Hi rhythm,

I am doing below steps.

1) Execute sql task - here I am fetching studid,studname,deptname,HodName,HodMail.

2) I am using foreach loop

3) In foreach loop I am using script task and sendmail...

Hi rhythm

I am doing the same but emails are going repeatedly.

Example if there are 5 students then 5 different mails are going.

Thanks

Abhas.

Hi Jeet,

I want to use this by using SSIS.

Thanks

Abaso jadhav

Yes