I'm not sure if it's something relevant but I made up a test for speed performance between the two solutions and a direct comparison. Turned out (as I expected) that...

That's why I recommended the Splitter. It gives a much simpler and more understandable code.

I could help with the code, but Asiti should read the articles first.

For up to 4 subjects, the solution given will work.

For more subjects, you should take a look at Jeff Moden's article for the 8k Splitter[/url] and Cross Tabs 1[/url] and...

There's no need to create a view. You'll end up with millions of views that you won't use.

You need to specify the complete query, not just the join. Something like...

I'll stay with Paul stating that any new laptop can support the client.

However, you might need to consider your connection speed. That can cause troubles as well.

A simple trick.

SELECT JavaRecords, JavaCount

FROM (

SELECT COUNT(tem.ComputerName) AS JavaRecords FROM (SELECT ComputerName FROM v_Java2345 UNION SELECT ComputerName FROM v_Java67) as tem) A

CROSS JOIN (

SELECT COUNT(*) AS JavaCount FROM

dbo.v_Java67 j1 WHERE...

There's a problem with the quirky update posted here (as far as I remember).

You're mssing the clustered index. You must ensure that you have it.

For the concurrency problem, you can...

Using the information given you can do something like this

SELECT *

FROM OneDatabase.dbo.EmployeeLocation el

JOIN SomeDatabase.dbo.Location l ON el.locationcode = l.locationcode

JOIN AnotherDatabase.dbo.Employee e ON el.employeeID = e.employeeID

...

Take a look at these articles:

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

deepeshdhake (10/19/2012)

---

Hello,

Using the table EmpHistory, it is not satisfying all the rules. So I want to use this function as it satisfies all the rules. This is what I want:

I...

I'm not sure that I can help you, because I'm not sure of what you want.

If the TVF gives the same result as the table, why won't you use the...

If you just...

Thank you for your responses, I will check on these and choose a way to do it.

Now I have several options and need to see which fits better to this.

Right after posting, I found this (made for 2005 but worked on 2008)

http://blog.sqlauthority.com/2008/01/03/sql-server-2005-last-ran-query-recently-ran-query/

However, other options are welcome.

Jeff Moden (10/18/2012)

---

You will need to "unpivot" or "uncrosstab" the data so that it's in a vertical format and then "repivot" or "recrosstab" to the desired layout.

For coded...