Hi all,
i have an stored procedure
alter Procedure [dbo].[getFromQueryMaster]
@EmpId int,
@RoleId int,
@ModuleId int,
@CompanyId int,
@Frid int,
@callerid varchar(15)
as
DECLARE @QUERY NVARCHAR(2000)
SELECT @QUERY =QUERY FROM QUERYMASTER WHERE COMPANYID=@COMPANYID AND Frid=@Frid AND ROLEID=@ROLEID AND MODULEID=@MODULEID
EXEC (@QUERY + @callerid )
here the @ query will load the value from the Query master table,when it is executing it should take values from @caller id
my query should work like this,
SELECT top 5 Callerid,Taxicategory,PickupZone,DropoffZone FROM [JobsCurrent4.0] where Callerid=@Callerid,'Answer Call', 1,1,1,1,1,1
pls suggest me me how to pass in exec querys
Table Insert Statement :
INSERT INTO [dbo].[QueryMaster]
([Query]
,[Modulename]
,[ModuleId]
,[EmpId]
,[RoleID]
,[UserId]
,[CompanyId]
,[frID])
VALUES
('SELECT top 5 Callerid,Taxicategory,PickupZone,DropoffZone FROM [JobsCurrent4.0] where Callerid=@Callerid,'Answer Call', 1,1,1,1,1,1)