September 24, 2011 at 2:34 pm
Hi everyone,
I am new in sql server and I am using SQL SERVER 2005 WITH svc 4 iNSTALLED ON IT.
I have database called Bholenath, and Bholenath have one table called item and In the Item table I have two column
Means both column are in the same table of same dB
ITEM TABLE has 14000 rows AND MANY COLUMNS with information(VALUE)
first column name DESCRIPTION (nvarchar) ALL THE ROWS WITH VALUE and
second column name is EXTENDEDDESCRIPTION (ntext) some rows has VALUE which i want KEEP and merge additional value from DESCRIPTION column without changing value of DESCRIPTION COLUMN.
In short i want to merge value from DESCRIPTION(nvarchar) COLUMN to EXTENDEDDESCRIPTION(ntext) column
EACH ROW HAS PRODUCTS INFO LIKE UPC,PRICE,LAST PRICE,SUPPLIER, QTY, SO I WANT TO MAKE SURE THAT WHEN WE COPY HAS TO BE SAME ROW FROM DESCRIPTION TO EXTENDEDDESCRIPTION.
PLEASE HELP ME ON THIS. THANK YOU IN ADVANCE
September 24, 2011 at 6:32 pm
If you have this table:
create table mytable
( mychar nvarchar(4000)
, mytext ntext
)
then I can do this:
UPDATE dbo.mytable
SET mytext = mychar + CAST( mytext AS NVARCHAR(MAX))
That will concatenate the values of the tables. You can't do this with text/ntext, but you can cast it. FYI, you should not have text columns anymore. SQL 2005 supports varchar(max) and you ought to convert your columns to this type (or nvarchar(max))
September 24, 2011 at 7:54 pm
Hi Mr. Jones,
Thank You very much for quick reply.
Yes I have change EXTENDEDDESCRIPTION (NVARCHAR(MAX) USING SQL Server Management Studio
Now I need to copy all the value from DESCRIPTION(nvarchar) column to EXTENDEDDESCRIPTION(nvarchar (Max) in the same table and same database.
My DB name is BHOLENATH
my table name is ITEM
My ONE column name is DESCRIPTION (I want to copy all value from this column to EXTENDEDDESCRIPTION)
My second column name is EXTENDEDDESCRIPTION (this column currently has some value and I want to keep that value and more add from DESCRIPTION column.
Thank you Mr. Jones for your help.
September 26, 2011 at 3:03 am
grahamrd (9/24/2011)
Hi Mr. Jones,Thank You very much for quick reply.
Yes I have change EXTENDEDDESCRIPTION (NVARCHAR(MAX) USING SQL Server Management Studio
Now I need to copy all the value from DESCRIPTION(nvarchar) column to EXTENDEDDESCRIPTION(nvarchar (Max) in the same table and same database.
My DB name is BHOLENATH
my table name is ITEM
My ONE column name is DESCRIPTION (I want to copy all value from this column to EXTENDEDDESCRIPTION)
My second column name is EXTENDEDDESCRIPTION (this column currently has some value and I want to keep that value and more add from DESCRIPTION column.
Thank you Mr. Jones for your help.
USE BHOLENATH
UPDATE ITEM
SET EXTENDEDDESCRIPTION = CONVERT(NTEXT, NULLIF(LTRIM(RTRIM(ISNULL(CONVERT(NVARCHAR(MAX), EXTENDEDDESCRIPTION) + ' ', '') + ISNULL(DESCRIPTION, ''))), ''))
Make sure you understand what it is doing before using it.
--EDIT--
In your OP, you said that EXTENDEDDESCRIPTION was NTEXT. I've noticed in your second post you've said it is NVARCHAR(MAX), which post is correct? It changes the answer slightly because NTEXT is incompatible with + operations which is why I first had to convert it to NVARCHAR before converting the concatenated string back to NTEXT.
September 26, 2011 at 1:03 pm
Thank you Cadavre,
Your query is work very good and it's did what i want thank you very much:kiss:
I went to many forums spent about ten days but I can not find the right query but here in this forums I got very quick reply which does
work.
I really appreciate your on the time help . you are so gooood.
All I did is copy your query and paste in my query windows and it's work like a charm, great job. you are really helpful for my kind of NEWBIES who do not know even how to type a query, and you gave me exactly code which made my life lot easier, I am learning SQL
But your kind of people in the world who love to help newbies, which help us to learn fast, WE APPRECIATE VERY MUCH.
Thank You Very Much.
grahamrd.
September 27, 2011 at 3:46 am
grahamrd (9/26/2011)
Thank you Cadavre,Your query is work very good and it's did what i want thank you very much:kiss:
I went to many forums spent about ten days but I can not find the right query but here in this forums I got very quick reply which does
work.
I really appreciate your on the time help . you are so gooood.
All I did is copy your query and paste in my query windows and it's work like a charm, great job. you are really helpful for my kind of NEWBIES who do not know even how to type a query, and you gave me exactly code which made my life lot easier, I am learning SQL
But your kind of people in the world who love to help newbies, which help us to learn fast, WE APPRECIATE VERY MUCH.
Thank You Very Much.
grahamrd.
No problems, glad it helped.
Did you understand what it was doing before you executed it?
September 29, 2011 at 9:26 am
Hi Cadavre,
Yes I understand and I was working on different computer then SQL server is installed means offline database.
But everything workout very good, ones again thanks to you.
grahamrd
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply