What would be an example value that you are passing the function? The first thing that I notice is that your prefix variable allows up to eight characters. ...

Can you just query the data that is bigger than 1.3 like the code below or are you trying to loop to perform some other logic?

IF EXISTS (select * from...

Make sure to check for the table in the tempdb. The following code should work.

if OBJECT_ID('tempdb..#TCompanyNames', 'U') is not null

print 'table exists'

else

print 'table does not exists'

You should be able to simplify the query using the ISNULL and COALESCE functions.

SELECT UIC,

TAMCN,

...

I just wanted to clarify that you need to specify the table name and the schema name in two...

Ahh. My mistake. Thats what I get for reading too fast.

You can use INFORMATION_SCHEMA.COLUMNS. You may need to add a schema filter also if you have the same table in multiple schemas.

select * from INFORMATION_SCHEMA.COLUMNS

Where TABLE_NAME = 'Put Table...

I am using feedreader, and they are working fine for me. Here is one of the URLs I am using. Try this in Google and see if it...

Yes. You can find the features by edition here.

Features Supported by the Editions of SQL Server 2005

Jonathan Kehayias has some good information here

How to Automate Common DBA Tasks

Specifically look at

Configuring SQL Server 2000 Notification with CDOSys and Monitor the SQL Server Error Log

I have personally used...

You can use the Reverse Function to find the last occurrance.

Declare @FieldA varchar(100)

Set @FieldA = 'DirectoryA\DirectoryB\DirectoryC\FileName'

Select Substring(@FieldA,

...

You could do something like this...

Select dateadd(m,1,cast(STUFF('0309',3,0,'/01/') as datetime))-1

Just replace the '0309' with your field name.

You would have to clear it for each plan handle that had the table name in the plan. The article on msdn has a good example for a specific...

I think we were also trying to run the update based on the wrong key.

update co_customer_x_address

set cxa_on_hold_flag = '1'

Where cxa_cst_key IN (Select cxa_cst_key FROM co_customer_x_address WHERE cxa_on_hold_flag = '1')

Can you provide some sample data? First show how it currently looks and then show how you would like it to look after the update.