How to Create Stored Procedure search to last id

Question

Hi Guys I have a table contains to three field any one is PK (TeamNo.) (BankName) (City) (Id) is Identity i want to create stored procedures in order to serach by three fields are above and at the same time i select to last record into insert a table according to three fielad( TeamNo.) (BankName) (City) for last id inserted for any teams in a certain Bank and City .Please see table below : Thanks

Amit Gupta · Answer

Select * from tablename where teamno = 'search' and city = 'search' and bankname = 'search' //replace tablename with your tablename // replace search with your searchText

Amit Gupta · Answer

Use max (id)+1 and go for the creation of store procedure. Link fo creating store procedure https://msdn.microsoft.com/en-us/library/ms345415.aspx

Suthahar J · Answer

HI Use SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]; get last value from store procedure . Thanks Suthahar.J

Nitin Sontakke · Answer

I don't have performance statistics at hand but I believe that the Max(Id) would be quicker than select top(1) and order by. For example select max(id) from OperationPlan where TeamNo=@TeamNo AND City=@City AND BankName=@BankName

Bikesh Srivastava · Answer

I think nitin is correct...

Rajan Singh · Answer

hello Abdalla Elawad your requirement is not clear but you want to get id when you insert data in table. CREATE PROCEDURE [dbo].[sp_Charity_Search] @Id int @Name nvarchar(max) @age nvarchar(max) AS BEGIN DECLARE @IDS INT INSERT INTO [dbo].[tbl_Blogs] (Name age) VALUES (@Name @age ) SET @IDS=@@IDENTITY END SELECT @IDS

Pradeep Sahoo · Answer

Your requirements are unclear . Plz post with detailed information.

Abdalla Elawad · Answer

USE [Cash_Plan] GO /****** Object: StoredProcedure [dbo].[R2] Script Date: 10/31/2016 10:01:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[R2] (@TeamNo NVARCHAR(50) @BankName NVARCHAR(50)  @City NVARCHAR(50)) AS BEGIN select top (1) * from OperationPlan --order by ID DESC WHERE TeamNo=TeamNo AND City=@City AND BankName=@BankName ORDER BY ID DESC END ______________________________________________________________ T HIS IS SOLUTION (THANK YOU FOR ALL

Abdalla Elawad · Answer

by More explain i upload the table and screen interface i need save and search code by (last id TeamNoBankNameCity) F igure Below :

Abdalla Elawad · Answer

Full Details for my problem: I have a table Contains from Three fields Are Primary Key (TeamNo.(Pk) City (Pk)BankName (Pk) Also table Contain to Id as identity. I want to create search Command By Three Primaray Key mentined above at any month Same TeamNo. and city and BankName is Repeated according to Id I need for this in Rotation Team within month contiously . What is solution ? Thank you .

Manas Mohapatra · Answer

Please describe more to understand the requirement. If possible please provide an example..

Abdalla Elawad · Answer

i need to search by (teamno  City bankname) please help me

Abdalla Elawad · Answer

hi guys