Viewing 15 posts - 14,986 through 15,000 (of 18,923 total)
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...
July 14, 2005 at 10:14 am
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.
July 14, 2005 at 9:35 am
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...
July 14, 2005 at 9:27 am
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...
July 14, 2005 at 9:19 am
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...
July 14, 2005 at 9:10 am
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...
July 14, 2005 at 9:08 am
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(...
July 14, 2005 at 9:05 am
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)?
July 14, 2005 at 8:42 am
Prove him wrong
.
Select @@version
what's the compatibility level?
July 14, 2005 at 8:40 am
Viewing 15 posts - 14,986 through 15,000 (of 18,923 total)