FAQ Database Discussion Community

Sql Server TVP Merge with Where/Case Statement

What I am doing is pretty straight forward dug around at a few posts and couldn't figure out how to express it properly TVP Declaration CREATE TYPE [dbo].[CustomSeoDic] as table ( [RecordID] [int] NULL, [Name] [nvarchar](125) NULL) GO Attempt 1 BEGIN MERGE INTO Listings L USING @CustomSeo AS Tvp ON...