ALTER PROCEDURE [dbo].[spKodeDetaljPay] ( @codeid smallint, @guid varchar(64) ) AS BEGIN Select title, text, (Select name from tblPersonPay where tblCode.PersonID = tblPersonPay.PersonID) as Name, (Select email from tblPersonPay where tblCode.PersonID = tblPersonPay.PersonID) as email from tblCode where active='1' -- and " & whereStatement END
|SQL Server R2 Stored procedure make faster||7||48|
|Help with stripping out character in SQL LEFT/RIGHT/REPLACE||2||41|
|Convert char to decimal in a SQL Server View||14||45|
|MS SQL - Rotating Values in SQL||9||53|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!