Prakash:

For this particular problem it is critical to know which version of SQL Server you are using. If you are using SQL Server 2005 the "easiest" solution is to...

Mark:

I would suggest that you start by giving a look at the UPDATE article in books online.

I have learned a good bit and continue to learn from Jacob in the MSDN SQL XML forum. Also, I have read and benefited from a few of his...

Bob:

I think you are getting there. 🙂

I see a couple of things to consider. First, in your initial post you talked about creating a stored procedure out of...

Well said, Adam; thak you for picking me up on this. 🙂

Bob:

What I see in your description of the problems is

1. You identified a process that you can apply to a table to identify source data

2....

Rollback on a TRUNCATE TABLE command works on both SQL Server 2000 and SQL Server 2005. For example:

use tempdb

go

create table dbo.testor(id integer identity)

insert into testor default values

insert into testor...

One method might be something like:

declare @prod table (pid int, name varchar(10))

insert into @prod values (1,'prod1')

insert into @prod values (2,'prod2')

declare @prod_desc table (pid int, pdesc varchar(500))

insert into @prod_desc values...

Alex:

I can see pieces of what you are trying to do; however, to me it is not clear how you are trying to use the substring function. I need...

You might be able to start with something similar to:

declare @test-2 table(Name varchar(15))

insert into @test-2

select 'smith, john' union all select 'doe, john'

select

Name,

substring(name,...

If you need stuff that is nearly that huge you might try DECIMAL(38):

declare @what table (x decimal(38) identity(10000000000000000000000000000000000000, 1))

insert into @what default values

select * from @what

/* -------- Sample Output:...

This might eliminate the "different nut" probably; however, as before I am still not sure that Peso's pont isn't valid and you might be forced to perform the self-join. ...

This version avoids the self join but I am not sure if it is as good:

select

name

from

( select

name,

sequence,

...

Main:

I am a bit shaky on this, but this is what I came up with for a first pass:

declare @fruit table

( region integer,

name varchar(9),

sequence integer,

...

I looked in this forum and saw this post and the previous post and noted that I answered both of these posts in the MSDN Transact SQL Forum. I...