asked
PLEASE CHANGE SQL SERVER STOREDPROCEDURE FOR .NET VISUAL STUDIO
CREATE TABLE MyTable (COMPLAINTID int identity(1,1) NOT NULL -- See above note) ,ResponsiRble varchar(100) NOT NULL --I'm making an assumption as to length here, change to value /*Other columns here */ ,COMPLAINTID_Display AS (CASE WHEN ResponsiRble = 'MANAGEMENT' THEN 'M' WHEN ResponsiRble = 'NETWORK' THEN 'N' ELSE 'O' END + CONVERT(VARCHAR(15),COMPLAINTID)) ) this gives the output as COMPLAINTID_Display M1 N2 O1 but we want the output as M1 N1 O1
Strange..you did not accept this as my answer to your another question. But trying to implement the same kind of logic :)
I don't understand what you're asking for here. You mean you don't want to see the column name?
@Grant Fritchey Since I know the background I know what the OP is aiming for. That is case of a manual auto increment field. I suggested him a computed column instead. For more details please see this [question][1] [1]:
http://ask.sqlservercentral.com/questions/83676/stored-procedure-creation?page=1#83687
It's probably no help to you in the short term, but you should take a look at the sequency operator in SQL Server 2012. That will do exactly what you need.
