Edit: Didn't read the round up. Recalculating....

Edit 2: This one works.

declare @tbl table (Val numeric (8,2))

insert into @tbl values (0) -- to 0

insert into @tbl values (1.21) -- to 1.5

insert...

What does the schema of the destination table look like?

You said you had a query to copy the data over. Can you post it?

It has? It's exactly the same error with exactly the same insert statement as I helped...

Can you post the schema of the two tables and the query please?

Correct me if I'm wrong, but hasn't this been asked and answered twice before? (exact same insert statement and exact same error)

http://www.sqlservercentral.com/Forums/FindPost610162.aspx

http://www.sqlservercentral.com/Forums/Topic610173-1291-1.aspx

Did you apply the patch to both the server and the machine you're running the client tools from?

What my colleagues used to do was RD into a...

Great.

If I may suggest...

Evaluate your backup strategy in light of this event.

Set up a job to run checkdb (without...

Here's a query that should work

This will work providing you have no table partitioning. If you do, it may give strange results

select object_name(p.object_id), ds.name as FilegroupName

from sys.partitions...

I'm afraid not. Procedures must be called with the EXEC statement and a view may only contain a single SELECT.

If you need to join the output, you'll have to insert...

Try RAISERROR instead of print.

if @search_type <> 'ausId' and @search_type <> 'email'

begin

RAISERROR ('Search Type...

I'd suggest doing it as one statement. If you do the count first and then the insert, there's a chance that another insert could occur in between and make the...

Sure. It's one of those not-so-intuitive queries (understatement)

This will work providing you have no table partitioning. If you do, it may give strange results

select object_name(p.object_id), ds.name as FilegroupName

...

skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...

For...