Search Results

Post by: Willi, Dec 3, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Thanks for your Answer! >By any chance, is this an Access database that was 'upgraded' to SQL Server? Yes, i make a Import from Access to SQL...

Post by: Willi, Nov 29, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

<P mce_keep="true">Hello <IMG style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px" alt=""...

Post by: Willi, Nov 28, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

No! But this give me the correct results: SELECT tblAccounts.MemberID, CONVERT(decimal(8, 2), ISNULL(tblMember.Endsaldo, 0)) TheCurrent FROM...

Post by: Willi, Nov 28, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

I'm so sorry, that's my error: WHERE MemberID = MemberID Yes, i use TableAlias in the real Script like this: WHERE TableAlias1.MemberID =...

Post by: Willi, Nov 27, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

Thanks for your Answer! And what can i make when: SELECT MemberID, SomeOtherFields, CONVERT(decimal(8, 2), case when ( SELECT...

Thread by: Willi, Nov 27, 2007, 12 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello! (sorry for my bad English, but i hope, you understand me!) CONVERT(decimal(8, 2), case when ( SELECT COUNT(*) FROM...