There seems to be something missing in your description unless you just want to insert a new record to the Position table with no PositionName when you insert a candidate.

From the original post it looks as though he wants the values concatenated with a ',' instead of just a sum. Otherwise it would be too easy. 😉

You have 87 unique values, not 87...

I know nothing about iBase but this would be enough to tell me...

isn't sp_textcopy an old sproc used to access textxopy? I believe that was removed from sql server after version 7.

Check out the OPENROWSET function. I did something similair to this a long time ago. :w00t:

Try something like:

DECLARE @CurrentDate datetime

DECLARE @TimeElapsed int

DECLARE @RemainingTime datetime

SET @TimeElapsed = 360 --converted from hh:mm to minutes

SET @CurrentDate = '2009-04-14 10:00:00.000'

SELECT @RemainingTime = dateadd(n, -1 * @TimeElapsed, @CurrentDate)

Sean

INSERT INTO TABLE1 (

Version

, Type

, Name

, Description

, Category

)

SELECT

Version = 1

, Type = 2

, Name = t.name

, Description = t.description

, Category = t.category

)

...

Are you sure the issue is because it is 64bit? Are you doing some sort of check to make sure there is a '.' in the field?

I assume the query...

Be VERY careful if you use Instead of triggers. I worked for client that put lots of business logic in a Instead of Insert trigger. We encountered an issue when...

A few years ago I worked as a consultant for a large firm that did all their development in house. The enterprise application was massive. It spanned 3 separate databases...

Aggregate columns get no column name unless you alias it. Do something like this:

Select SocialSecurityNumber, ClearedDate, [Type], DDS, Count(*) as TotalCleared

HTH

Sean

Start with your original code.

Remove the TotalCleared column from your temp table.

instead of :

declare @cnt int

select @cnt=count(*) from #temp

update #temp set TotalCleared = @cnt

select * from...

Oh I see what you did. You should put all the inserts back to the original. The only change should be at the end.

josephptran2002 (4/9/2009)

---

Hello Slange,

declare @cnt int

select @cnt=count(*) from...

Can you post the new code? I tested the code i put it up and it works fine. 😉