Either create a table with the number of days per month, or a CTE at the beginning of the query, or use a calendar table. Then you can use...

What tool(s) are you using for the import? Just the import/export wizard in managment studio? Something else?

I'm afraid I don't understand what you're asking. Can you clarify a bit, please? Perhaps the table structure, and your query as it currently exits, and what you...

I get zero. Zero time, zero money. If I were to go to PASS, for example, I'd have to pay my own way and take it out of...

So add getdate or @@dbts or some such to the checksum. Then you get a different sequence each time.

Still simpler than the loops and such.

And still doesn't actually do...

The numbers aren't random. The sequence is semi-random, but the numbers are 0-99, inclusive.

If you really want 0-99 in a semi-random sequence, it would be much easier to do...

IsNull or Coalesce are the commands for that kind of thing:

UPDATE PRO

SET Prokw2=

CASE

...

Sorry, misread your post the first time.

No, I don't believe there is an option for that. Not in Management Studio anyway. Might be something in one of the...

Now that you mention that, Gail, I have read that before.

Haven't had to play with clustered servers yet, so didn't think of it. Not sure I would have connected...

Is the SQL Server Browser service running?

There are several third-party products that have that kind of thing. I think RedGate has one, pretty sure ApexSQL has one.

It's been a while since I hand-wrote a hyperlink but it goes something like this:

select '[a href="' + URL + '"' + Title + ']'

from table

(Use carrets where I've got...

I usually takes less than a second.

Kill them one at a time.

Or write a script like:

Kill 1;

Kill 2;

Kill 3;

and then run it all at once.

My dad claims he has infinite-capacity, instantaneous, write-only storage in his brain.