Gail.

I changes it though management studio GUI. Does it matter?

Got it.

IF OBJECT_ID('tempdb.dbo.#HoldDate') IS NOT NULL

BEGIN

DROP TABLE #HoldData;

END

GO

Create table #HoldDate(DateStamp varchar(10))

Go

Thanks Gail.

Thanks Gail/Jack for your inputs. So where should my CREATE TABLE code will go

Create table #HoldDate(

DateStamp varchar(10))

? After Drop table? Outside BEGIN END or inside?

Thanks a lot Bru, it worked. Now one more question. Since I just need date in 'dd/mm/yyyy' format should i use varchar(10) instead of smalldatetime?

Hey folks,

So seems like I found the problem, when I write the following SQL I get value

select @ColTypeYesterday = (ColType)

from TotalColumn

where captureddate = (select top 1 capturedDate from TotalDatabase...

SSCrazy Eights for you input. Yes I’ll need to perform this procedure at the end of every month. Move data to text files and purge data from database. As you’ve...

Thanks a lot bru for your input. I've resolve the problem by making all the data types same in Temp and permanent table.

Hey guys, Nevermind I’ve able to write a select and join sys.object with sys.columns and accomplished what I needed. For reference here is my code.

sp_msForEachdb

'select

''?'',

obj.name as TableName,

col.name...

Thank you so much guy for your replies to solve my problem and I learned from my mistake.

Many Thanks again for showing me correct way.

YOU ALL ARE BEST.

Thanks a lot guys for your input. Yes the problem was varchar length. When i defined the table as follows everything worked. Once again Thanks,

Create Table #TempTotalTable(

DBname varchar(100),

TBId nchar(100),

TBName varchar(500),

CapturedDate...

Thanks a lot Lowell for your help. Yes you got it exactly what i wanted to do. This is such a great great example and I learn from it. Now...

SSCrazy Elights I apologize for not providing the full information.

Grasshopper thanks for you input and yes I understand my mistake.

I'm trying to learn and wasn't sure about what difference...

Thanks again SSCertifiable. It will be my rule from now to use print. This is first time I'm using SQL Server that's why tying to understand it as much &...

So here is my code if still people don’t understand what I am tying to do. The only catch is I changes @AD_TransactionErrorAuditSeqNum varchar(40) from varchar(30). This is another way...

Thanks SSCertifiable for you suggestion. Full points to you. It worked. Also I hope for those who don't understand what I'm doing they need to work on their clearance level.