Perfectly do-able without a cursor then:

Select

  accountno,

  unamefull,

  CASE

     WHEN uactequiv BETWEEN 1 AND 19 THEN 25   -- add points for uactequiv value

     WHEN uactequiv BETWEEN 20 AND 21...

You are doing too many sub-queries in the SELECT portion (forcing them to be resolved for each row) instead of doing them in the FROM section as virtual tables, where...

Here's an example. Note, I'm not saying there aren't SQL alternatives, but this is a current implementation:

Problem. Person has 1 or more bank accounts at 1 or more branches. For...

25000 results is practically unusable to any user. Maybe you should place a limit on the rows returned, which, if exceeded gives a warning of "There were more rows returned...

You have a UI that displays all 25,000 clients to the user in some sort of user-selectable grid or list ? How can "all" be selected ?

I think maybe the...

You need 1 of these (called "Text File (Source)" in the DTS Connections toolbox) as the data source:

[Picture removed, it was a local filesystem link]

Then set the properties to comma...

http://www.sommarskog.se/arrays-in-sql.html

Since my production Sql Server code (and the probability of my posterior unit taking a serious thrashing from my boss) depend on this, I investigated more.

See this microsoft newsgroup thread...

The only problem being, of course, the 8000 char limit on the ctext column, and that fact that large stored procedures get broken up into multilpe syscomments records. If you're...

Remember, though, that when you add/rebuild a clustered index, ALL the other indexes get rebuilt at that time, so in order to avoid a huge performance hit, you should drop...

FillFactor only applies to indexes. So for a table with no clustered index, the table data pages aren't affected as you've seen. If you create a clustered index with fillfactor...

Thanks for the reply! Regarding this:

>>But this isn't true only on SELECT INTO -- it's also true if you create the table first and insert into it with an ORDER...

Do you have a clustered index on the table, and if so, did you set the fillfactor on it also ? What is the rowsize of the table ?

So you don't have control over the table design, and can't make the column nullable with no default ?

Your trigger code looks like it only works for singleton insertions of...

>>Have you considered making SQL Team's MVP Rob Volk aware of it?

Actually, the way I read it, it looks like it was Adam Machanic's error - he attempted to...