No way to tell from the information provided. Do you need all the joins? How many rows in the main table? It's possible you could carve the...

Sid Childers (4/29/2010)

---

Garadin (4/29/2010)

---

Sid Childers (4/29/2010)

---

This client is stuck on ASP.NET 2.0, unwilling to consider 3.5/dynamic data because he feels that 2.0 can do the job. I'm afraid it...

Sid Childers (4/29/2010)

---

This client is stuck on ASP.NET 2.0, unwilling to consider 3.5/dynamic data because he feels that 2.0 can do the job. I'm afraid it will be a...

Refactoring that query a little bit:

;WITH

T1 (Table1Columns) AS

(SELECT name FROM DB1.dbo.syscolumns WHERE OBJECT_NAME(id)='Table1'),

T2 (Table2Columns) AS

(SELECT name FROM DB2.dbo.syscolumns WHERE OBJECT_NAME(id)='Table2')

SELECT *

FROM T1

FULL OUTER JOIN T2 ON...

You could probably improve it by actually making it dynamic =). Did they give you a reason they don't want data driven pages?

It's 2K =)

By "moved", you mean manually deleted and hard coded into the other page?

The hidden values need to match the values you want sent to the DB.

Can you give an actual...

Does oracle handle schemas the same way as MS SQL? (Totally clueless about all things oracle)

The other option to try might be:

select * from myLinkedServer...[mySchema.myTable]

How about a function that goes in a utility database. That way you can just recreate the utility database when you upgrade the server and don't have to worry...

Two words. "Lookup Tables".

As an example: Instead of that long case statement for sce_sclc, create a table in your database with 2 columns, such as sce_sclc and...

It doesn't really work that way. You don't 'read' objects like that from SQL Server, you use the .NET page to send the data to the SQL Server and...

As Lowell said, providing the code will allow us to help you refactor it or tell you a better way to go... but barring that:

You can't use variables in a...

Why are you against using a function?

You *may*, emphasis on *may* get better performance creating a bulk staging table where you copy all the data into... then create indexes on it, and run your queries off...

How much data?

How often does it change?

Is a snapshot ok?

Are all the tables identical schema wise?