Problem in query

[uspatel]

ALTER PROCEDURE [dbo].[insert_task_details11]
@taskname varchar(150),
@completiondate varchar(30)

AS
BEGIN
DECLARE @DataID int
select DataID=MAX(taskid) from tblTaskAssign;
insert into tblJobs (taskid,taskname,completiondate) values (DataID,@taskname,@completiondate)
END

I want to insert maximum taskid into tblJobs. It gives Error The name "DataID" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. and if I use @DataId instedat od DataID, null value goes in taskid in tblJobs. How to solve this problem thanks

[_Damian S_]

Uma Shankar Patel wrote:

select @DataID=MAX(taskid) from tblTaskAssign; insert into tblJobs (taskid,taskname,completiondate) values (@DataID,@taskname,@completiondate)

Should work assuming that there are TaskID's in tblTaskAssign.

Silence is golden... but duct tape is silver!! Booger Mobile - My bright green 1964 Ford Falcon - check out the blog here!! | If you feel generous - make a donation to Camp Quality!!

[uspatel]

values are inserted but in TaskId column Null value inserted in tblJobs table. i.e. DataId is not inserted or not fetched properly from tblTaskAssign to be inserted into tblJobs

[Blue_Boy]

try this

DECLARE @DataID int
set @DataID = (select isnull(max(taskid),0) from tblTaskAssign)

insert into tblJobs (taskid,taskname,completiondate) values (@DataID ,@taskname,@completiondate)

---

I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.

[uspatel]

thanks