Viewing 15 posts - 2,851 through 2,865 (of 3,543 total)
DECLARE @rval int
EXEC @rval = sp_helprotect @username=@UserName
@rval will be 0 if worked otherwise 1
December 24, 2003 at 3:39 am
SUM(CASE WHEN cbostatus <> 'closed' THEN 1 ELSE 0 END) as [Num Requests Open]
Will give you the count of open requests
December 24, 2003 at 3:20 am
I'm getting confused on what the problem is now. This query is based on your original plus 'All' in front of Team for Team totals and the data is ordered...
December 23, 2003 at 10:43 am
Try this
select case when (GROUPING(ddtreasuryteam) = 1) THEN 'All Requests'
ELSE isnull(ddtreasuryteam, 'n/a') END as Team,
case when (GROUPING(CBOSTATUS) = 1) THEN 'Total Received'
else...
December 23, 2003 at 9:15 am
Try changing the first part of the select to
select case when (GROUPING(ddtreasuryteam) = 1) THEN 'All Requests'
else isnull(case when (GROUPING(CBOSTATUS) = 1) THEN 'All...
December 23, 2003 at 3:31 am
quote:
If possible I would avoid using the ADO Command.Refresh statement because it has a noticeable performance hit.
December 23, 2003 at 2:22 am
When designing a table, if a column is going to contain a date then I automatically make it datetime. There are a lot of pros and cons on what dataype...
December 23, 2003 at 2:17 am
It is the RETURN value of the stored procedure. Every SQL Server stored procedure has this parameter (whether it is explicitly used or not).
December 22, 2003 at 5:28 am
If you want to remove the time portion from input dates then cast them to varchar(11). Is this the whole procedure? The reason I ask is that I question the...
December 22, 2003 at 2:47 am
The problem is that your table names are in a table and that is why you are using cursors.
How many 'Volume_Control.tblFilenames_' tables are there and what size are they (rows)....
December 19, 2003 at 8:08 am
Change the cursor2 declare to this
declare @sql nvarchar(4000)
set @sql = '
DECLARE cursor2 CURSOR
GLOBAL
DYNAMIC
FOR
SELECT sum(file_size_bytes) , Lseries from ' + @filename + ' group...
December 19, 2003 at 6:33 am
Ah! Thought so when I looked at the code as it did not look like traditional sql server.
Unfortunately I have not used Oracle and cannot help you, maybe someone else...
December 19, 2003 at 2:29 am
Could use fso but would have to trap errors
DECLARE @fso int
DECLARE @hr int
DECLARE @file int
DECLARE @iomode int
DECLARE @filename varchar(255)
SET @filename...
December 18, 2003 at 10:15 am
Sorry xp_fileexist will only wait if file is being written too not copied.
Could write your own extended procedure.
Edited by - davidburrows on 12/18/2003 07:02:07 AM
December 18, 2003 at 7:00 am
Viewing 15 posts - 2,851 through 2,865 (of 3,543 total)