Welsh Corgi

Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 3,738 total)

RE: update 1 col with values of col2 and 3

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,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 1:26 pm

#1427293
RE: update 1 col with values of col2 and 3

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 1:23 pm

#1427292
RE: update 1 col with values of col2 and 3

ChrisM@home (1/1/2012)
stebennettsjb (1/1/2012)
ohh sorry i was using your examples!
read the links when you replied.. Sorry for not adding them before :unsure:
Use single quotes ste (Steve?) - double quotes indicate...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 1:16 pm

#1427290
RE: update 1 col with values of col2 and 3

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 ...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 1:06 pm

#1427288
RE: update 1 col with values of col2 and 3

I'm glad that you got a solution to your problem:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 12:52 pm

#1427287
RE: update 1 col with values of col2 and 3

Sounds like you do not have a col3?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 12:48 pm

#1427286
RE: update 1 col with values of col2 and 3

I need your table structure and sample data.
Please look at the link in my signature block.
:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 12:41 pm

#1427284
RE: update 1 col with values of col2 and 3

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 12:35 pm

#1427282
RE: update 1 col with values of col2 and 3

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 1, 2012 at 11:58 am

#1427277
RE: MSSQL 2008 R2

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 31, 2011 at 11:16 am

#1427240
RE: MSSQL 2008 R2

Ninja's_RGR'us (12/31/2011)
I'd check wait stats and use sp_whoIsActive (a lot more info than sp_whoX)
http://sqlblog.com/files/default.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
Thanks for the link. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 31, 2011 at 11:14 am

#1427239
RE: MSSQL 2008 R2

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 31, 2011 at 10:02 am

#1427227
RE: Primary Keys are necessary for good database design

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 31, 2011 at 9:10 am

#1427225
RE: Get the delta records between 2 tables with same structure

@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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 31, 2011 at 9:04 am

#1427223
RE: Problem with a simple Scalar UDF

Thanks everyone and have a happy and safe New Year. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 31, 2011 at 7:50 am

#1427216

Viewing 15 posts - 1,951 through 1,965 (of 3,738 total)