Search Results | SQL Server Performance Forums

Post by: vbjohn, Jan 12, 2007 in forum: SQL Server Reporting Services

Found it..... It is best to have the server do all the work instead of crystal. Reason: 1.) Less time connected to the server 2.) Less memory...

Thread by: vbjohn, Jan 12, 2007, 2 replies, in forum: SQL Server Reporting Services

Which is the best method of generating totals? On the Server in an SQL Statement or In Crystal Reports? Is there any reasons for one or the other?...

Post by: vbjohn, Oct 10, 2005 in forum: General Developer Questions

quote:Originally posted by Adriaan The IF EXISTS (SELECT ...) statement will not work for a dynamic query statement like you tried. You can use...

Thread by: vbjohn, Oct 7, 2005, 3 replies, in forum: General Developer Questions

Can anyone help me figure this out? Why can I not use this variable. I get this error for the second one I try: Server: Msg 170, Level 15, State...

Thread by: vbjohn, Oct 6, 2005, 1 replies, in forum: General Developer Questions

Syntax error converting datetime from character string. DECLARE @NewTransaction AS NVARCHAR(255) DECLARE @curName SYSNAME Select @curName =...

Post by: vbjohn, Oct 6, 2005 in forum: General Developer Questions

Great thanks. Yes I did have a typo...

Thread by: vbjohn, Oct 6, 2005, 2 replies, in forum: General Developer Questions

How can I use data from a SQL Statement in a Stored Procedure and then use it in the same Stored Procedure? SELECT CID, CFNAME, CLNAME, CADDRESS...