What is the exact error you're getting?

I couldn't try on a linked server, but it worked fine on my local box.

declare @sql varchar(255), @servername varchar(20)

set @servername = @@servername

select...

I don't get it.

936,12, ,985

936,13, ,985

Are you saying that you're getting a result like this, but it's not what you want/need?

If so, why...

Yes..? And what is the question?

/Kenneth

What's with the '/' delimiters and all? You don't need those (in fact you should avoid them always when writing dates, delimiters are only useful for display and formatting).

There's...

You don't really need a UDF for this, creating and populating a calendar table is more of a 'script' job.

You can find a description how to do it here.

http://www.aspfaq.com/show.asp?id=2519

/Kenneth

Then do as Jeff says, and make that column a computed column.

/Kenneth

The 'some' requirements in your case, is that you have aggregates in your select. (SUM, MAX, MIN etc)

If you have aggregates, then all non-aggregated columns must be GROUPED BY

A workaround...

You don't have to post the structure with the actual names, or the actual data, if it's sensitive. You may change names, and/or make up some data that behaves in the...

Can you provide a sample script of the tables and some sample data that reproduces your problem with the query? It's pretty hard to just guess without the 'hard facts'...

Not really.

However, if it's a 'standard' installation of SQL Server, and you have access to an NT account that is Local Admin on that computer, you can try to do...

What does your data look like if you just select D.PY and W.PY instead of calculating the percentage? You say in your calculation that if either is 0, then it...

Have a look in BOL (Books on Line). Plenty of examples in there along with other useful info as well.

/Kenneth

The decrease in performance is probably because of the OR in the join.

If you have opportunity to look at the plan, I'd guess that you'd find a *huge* worktable the...

Don't forget the flip side of the coin, performance isnt' all. Integrity is even more important.

Consider that when you've split what logically belongs into a single db into more than...

Just be aware that weeknumbers are slippery devils, and not globally the same if you don't know to which international standard, or calendar the specified number applies.

In my calendar week #1...