ChrisM@home (1/1/2012)

---

UPDATE Mytable SET col3 = col1 + " ," + col2

If col1 or col2 are a numeric datatype, I'd explicitly cast.

If either col1 or col2 are nullable,...

stebennettsjb (1/1/2012)

---

Hi Chris,

Thats got it working! thank you,

Welsh Corgi sorry for not explaining myself very well, I shall follow your links guide from now on.. Your free to breath...

ChrisM@home (1/1/2012)

---

Use single quotes ste (Steve?) - double quotes indicate...

stebennettsjb (1/1/2012)

---

Thanks Welsh Corgi!

Thanks for creating the test table..

Im trying to get col 3 to be

Col1 COL2 COL3

1 ...

I'm glad that you got a solution to your problem:-)

Sounds like you do not have a col3?

I need your table structure and sample data.

Please look at the link in my signature block.

:w00t:

CREATE TABLE UpdateColVar

(Col1 INT NOT NULL,

COL2 INT NOT NULL,

COL3 INT NULL)

GO

INSERT INTO UpdateColVar (Col1, COL2)

SELECT 1,2

UNION ALL

SELECT 2,3

GO

SELECT Col1, COL2, Col1 + COl2 AS Col3

FROM UpdateColVar

Please provide your...

stebennettsjb (1/1/2012)

---

Hi all,

simple one for you experts im sure. I have a table with values in col1 and col2

I want to put both values into a new col with...

GilaMonster (12/31/2011)

---

If the system in general is slow, I'd start here.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Btw, what business does an app have for pulling 18 000 records down? No one is ever going to read...

Thanks for the link. 🙂

Is the problem isolated to one or more tables?

What happens is you log onto the Server?

Have you looked at task manager, Select run 'taskmgr' on the Server.

How about the SQL...

CELKO (12/24/2011)

---

Please read a book on the Relational model. No table should have an IDENTITY column; it is a locator and not an attribute of the entities in the data...

@Drew,

You probably already know this but you can get a SQL Server 2008 R2 Developer Edition for under $50 USD.

I recently purchased it from Amazon. I have a 30 credit...

Thanks everyone and have a happy and safe New Year. 🙂