Pardon me but this sounds like a homework problem. One option look at REDGATE Software's product at:

http://www.red-gate.com/products/SQL_Compare/index.htm

Suggest you read this in BOL and see how isolation levels effect data integrity and make your decision(s) based on that

Adjusting Transaction Isolation Levels

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9dfc3c68-9bf0-4896-b3b6-d2f1a601ead1.htm

Believe this will handle both "Jones, Jack" and "Jones Jack" equally as well.

DECLARE @WritersNames AS VARCHAR(50)

DECLARE @Pos AS INT

SET @WritersNames = 'Jones Jack'

SET @Pos = (Select charindex(',',@Writersnames,1))

IF (@Pos = 0)...

Use SELECT CAST(@myval AS DECIMAL(10,2))

For example:

DECLARE @myval AS FLOAT

SET @myval = 123.45678

SELECT CAST(@myval AS DECIMAL(10,2))

result: 123.46 (note the rounding)

Next example:

DECLARE @myval AS FLOAT

SET @myval = 565

SELECT CAST(@myval AS DECIMAL(10,2))

result...

Jacob:

With Windows authorization:

Use my sample code and connection is relatively simple...

Autonumber is an Access term, what you may mean in SQL is termed an Identity column - which contains a number unique within that table and incremented each time a...

For my own self editication I created a table and loaded your data and then developed a CTE to identify all the duplicate entries in what was your Column 5....

Jacob, well I again checked my incoming PM box, nothing, oh well will leave this subject (forum) open so I will recieve a message saying that some one posted to...

Jacob did you get my Private Message to you.

First of all the App user does NOT have to login to SQL Server and/or the database, as long as the database...

To assist others who desire to help you please read the article in my signature block and post your question accordingly, that is the table schema, test/sample data as an...

How about this policy. IT workers (Programmers, developers, DBAs) were classified as "Salaried/Exempt". Which meant you were not paid overtime, or given comp time off. Now if...

To select just the month, that is data to the left of the first comma try this code to give you an idea of what you can do:

DECLARE @FM as...

Heather then like Steve Jones' recommendation

. Limit your reading to Jeff's work...

Laura

Perhaps a dumb question on my part but are you...

Extremely difficult to make any meaningfully suggestions with such meager information. Can...