Click here to Skip to main content
16,010,351 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: how i can make an editable selection list Pin
John-ph19-Oct-07 21:51
John-ph19-Oct-07 21:51 
QuestionPick The Text Through QueryString in C#.Net Pin
Rinki Mukheraji19-Oct-07 20:05
Rinki Mukheraji19-Oct-07 20:05 
AnswerRe: Pick The Text Through QueryString in C#.Net Pin
Saksida Bojan19-Oct-07 20:46
Saksida Bojan19-Oct-07 20:46 
AnswerRe: Pick The Text Through QueryString in C#.Net Pin
John-ph19-Oct-07 20:58
John-ph19-Oct-07 20:58 
AnswerRe: Pick The Text Through QueryString in C#.Net Pin
Guffa19-Oct-07 21:23
Guffa19-Oct-07 21:23 
AnswerRe: Pick The Text Through QueryString in C#.Net Pin
Jintal Patel19-Oct-07 22:49
Jintal Patel19-Oct-07 22:49 
Questionwrite query in strored procedure Pin
Rinki Mukheraji19-Oct-07 19:52
Rinki Mukheraji19-Oct-07 19:52 
AnswerRe: write query in strored procedure Pin
Member 387988119-Oct-07 20:02
Member 387988119-Oct-07 20:02 
CREATE PROCEDURE submitworkertimecardtempemployee
(
@projectid as int,
@empid as int,
@carddate as datetime,
@shift as varchar(15),
@intime as smallint,
@outtime as smallint,
@Problemfaced as varchar(500),
@approveby as int,
@approvesite as int,
@Type as char(1),
@Breaks as smallint

)
As
Declare
@cardno as numeric,
@Counts as int,
@revcode as int


Begin Transaction
Begin



select @revcode = isnull(max(revcode),0) FROM dbo.tbltempsalarymaster INNER JOIN dbo.tblmasterManpower
ON dbo.tbltempsalarymaster.salaryid = dbo.tblmasterManpower.SalaryId
where dbo.tbltempsalarymaster.sdate <=@carddate and left(dbo.tblmasterManpower.tempempid,5)=@empid

--------select @revcode=isnull(max(revcode),0) from tbltempsalarymaster where sdate <=@carddate and empid=@empid

if @revcode >0
begin

select @Counts=count(empid) from tbltempempTimeCardmain where empid=@empid and carddate=@carddate
if @Counts=0
Begin
select @cardno=isnull(max(cardno),0)+1 from tbltempempTimeCardmain
insert into dbo.tbltempempTimeCardmain(cardno,carddate,intime,outtime,projectid,empid,shift,breaks,revcode)
values(@cardno,@carddate,@intime,@outtime,@projectid,@empid,@shift,@breaks,@revcode)
end
if @Counts >0
Begin
select @Counts=count(empid) from dbo.tbltempempTimeCardmain where projectid=@projectid and empid=@empid and carddate=@carddate and app1=1
if @Counts=0
begin
update dbo.tbltempempTimeCardmain set intime=@intime,outtime=@outtime,shift=@shift,
breaks=@breaks,revcode=@revcode where empid=@empid and carddate=@carddate
end

end
end
if @@ERROR<>0
RollBack Transaction
else
commit Transaction
end
GO

My sample Query...,
Hope this will help u...,

Regards,
Magi

AnswerRe: write query in strored procedure Pin
Member 387988119-Oct-07 20:08
Member 387988119-Oct-07 20:08 
AnswerRe: write query in strored procedure Pin
Rinki Mukheraji19-Oct-07 20:44
Rinki Mukheraji19-Oct-07 20:44 
AnswerRe: write query in strored procedure Pin
John-ph19-Oct-07 21:13
John-ph19-Oct-07 21:13 
AnswerRe: write query in strored procedure Pin
Guffa19-Oct-07 21:16
Guffa19-Oct-07 21:16 
Questionhow to send textbox value of one page to textbox of another page Pin
yogesh_softworld12319-Oct-07 19:12
yogesh_softworld12319-Oct-07 19:12 
AnswerRe: how to send textbox value of one page to textbox of another page Pin
That's Aragon19-Oct-07 19:22
That's Aragon19-Oct-07 19:22 
AnswerRe: how to send textbox value of one page to textbox of another page Pin
jagadeeshkumar198419-Oct-07 19:28
jagadeeshkumar198419-Oct-07 19:28 
AnswerRe: how to send textbox value of one page to textbox of another page Pin
John-ph19-Oct-07 21:24
John-ph19-Oct-07 21:24 
GeneralRe: how to send textbox value of one page to textbox of another page Pin
yogesh_softworld12319-Oct-07 23:10
yogesh_softworld12319-Oct-07 23:10 
GeneralRe: how to send textbox value of one page to textbox of another page Pin
Bino B21-Oct-07 20:13
Bino B21-Oct-07 20:13 
Questionhow can i make an editable dropdown list in html using java script [modified](its urgent) Pin
jagadeeshkumar198419-Oct-07 19:06
jagadeeshkumar198419-Oct-07 19:06 
AnswerRe: how can i make an editable dropdown list in html using java script [modified](its urgent) Pin
John-ph19-Oct-07 21:50
John-ph19-Oct-07 21:50 
QuestionOffice PIA Install / IIS Webserver Issue [modified] Pin
Malcolm Smart19-Oct-07 12:24
Malcolm Smart19-Oct-07 12:24 
QuestionValidator Pin
ss.mmm19-Oct-07 10:46
ss.mmm19-Oct-07 10:46 
AnswerRe: Validator Pin
John-ph19-Oct-07 22:31
John-ph19-Oct-07 22:31 
Questionnothing works Pin
learningman19-Oct-07 9:16
learningman19-Oct-07 9:16 
AnswerRe: nothing works [modified] Pin
Saksida Bojan19-Oct-07 20:25
Saksida Bojan19-Oct-07 20:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.