update table

set column_A = replace(column_A, '"','')

how about this

select replace(column A, '"','')

I think instead of cast as int you should cast as numeric or decimal.

And in terms of performance?

which is recommended CTEs or Views?

Could you explain the relationship b/w the 3 tables.

How did u get InkID '106'?

What you want as the result is also not clear.

mdouglass (7/25/2008)

---

If I do the following it works perfect on an INSERT.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[TR_Insert_tblSymbolTrackingOld] ON [dbo].[tblSymbolTrackingOld]

FOR INSERT

AS

BEGIN

SET NOCOUNT ON;

SET IDENTITY_INSERT [dbname].[dbo].[tblSymbolTracking] ON;

DECLARE @symbol_id int;

DECLARE @company...

SELECT * FROM [dbo].[tblSymbolTrackingOld]

will insert all records of tblSymbolTrackingOld in tblSymbolTracking every time you insert a record in tblSymbolTrackingOld.

I am not sure if that is what you want.

Why are you setting the Identity Insert On in the trigger.

what exactly is the error that you are getting?

I forgot the basic point-

If you are creating Local temp tables in a stored procedure, the scope for the existence of those temporary tables is only the procedure execution. The...

Fair enough.

Probably if you name the temporary table more meaningfully the probability of you running into the above problem would be a rare.

Anyways I may be wrong.

Let me...

Do you just need the column list from the table #T

If so then see if this query helps you.

SELECT * FROM tempdb.sys.columns

WHERE object_id = (SELECT object_id FROM tempdb.sys.objects WHERE NAME...

Temporary tables get created in tempdb.

Try to access tempdb.dbo.syscolumns and tempdb.dbo.sysobjects

SET @WHERE = @WHERE + ' ADATETIME >= '''+ cast(@STARTDATE as varchar(50)) + ''''

use the above statement instead.