Per Microsoft - (http://www.microsoft.com/sql/howtobuy/faq.mspx), there is no concurrent licensing for SQL server. CAL's are to be acquired for every "direct and indirect user of SQL Server" (meaning - end...

Well - you're going to be running into some serious compromises. For one - "30 100-character fields" sounds like someone's being sloppy/lazy with giving you the right specifications. ...

You have to prevent totsum from being 0, since that is what is causing your divide by zero #ERROR's.

If you want that to evaluate to 0 then try:

=iif(sum(Fields!Deqsum.Value) =...

Agreed that you summed it up fairly well, under the assumption that you are looking that the asynchronous versions of those. Anything synchronous would have a "risk" attached to...

Assuming you want a random sampling:

declare @n int

set @n=100

select t.* from

(select *, row_number() over (Order by newID() ) as 'ranknumber' from table1) t

where ranknumber%@n=0

Or...(in the case one out...

SELECT ACCT,

sum(case when Substr(DVC_TYPE,1,2)='SM' then 1 else 0 end) as smallcount,

...

Unless you're an Application Server Host, why would you ever need multipl versions of the same data out there?

Now - if you ARE an application server host, and you need...

The issue is that you're throwing a varchar into the ELSE clause (''). That won't implicit convert to a MONEY value. So - switch the ELSE portion to...

AFAIK, this usually happens when some process OUTSIDE of the cursor deletes a row in the table the cursor is based on.

So - if job 1 opens a cursor...

There's already a system function for that: RAND().

A few things about rand():

- RAND() will generate a random number between 0 and 1, so if you want "bigger numbers,...

If the view is too cumbersome - then put the computed column in the actual table definition, and index based on that. That's what I was actually supporting (not...

Agreed - the function in the ON clause will force a table scan. Split the calculation out to a computed columns, then index the new computed column, and join...

well - you can convert them all to upper case during the grouping. You're already hurting performance with the function in the group by, so it might not stay...

Isn't that what his example is showing? gaps in prio by id?

Lee - process looks fine. You will still need to deal with reorganizing the data so that you don't have page fragments everywhere, and then shrink the database.