That's the down side of the ADP. You have 1 global connection (good) but it's always opened. So you should expect to have 50-100 connections at all times...

http://msdn.microsoft.com/library/?url=/library/en-us/tsqlref/ts_sp_adda_4ld5.asp

Can you post each table definition with some sample data and the exepected results of this work.. I don't have enough information to give you a definitive answer.

Alright, HTH.

Either way.. where do I sign ??

I'm not sure what you are talking about... what do you want to do with the connection, the recordset (1 form or multiple). What re-use did you want to...

Performance hit to join : yes. But if it rarely happens it might not be a factor. The big table problems is that the server must read all...

SP3a is 8.00.760 you're late .

Probabely. But I "invented" this trick in access. I never used the reporting services so I'm out of my league here. Hopefully a better expert will be able...

SELECT Name, Code, (Basic*10) as Total FROM SALARIES WHERE Basic*10 > 1000

You can resuse the alias only in the order by.. otherwise you must reuse the expression needed to create...

Hey you asked for it .

IF EXISTS( SELECT * FROM dbo.sysobjects WHERE id = object_id( N'dbo.ReplaceSpecialCharacter2000') and XType = 'FN')

DROP FUNCTION dbo.ReplaceSpecialCharacter2000

GO

IF EXISTS(...

Check the not exists too compared to the left join.

It's hard to comment on that without knowing what the fields really mean. Can you explain why you think you should split the table like that (if at all)?

Prove him wrong .

Select @@version

what's the compatibility level?

HTH.