Still not sure what the exact problem is but if you only want unique masters then

SELECT DISTINCT

FILM_PROD_GUIDE.RECNO,

FILM_PROD_GUIDE.ORGANIZATION,

FILM_PROD_GUIDE.CON_FIRST,

FILM_PROD_GUIDE.CON_PFX,

FILM_PROD_GUIDE.CON_LAST,

FILM_PROD_GUIDE.STREET_ONE,

FILM_PROD_GUIDE.CITY,

FILM_PROD_GUIDE.STATE,

FILM_PROD_GUIDE.ZIP,

FILM_PROD_GUIDE.PHONE_DAY

if you include

FILM_SUBCAT_REF.SUBNO...

I would think a trigger is your best bet regardless of the locks. I do this in one of my databases. You have a logic problem in your trigger, try...

Do you mean out of sequence as in Type is not ascending for a question?

If so this will list the entries that are out of sequence

SELECT a.*

FROM @table a...

If you want a single row per FILM_PROD_GUDE then you will have to reduce FILM_CATEGORY and FILM_PROD_GUIDE to single rows as well (using some form of aggregation MIN, MAX etc)

Can you...

If you can guarantee the format for all records then use a format file containing :-

8.0

5

1  SQLCHAR  0  1    "\""      0  Unwanted  ""

2  SQLCHAR  0  255  "\", \""  1  Firstname ...

OK as a function

CREATE FUNCTION dbo.udf_test ()

RETURNS @mytable TABLE (CategoryID int, CategoryName varchar(50), CategoryFather int, HierarchicalLevel int)

BEGIN

DECLARE @temp table (CategoryID int, CategoryFather int, HierarchicalLevel int)

INSERT INTO @temp...

oooops !!!

just reread first post, wanted a function

A different approach

CREATE TABLE #temp (CategoryID int, CategoryFather int, HierarchicalLevel int)

INSERT INTO #temp SELECT CategoryID, CategoryFather, 0

FROM 

DECLARE @rowcount int

SET @rowcount = 1

WHILE @rowcount > 0

BEGIN

UPDATE...

SELECT * FROM table1 WHERE Field1 LIKE 'Test     '

or

SELECT * FROM table1 WHERE Field1 = 'Test %'

if unknown number of trailing spaces

DECLARE @sql nvarchar(100)

SET @sql = 'DECLARE c_PromoTransJoin CURSOR FOR SELECT '+@StageTable+'.LEGACY_PATRON_ID FROM '+@StageTable

EXEC(@sql)

OPEN c_PromoTransJoin

...

CLOSE c_PromoTransJoin

DEALLOCATE c_PromoTransJoin

DECLARE @Today datetime, @TodayLastYear datetime,

  @StartThisYear datetime, @StartLastYear datetime,

  @StartThisMonth datetime

SET @Today = DATEADD(day,0,DATEDIFF(day,0,GETDATE()))

SET @TodayLastYear = DATEADD(year,-1,@Today)

SET @StartThisYear = DATEADD(year,DATEDIFF(year,0,GETDATE()),0)

SET @StartLastYear = DATEADD(year,-1,@StartThisYear)

SET...

It is not a matter of duplicates, a sub query in a select can only return one result. Your subquery will always return multiple rows (otherwise why the GROUP BY)...

bcp cannot optionally detect quotes, it can only process the data if the quotes are always present for the specific columns, so it will not work for your data

as already...

My first program I wrote was in 1970 ish written in CECIL using simple commands like IN and OUT and did basic...

LTRIM(STR(ColumnB,20,ColumnA))