I think you simply have to qualify the owner when calling a UDF... however, I never tried to find a way around it, because I do it anyway (even if...

I think Adam's solution is what you are looking for, but you didn't give too many clues to what you'll be doing with the result, what's the data structure and...

Try this... I'll post it along with DDL. I included in the query several columns that are not necessary, but could help you understand how it works. Also, I'm sure...

Just a hint: you can paste a long complicated SQL into the command window of a job step, but it is hard to maintain it. It is much better to...

If you already have the disks, why not use them? Yes, it is overkill, but the DB will probably grow, and also you may need to add other databases later....

Haywood Ja,

yes, I know that my post was partially off topic, it didn't discuss this question precisely (i.e. not including the precise values given in the example) - I simply extrapolated what...

In fact, the entire query is a good example of bad practice (which I think was the reason why we were asked this question)... To avoid confusion originated by rounding, more reliable query...

Hello Karami,

your table is bigger than those I work with (these have max. about 30M rows), but I still think that splitting it into monthly tables is not a good idea....

I would recommend to follow Nick's suggestion and convert it to CASE statement. CASE works very much like IF...ELSE, because it checks the WHEN conditions one by one, in the...

EM tends to have certain problems, like that one with Current Activity... I wasn't able to track down the reason of EM hanging in this case, and so prefer to use...

AFAIK, SQL Server 2000 optimizer takes care of that, and the order of conditions shouldn't affect results. It can make difference whether you put certain table into FROM clause or...

Hello Dan

clustered index means that the actual data are stored ordered by that index - that of course allows only one clustered index per table.

Indexes are helpful when selecting data from tables; during...

kk_Avantel,

AFAIK this only works in SQLS 2000. That's why you don't get the same result as I do.

Richard,

that's strange... however, if the QA is set to show results in Grid,...

Well, you didn't post DDL so I made my own tables and it works fine. The only difference to you desired result is, that the separator (-) appears in front;...

Hello Shankar,

I don't know precisely what your optimization job does - we have several such jobs (indexdefrag, indexrebuild, integrity check). Anyway, most probably you are speaking about the sqlmaint optimization...