--I got an error when I tried. So

/*

Server: Msg 145, Level 15, State 1,...

SELECT DATE_STAMP_ "DateTime", CONVERT(DECIMAL(Scale, Precision),DATA_VALUE_) "Value"

FROM  dbo.trenddata

WHERE TID_ = @TID AND @StartDate <= DATE_STAMP_ AND @EndDate >= DATE_STAMP_ AND RECORD_TYPE_ = 2

DECLARE @MyDate DATETIME

SET  @MyDate = '05/07/2005'

IF DATEDIFF(MONTH, @MyDate, GETDATE()) = 1

SELECT @MyDate MyDate, GETDATE() Todaye, 'PREVIOUS MONTH'

IF CONVERT(VARCHAR, DATEADD(MONTH, 1, @MyDate), 101) = CONVERT(VARCHAR, GETDATE(), 101)

SELECT @MyDate MyDate, GETDATE() Todaye,...

For errors like data integerity errors and schema errors sql statement will be terminated.

http://www.sommarskog.se/error-handling-I.html

Work around is use output paramenter and set it to success at the end of...

I have seen code like this in SQL Server 6.5 by some developers.

DECLARE @product VARCHAR(50)

DECLARE @ProductID INT -- I assume Product ID as primary Key

SELECT *

 INTO #Products

FROM

 Products

WHILE EXISTS (SELECT...

In SQL Server 2000 it is 8000 and in SQL Server 6.5 it is 255. I am not sure about 7.0

If it is not specified it would take the length...

Good Idea. Cool.

Chiris I don't get the solution.

This would not allow more than one 0 in the uniqifier field. There can be one 0 and one 1 and rest will be nulls....

If you use a linked table in Access to the SQL Server table it can be accesses as local Access table. Then you can transfer data from linked table.

INSERT, UPDATE trigger can be used to check the existing values and enforce the rule. If you are updating/Inserting multiple rows use correlated query or cursor. Logic will some thing...

Can we use this to find the error rows

Select DecimalCol FROM Table WHERE DecimalCol > 99.9

Other Transact-SQL statements that can be used with control-of-flow language statements are:

CASE

/*...*/ (Comment)

-- (Comment)

DECLARE @local_variable

EXECUTE

PRINT

RAISERROR

This means you can use these with control-of-flow language...

You can use a INSTEAD OF trigger.

Case is like a function.

Can you please provide a link. My Books onlins says this.

CASE

Evaluates a list of conditions and returns one of multiple possible result expressions.

CASE has...

Oops. I just tested with your query with slight change. Null is implicit I would say. (I removed Else NULL part)

Thank You.

DECLARE @SortTable TABLE

(INTCol INT, VarcharCol VARCHAR(50), DateCol DateTime)

INSERT @SortTable VALUES...