Tags Tags

Need help with t-sql - need to update a table

January 24th, 2012 - 11:02 am ET by Learner | Report spam
Help Create a new topic
Hi,

I have a scenario where I have sort orders in table for a given
SpecIDs. See below

SpecID SortOrder count
100110 1 6
100159 2 6
100025 3 6
100033 4 6
. 6
6 6

... 1 12
. 2 12
. 3 12
... ... ...
12 12

Now the above sort order need to be changed for the given SpecIDs. So
I need to update the sort order in the table based on the requirement.

As you see I need to update 6 records and 12 records to redefine the
sort orders. I am just thinking to write a script that updates the
table with 12+6 = 19 update statements in it. Is there any other way
to make it look professional?

Thanks,

L
email Follow the discussionReplies 1 replyReplies Make a reply

Similar topics

Replies

#1 Erland Sommarskog
January 24th, 2012 - 04:15 pm ET | Report spam
Learner () writes:
As you see I need to update 6 records and 12 records to redefine the
sort orders. I am just thinking to write a script that updates the
table with 12+6 = 19 update statements in it. Is there any other way
to make it look professional?



Maybe include

1) CREATE TABLE statemets for you tables
2) INSERT statements with sample data
3) The desired result given the sample
4) Which version of SQL Server you are using

would the question look more professional?

Good math would also increase the aura of professionalism.

On the other hand, with some copy-and-paste skills you would construct the
18 update statements while I'm typing this. Which, if this is a one-off,
definitely is as professional as it can get.


Erland Sommarskog, SQL Server MVP,

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sql...14207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sql...95970.aspx
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search