First this clause of your statement:

will return more than a single value, this then yieds the error

Msg 512, Level 16,...

Have you searched the Microsoft download site for servers at

http://www.microsoft.com/downloads/Browse.aspx?displaylang=en&productID=261BA873-F3AB-420E-96D6-E3004596A551

For the appropriate Books On Line for 6.5

Is this the error message you get?

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '#'.

If not then please assist others to assist you by following the suggested posting...

Although it is included only for backwards compatibility ... look at the BOL explanation of the syscomments table which contains the text for all stored procedures. True you would...

Wally

Are you sure the data type for the column is TEXT, or is it VARCHAR, or CHAR? I presume that you are not checking for more or less than...

I am sure someone would be able to help you if you posted more information.... Please read the article whose link is in my signature block and follow those instructions...

barathvaj.s

See above - clicked twice on the dang button

barathvaj.s

READ the article whose link is in Lynn Pettis signature block and give us some more information so that we may help you. For example how is the data...

Sabid.m

Use Books On Line (BOL) and read up on the "Openrowset" command. It can be utilized to read from a csv file, an Excel Spread Sheet as well as...

Willkane.accounts

Could you expand the data a bit?

Read the article in my signature block to get an idea of what I mean asking this question.

obarahmeh I created a table as:

CREATE TABLE [dbo].[DTable](

[Dvalue] [numeric](15, 4) NULL,

[Comment] [varchar](50) NULL

) ON [PRIMARY]

END

Entered various values and then used the following T-SQL statement to return the values

SELECT Dvalue AS...

Assuming that the "number" is actually a CHAR or VARCHAR and NOT numeric use the SUBSTRING function for example:

DECLARE @Unk AS VARCHAR(10)

DECLARE @Ans AS VARCHAR(20)

SET @Unk = '14690573010'

SET @Ans =...

Ninja's RGR'us

Notify the 2nd app using the SHELL command for example:

Public Const WIN_NORMAL = 1 'Open Normal

Private Declare Function apiShellExecute Lib...

dr_csharp.

I would use an alternate approach - when App 1 does the insert using either a dynamic sql statement or a parameterized stored procedure with a return value. Then...

If you must use a cursor Refer to books on line for 2 methods:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dataacc9/html/ff404e02-630f-474d-b5d4-06442b756991.htm

Remember a cursor is an agonizing row by agonizing row operation it would be more efficient to...