I wirte down a small query and i wanna write down a store procudure for that..can somebody help me out for this ASAP...its urgent..
Select Id,address1,address2,city,state,zip from xyz
where city is null
HOW TO WRITE STORE PROCEDURE..Do I need to delcare parameter and value...??? can't I just save this query directly by saying
CREATE PROCEDURE AS... and than save...beacuae my boss just wanna keep that procudure as reference to run that.
I'm getting a rather bizarre (but probably simple) error when trying to check for the existence of a procedure before creating it. I know I could just drop it, but I'm really curious as to why this code doesn't work right.
Code SnippetIF OBJECT_ID(N'dbo.spCoverageLog') IS NULL CREATE PROCEDURE [dbo].[spCoverageLog] ( @spName VARCHAR(100) ) AS BEGIN UPDATE dbo.CodeCoverage SET CreationDate = GETDATE(),ProcedureName = @spName; END
GO It's generating a syntax error at PROCEDURE.
Anyone know why this might happen?
The solution was to run the CREATE PROCEDURE statement with EXEC, but it shouldn't be.
5- Set SQL Project Permission Level to External, change from the project properties Database Tab
"Permission Level Select the permission level from the drop-down list to specify a set of code
access permissions granted to the assembly when accessed by Microsoft SQL Server. The value can be
Safe, External, or Unsafe; these values correspond to the SQL Server permission sets SAFE,
EXTERNAL_ACCESS, and UNSAFE, respectively. Safe is the default.
This setting corresponds to the PERMISSION_SET argument for the SQL Server CREATE ASSEMBLY command. " MSDN
6- "The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server trusts
the database and the contents within it. By default, this setting is OFF, but can be set to ON by
using the ALTER DATABASE statement.
Note: To set this option, you must be a member of the sysadmin fixed server role." MSDN
ALTER DATABASE [Database Name] SET TRUSTWORTHY ON .
7- Build and Deploy assembly.
8- The web service reference generates XmlSerializers assembly, there are many ways to resolve this issue, a quick way would be to add the XmlSerializers assembly to the database where the main CLR assembly is deployed.
From "SQL Server Management Studio" select the target database, goto "Programmability" then -> "Assemblies", there right click "New Assembly" and specify reference.
Hope this is helpful to others. Regards Rabeeh Abla
My store Procedure is not save in Strore Procedure folder at the time of saving it give me option to save in Project folder and file name default is SQLQuery6.sql when i save it after saving when i run my store procedure
exec [dbo].[SP_GetOrdersForCustomer] 'ALFKI'
I am getting below error :
Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'dbo.SP_GetOrdersForCustomer'.
Hi guysi would really appreciate your help here. what am i doing wrong with this stored procedure ALTER PROCEDURE usp_CreateNewCustomer( @LName as varchar(50), @FName as varchar(50), @Dept as varchar(50)=NULL, @PhoneType as varchar(50)=NULL, @Complete as Bit=NULL, @CustomerID as Int OUTPUT, @FaxModel as varchar(50)=NULL, @FaxNumber as varchar(50)=NULL, )ASINSERT INTO [CustomerInfo] ([LName], [FName], [Dept], [PhoneType], [Complete]) VALUES (@LName, @FName, @Dept, @PhoneType, @Complete)SELECT SCOPE_IDENTITY()INSERT INTO Extras (CustomerID, FaxModel, FaxNumber) VALUES (@CustomerID, @FaxModel, @FaxNumber)RETURN It keeps on complaning "'usp_CreateNewCustomer' expects parameter '@CustomerID', which was not supplied."thanks
Hi all, I have a few question regarding SPROC. Firstly, I want to create a sp, that will return a multiple column of data, how do you achieve that. Secondly, I want to create a store procedure that will return a multiple columns in a cursor as an output variable. Any help will be much appreciated. Can you have more then 1 return parameters??? Thanks. Kabir
I have asp.net web application which interface with SQL server, I want to run store procedure query of SQL using my asp.net application. How to declare connectons strings, dataset, adapter etc to run my store procedure resides in sql server. for Instance Dim connections as string, Dim da as dataset, Dim adpt as dataadapter. etc if possible , then show me completely code so I can run store procedure using my button click event in my asp.net application thank you maxmax
I am not sure if it is right place to ask the question. I have a store procedure in which funcitons are called and several temp tables are created. When I use sql analyzer, it runs fast. But when I called it from asp.net app, it runs slow and it waits and waits to get data and insert into temp tables and return. Though I have used with (nolock), it still not imprvoed. Any suggestions? Thanks in advance. NetAdventure
Hello, I am very new to ASP.NET and SQL Server. I am a college student and just working on some project to self teaching myself them both. I am having a issue. I was wondering if anyone could help me. Ok, I am creating a web app that will help a company to help with inventory. The employee's have cretin equipment assign to them (more then one equipment can be assigned). I have a search by equipment and employee, to search by equipment the entire database even then equipment that isn't assigned with the employee's it shows only that employees and if they have any equipment. They can select a recorded to edit or see the details of the record. The problem i am having is that the Info page will not load right. I am redirected the Serial Number and EmployeeID to the info page. I got everything working except one thing. If a person has more then one equipment when i click on the select it redirect and only shows the first record not the one I selected. and when i change it, a employee that doesn't have equipment will not show up totally.
SELECT E.FirstName AS UserFirstName, E.LastName AS UserLastName, eqtype.Description AS UserEquipType, empeq.UserEquipID, E.EmployeeID, E.cwopa_id, eq.IPAddress, eq.Location, eq.DataLine3, eq.DataLine2, eq.Voice, eq.DataLine1, eq.FloorBox, eq.Comments, eq.SerialNo, eq.Model, eq.Brand, eq.TagNo, eq.PurchaseLease, eq.WarrantyExpDate, eq.PhoneType, eq.PhoneNum, eq.CellNumber, eq.DataNumber, eq.SIDNumber, eq.Carrier FROM dbo.EMPLOYEES AS E LEFT OUTER JOIN dbo.EMPLOYEES_EQUIP AS empeq ON empeq.EmployeeID = E.EmployeeID LEFT OUTER JOIN dbo.EQUIPMENT AS eq ON eq.EquipID = empeq.EquipID LEFT OUTER JOIN dbo.EQUIP_TYPE AS eqtype ON eqtype.EquipTypeID = eq.EquipTypeID WHERE E.EmployeeID = @EmployeeID and eq.SerialNo=@SerialNo EmployeeID and SerialNo are primary keys. I was thinking maybe create a store procedures, but I have no idea how to do it. I created this and no syntax error came up but it doesn't work CREATE PROCEDURE dbo.inventoryinfo AS DECLARE @EmployeeID int DECLARE @SerialNo varchar(50) IF( @SerialNo is NULL) SELECT E.FirstName AS UserFirstName, E.LastName AS UserLastName, eqtype.Description AS UserEquipType, empeq.UserEquipID, E.EmployeeID, E.cwopa_id, eq.IPAddress, eq.Location, eq.DataLine3, eq.DataLine2, eq.Voice, eq.DataLine1, eq.FloorBox, eq.Comments, eq.SerialNo, eq.Model, eq.Brand, eq.TagNo, eq.PurchaseLease, eq.WarrantyExpDate, eq.PhoneType, eq.PhoneNum, eq.CellNumber, eq.DataNumber, eq.SIDNumber, eq.Carrier FROM dbo.EMPLOYEES AS E LEFT OUTER JOIN dbo.EMPLOYEES_EQUIP AS empeq ON empeq.EmployeeID = E.EmployeeID LEFT OUTER JOIN dbo.EQUIPMENT AS eq ON eq.EquipID = empeq.EquipID LEFT OUTER JOIN dbo.EQUIP_TYPE AS eqtype ON eqtype.EquipTypeID = eq.EquipTypeID WHERE E.EmployeeID = @EmployeeID ELSE SELECT E.FirstName AS UserFirstName, E.LastName AS UserLastName, eqtype.Description AS UserEquipType, empeq.UserEquipID, E.EmployeeID, E.cwopa_id, eq.IPAddress, eq.Location, eq.DataLine3, eq.DataLine2, eq.Voice, eq.DataLine1, eq.FloorBox, eq.Comments, eq.SerialNo, eq.Model, eq.Brand, eq.TagNo, eq.PurchaseLease, eq.WarrantyExpDate, eq.PhoneType, eq.PhoneNum, eq.CellNumber, eq.DataNumber, eq.SIDNumber, eq.Carrier FROM dbo.EMPLOYEES AS E LEFT OUTER JOIN dbo.EMPLOYEES_EQUIP AS empeq ON empeq.EmployeeID = E.EmployeeID LEFT OUTER JOIN dbo.EQUIPMENT AS eq ON eq.EquipID = empeq.EquipID LEFT OUTER JOIN dbo.EQUIP_TYPE AS eqtype ON eqtype.EquipTypeID = eq.EquipTypeID WHERE E.EmployeeID = @EmployeeID and eq.SerialNo=@SerialNoGO Also, when a user selects the select button in either Employee search or Equipment search it redirects them to info.aspx. Should I create a different aspx page for both? But I don't believe I should do that. I don't know if I gave you enough information or not. But if you could give examples that would be wonderful! Thanks so much Nickie
Hi, All, I need to write a sales report which needs to seperate total from direct sale and agentsale. The report looks like this( in the table of query,we have agentnumber, productname, sales, month
Month salefromagent directsale total Jan 1100 2300 3400 Feb 800 500 1300 .......... Dec --------------------------------- I know we can handle this in the program use two queries. But is there a way to do it use store procedure and then pass the result of store procedure to the ASP program. I am trying to write my first store procedure, thanks for any clue. Betty
Hi all, I need to write a sales store procedure. The sales summary is basically group by agentCode. But the problem is some agents have subagents. i.e., in the sales table. one agent 123456 has many subagents whose agentCode start with 17. And I want to group sales for all subagents who have agentCode 17XXXX to agent 123456's sales. what should I do in the store procedure.
I am trying to create a store procedure that look at a table and only maintain 30 worth of data only forever. The data that fall outside the 30 days need to be deleted. Can anyone help me with this?
I would like to create a employee store procedure to insert a record and mean while i can retrieve the EmployeeID for the record just inserted. Can you show me how to create a store procedure like this. Now i have a insert store procedure in the following:
CREATE PROCEDURE AddEmployee (@efname nvarchar(20), @elname nvarchar(20) ) AS
insert into tblEmployeeName (EmployeeFName, EmployeeLName) values (@efname,@elname) GO
This is an Oracle store procedure. Can Any body help me to convert it into SQL Server stored Procedure
PROCEDURE CALC_PERC (DB_ID IN NUMBER, LAT_TYPE IN CHAR) IS Tot_work_all number(12,2); Bid_tot number(12,2); Ewo number(12,2); Overruns number(12,2); Underruns number(12,2); Contr_tot_all number(12,2); sContractType ae_contract.contr_type%type; BEGIN select sum(nvl(tamt_ret_item,0) + nvl(tamt_paid_item,0)) into Tot_work_all from valid_item Where db_contract = db_id; Select sum(Contq * Contr_Price) into Bid_tot From Valid_item Where nvl(New_Item,'N') <> 'Y' and db_contract = db_id; Select sum(Qtd * Contr_price) into Ewo From Valid_item Where nvl(New_item,'N') = 'Y' and db_contract = db_id; Select Sum((Qtd-Nvl(Projq,0))*Contr_Price) into Overruns From Valid_item Where Qtd > Nvl(Projq,0) and db_contract = db_id and nvl(New_Item,'N') = 'N'; IF LAT_type <> 'R' THEN Select Sum((Nvl(Projq,0)-Contq) * Contr_Price) into Underruns From Valid_item Where Nvl(Projq,0) < Contq and db_contract = db_id and nvl(New_Item,'N') = 'N'; ELSE Select Sum((Nvl(Qtd,0)-Contq) * Contr_Price) into Underruns From Valid_item Where Nvl(Qtd,0) < Contq and db_contract = db_id and nvl(New_Item,0) = 'N'; end if; Contr_tot_all:= NVL(Bid_tot,0) +NVL(ewo,0) +NVL(overruns,0) +NVL(underruns,0);
IF Contr_tot_all = 0 THEN
Select Contr_type into sContractType from ae_contract where db_contract = db_id;
IF sContractType = 'A' OR sContractType = 'T' THEN --If the divisor is zero here, it's not an error. update ae_contract set perc_compu = 0 where db_contract = db_id;
ELSE --If the divisor is zero here, it would be an error update ae_contract set perc_compu = 100 * tot_work_all/contr_tot_all where db_contract = db_id; END IF; Else --Here we have a real number to calculate, so go ahead and do your stuff! update ae_contract set perc_compu = 100 * tot_work_all/contr_tot_all where db_contract = db_id; END IF; END;
hello iam new to store procedures.can anyone tell me how do i put in this sql statement into store procedure SELECT * FROM PortMaster WHERE PortCode= '" & Request.QueryString("PortCode") & "' "
TheProblem is coming in ,how do i put "Request.QueryString("PortCode")" into sql queranalyzer.iam using this in .aspx page. depending on querystring the record is selected.
hello iam using store procedure to open the the selected rows in datagrid into Excel.but iam getting blank spreadsheet.the querystrings are getting passed but the rows turn out to be blank. if i do not use store procedure than everything is ok.the querystring contains multiple strings so as to display it in excel. the stroe procedure is
CREATE PROCEDURE Employee_ExcelDisplayHO(@ID varchar(100)) AS SELECT * FROM employee_master WHERE empuser_id IN (@ID)
and this is the statement that i use in my .aspxpage to call store procedure
Dim Cmd As New SqlDataAdapter("Employee_ExcelDisplayHO", myconn) cmd.SelectCommand.CommandType = CommandType.StoredProcedure cmd.SelectCommand.Parameters.Add(New SqlParameter("ID", SqlDbType.VarChar, 100)) cmd.SelectCommand.Parameters("@ID").Value = Request.QueryString("ID")
iam using store procedure to return certain no. of columns frm table.the query is SELECT empuser_id,FullName,CAddress,PAddress,PhResidence,Mobile FROM employee_master WHERE empuser_id IN (" & txtID.Text & ")
i return it to datagrid in my .aspx(using VB.net) page.but i am getting blank datagrid. when i write the above query in my codebehind it runs normally and datagrid is populated with records. i tried this in query analyzer as well it runs normally returing rows. only in store procedure it gives me blank record. any suggestions what is wrong ?
In this procedure i want to runtime insert ShahVis i.e REassignuserid. it will always change so i want runtime insert this field. and created by this is store in globaly i want to retrive this runtime. Please help me.
I am trying to loop through a string of ID's and check if theproductname for the ID is 'Chai' if so change it to 'Tea'. This is inthe northwind db - products table. call it exec sp_UpdateProduct'1,2,3'It does not work, any ideas - syntax, etc....CREATE PROCEDURE dbo.sp_UpdateProduct@IDs varchar(200)ASBEGINdeclare @sStr1 varchar(200)declare @iStrLen1 intdeclare @sParseElm1 char(2)declare @sStatus varchar(200)declare @count intset @sStr1= @IDsset @iStrLen1= len(@sStr1)SET @count = 0while charindex(',',@sStr1) <> 0beginselect @sParseElm1 = substring(@sStr1,1,CHARINDEX(',',@sStr1 ) - 1)set @sStatus = 'select productname from products where productid='+@sParseElm1if @sStatus = 'CHAI'update products set productname = 'TEA'elseupdate products set productname = 'CHAI'set @sStr1 = substring(@sStr1, CHARINDEX(@sStr1,',') + 1, @iStrLen1)endendGO
I follow the example for store procedure from this link to deal with large amount of data and it work great. http://www.4guysfromrolla.com/webtech/042606-1.shtml
CREATE PROCEDURE [dbo].[usp_PageResults_NAI] ( @startRowIndex int, @maximumRows int ) AS
DECLARE @first_id int, @startRow int
-- A check can be added to make sure @startRowIndex isn't > count(1) -- from employees before doing any actual work unless it is guaranteed -- the caller won't do that
-- Get the first employeeID for our page of records SET ROWCOUNT @startRowIndex SELECT @first_id = employeeID FROM employees ORDER BY employeeid
-- Now, set the row count to MaximumRows and get -- all records >= @first_id SET ROWCOUNT @maximumRows
SELECT e.*, d.name as DepartmentName FROM employees e INNER JOIN Departments D ON e.DepartmentID = d.DepartmentID WHERE employeeid >= @first_id ORDER BY e.EmployeeID
Hello AllI get stuck in one problem , Please help me and excuse me on the poorKnowledgein SQL Server Store procedureQ1...I want to return a string type value from store procedure , Is itpossible to do it.if posible then Please guide us how we can do it .Q2...I search a lot on net but i am unable to understand the ExtendedStore Procedure.How to register it and how to use in our store procedure .Q3 ... How to use xp_sendmail.dll in SQL Server.Thanking youWith regardsTarun
Hi Everyone,I appreciate if you can help on the following procedure. When I ran it in my project in Visual Studio, the compiler always complained that it expected a parameter "@stud_id" that was not provided. What was wrong with this procedure? Thank you for your help.a123. ALTER Procedure registerstudent( @email nvarchar(100), @student_password nvarchar(10), @first_name nvarchar(25), @last_name nvarchar(25), @address nvarchar(255), @city nvarchar(50), @province nvarchar(25), @country nvarchar(50), @phone_no_cell nvarchar(25), @phone_no_home nvarchar(25), @hour_rate int, @status char(1), @stud_id int output )As INSERT INTO student ( email, student_password, first_name, last_name, address, city, province, country, phone_no_cell, phone_no_home, hour_rate, status ) VALUES ( @email, @student_password, @first_name, @last_name, @address, @city, @province, @country, @phone_no_cell, @phone_no_home, @hour_rate, @status )SELECT @stud_id = @@identity
Hi,I have three different tables. I want one login screen and check all table ,if any user got it,but i have written simple store procedure and i take values by parametrically,how can i know user's table name?ALTER PROCEDURE [dbo].[sp_GirisKontrol] -- Add the parameters for the stored procedure here @Username nchar(12), @Password nchar(12), @Id int output, @Rowguid UniqueIdentifier outputASBEGIN SET NOCOUNT ON; SELECT @Id=Id,@Rowguid=Rowguid FROM Admin WHERE Username =@Username AND Password =@Password UNION SELECT @Id=Id,@Rowguid=Rowguid FROM Ogretmen WHERE Username =@Username AND Password =@Password UNIONSELECT @Id=Id,@Rowguid=Rowguid FROM Ogrenci WHERE Username =@Username AND Password =@Password if(@Id IS NULL) SELECT @Id=-1END
Hi: If I have a query: SELECT productName FROM tblProduct WHERE productID = 1 If I send this query from my application, it will pretty fast getting the result return back from SQL Server. I use store procedure in SQL server, should also very fast. But which one is better in terms of speed and traffic? especially when my query getting complicated and more data need to retrive. I need to decide which way (store procedure or SQL ) for my medium applicatoin. Thank you very much. Jt
I have a stored procedure that creates a normalized table from an existing denorm table. So I just need a simple way to call this SP from an aspx page. It would be good though to know how many records were effected, but this is not a requirement.
Is there anyway to run an ALTER FULLTEXT CATALOG mycat REBUILD, before the select? ALTER PROCEDURE [dbo].[Search] @q VARCHAR(255)ASBEGIN SELECT Q.Rank, Title, ArticleID, REPLACE(REPLACE(REPLACE(REPLACE(SUBSTRING(Article,0,250), 'Overview', ''), '<strong>', ''), '<br />', ' '), @q, '<span class="Highlight">' + @q + '</span>') AS Article, @q AS Query FROM Articles, FREETEXTTABLE(Articles, *, @q) Q WHERE Articles.ArticleID=Q.[key] ORDER BY Rank DESC;ENDIf I don't rebuild the catalog, the rank always returns as 0. Thanks.
Hi I have created one store procedure which containts multiple if statement . I have create this for searching . Here is store procedure---------------------------------------------------------SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE School_Alumni_Search -- Add the parameters for the stored procedure here @Name nvarchar(30), @Batch_Year nvarchar(30), @Course_Done nvarchar(30) ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT OFF; -- Insert statements for procedure here IF @Name='' SELECT dbo.User_Login.First_Name, dbo.User_Login.Last_Name, dbo.User_Login.City, dbo.User_Login.Phone_Number, dbo.User_Login.Email, dbo.School_Alumi_Registration.Year_of_Joining, dbo.School_Alumi_Registration.Year_of_Leaving, dbo.School_Alumi_Registration.Batch_Year, dbo.School_Alumi_Registration.Course_Done, dbo.School_Alumi_Registration.Photo_Image FROM dbo.User_Login INNER JOIN dbo.School_Alumi_Registration ON dbo.User_Login.Login_ID = dbo.School_Alumi_Registration.Login_Id WHERE dbo.School_Alumi_Registration.Batch_Year=@Batch_Year and dbo.School_Alumi_Registration.Course_Done=@Course_Done print '1' return IF @Batch_Year='' SELECT dbo.User_Login.First_Name, dbo.User_Login.Last_Name, dbo.User_Login.City, dbo.User_Login.Phone_Number, dbo.User_Login.Email, dbo.School_Alumi_Registration.Year_of_Joining, dbo.School_Alumi_Registration.Year_of_Leaving, dbo.School_Alumi_Registration.Batch_Year, dbo.School_Alumi_Registration.Course_Done, dbo.School_Alumi_Registration.Photo_Image FROM dbo.User_Login FULL OUTER JOIN dbo.School_Alumi_Registration ON dbo.User_Login.Login_ID = dbo.School_Alumi_Registration.Login_Id WHERE dbo.User_Login.First_Name Like'%'+@Name+'%' and dbo.School_Alumi_Registration.Course_Done=@Course_Done print '2' return IF @Course_Done='' SELECT dbo.User_Login.First_Name, dbo.User_Login.Last_Name, dbo.User_Login.City, dbo.User_Login.Phone_Number, dbo.User_Login.Email, dbo.School_Alumi_Registration.Year_of_Joining, dbo.School_Alumi_Registration.Year_of_Leaving, dbo.School_Alumi_Registration.Batch_Year, dbo.School_Alumi_Registration.Course_Done, dbo.School_Alumi_Registration.Photo_Image FROM dbo.User_Login FULL OUTER JOIN dbo.School_Alumi_Registration ON dbo.User_Login.Login_ID = dbo.School_Alumi_Registration.Login_Id WHERE dbo.User_Login.First_Name Like'%'+@Name+'%' and dbo.School_Alumi_Registration.Batch_Year=@Batch_Year print '3' return IF @Batch_Year='' and @Name='' SELECT dbo.User_Login.First_Name, dbo.User_Login.Last_Name, dbo.User_Login.City, dbo.User_Login.Phone_Number, dbo.User_Login.Email, dbo.School_Alumi_Registration.Year_of_Joining, dbo.School_Alumi_Registration.Year_of_Leaving, dbo.School_Alumi_Registration.Batch_Year, dbo.School_Alumi_Registration.Course_Done, dbo.School_Alumi_Registration.Photo_Image FROM dbo.User_Login FULL OUTER JOIN dbo.School_Alumi_Registration ON dbo.User_Login.Login_ID = dbo.School_Alumi_Registration.Login_Id WHERE dbo.School_Alumi_Registration.Course_Done=@Course_Done print '4' return IF @Course_Done='' and @Name='' SELECT dbo.User_Login.First_Name, dbo.User_Login.Last_Name, dbo.User_Login.City, dbo.User_Login.Phone_Number, dbo.User_Login.Email, dbo.School_Alumi_Registration.Year_of_Joining, dbo.School_Alumi_Registration.Year_of_Leaving, dbo.School_Alumi_Registration.Batch_Year, dbo.School_Alumi_Registration.Course_Done, dbo.School_Alumi_Registration.Photo_Image FROM dbo.User_Login FULL OUTER JOIN dbo.School_Alumi_Registration ON dbo.User_Login.Login_ID = dbo.School_Alumi_Registration.Login_Id WHERE dbo.School_Alumi_Registration.Batch_Year=@Batch_Year print '5' return IF @Course_Done='' AND @Batch_Year='' SELECT User_Login.First_Name, User_Login.Last_Name, User_Login.City, User_Login.Phone_Number, User_Login.Email, School_Alumi_Registration.Year_of_Joining, School_Alumi_Registration.Year_of_Leaving, School_Alumi_Registration.Batch_Year, School_Alumi_Registration.Course_Done, School_Alumi_Registration.Photo_Image FROM User_Login FULL OUTER JOIN School_Alumi_Registration ON User_Login.Login_ID = School_Alumi_Registration.Login_Id WHERE (User_Login.First_Name LIKE '%'+ @Name + '%') print '6' ENDGO ----------------------------------------------------------------------------------------------- But its not working fine. Problem with if statements. I dont know where I did wrong. Please suggest me better option .
