Jump to content

Floetic

Members
  • Content Count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Floetic

  • Rank
    Newbie
  • Birthday 03/28/1986

Contact Methods

  • MSN
    Carla.Pinate@hotmail.co.uk
  • Website URL
    http://undergroundpassion.bebo.com/
  • ICQ
    0

Profile Information

  • Gender
    Male
  • Location
    Belfast, N.I
  1. Floetic

    Complie Error

    Using Microsoft Visual Basic 6.0Microsoft SQL Enterprise Manager 8.0-- Form1.frmOption ExplicitPrivate Sub cmdDone_Click()EndEnd SubPrivate Sub cmdLookUp_Click()If Trim(Text1.Text) <> "" Then Call GetStats Else MsgBox "Please enter a start date", vbExclamation End IfIf Trim(Text2.Text) <> "" Then Call GetStats Else MsgBox "Please enter an end date", vbExclamation End IfEnd SubSub GetStats() Dim strSQL As String Dim rst As ADODB.Recordset strSQL = " CARLA_SEL '" & Text1.Text & "'" & Text2.Text & "'" Call ADO_Query(intCurrentConnection, strSQL, rst) lstInformati
  2. a. Microsoft SQL Enterprise Manager 8.0Console Root > Microsoft SQL Servers > SQL Server Group > BOISSQL (Windows NT) > DatabaseS > BacktraqFMb. I think that I am looking to maybe create an active control in Visual Basic which I can attach to a new sheet in excel so that the results can be brought to the excel sheet once the user has clicked on 'Get stats' button or something like that ... But I havent a clue how to go about doing this and how everything would link up together in order for this to work.
  3. -- (1) Number of calls received for each priority of call [for a specified date range]declare @startdate datetime,@finishdate datetimeselect RM.fldPriorityCode as 'Priority',count(RM.fldRequestID) as 'Calls'from tblRequestMaster RMwhere RM.fldPriorityCode between 1 and 5and RM.fldRequestDate between '01-01-2007' and '03-05-2007'and RM.fldRequestFlag like 'D'group by RM.fldPriorityCode unionselect 'Total' as 'Priority',count(RM.fldRequestID) as 'Calls'from tblRequestMaster RMwhere RM.fldPriorityCode between 1 and 5and RM.fldRequestDate between '01-01-2007' and '03-05-2007'and RM.fldRequestFlag
  4. Floetic

    How To...

    --declare @startdate datetime,--@enddate datetimeselectRM.fldEditedBy as 'User Login',case Grouping(RM.fldPriorityCode)when 0 then RM.fldPriorityCodeelse 'Total' end as 'Priority',count(datediff(day,RM.fldRequestDate,RM.fldComCanDate)) as 'Calls Resolved'from tblRequestMaster RMwhere RM.fldPriorityCode between 1 and 5and RM.fldTrade = 'IT'--and RM.fldRequestDate between '01-01-2007' and '08-05-2007'and RM.fldRequestFlag like 'D'and RM.fldRequestStatus = 'Y' group by RM.fldPriorityCode,RM.fldEditedBy with cubeunion selectRM.fldEditedBy as 'User Login',case Grouping(RM.fldPriorityCode)when 0 the
  5. Floetic

    How To...

    --Gives overall total and a breakdown of the number of calls resolved for each priority by I.T (excluding 3rd parties) declare @startdate datetime,@enddate datetimeselectRM.fldPriorityCode as 'Priority',--RM.fldEditedBy as 'User Login',count(datediff(day,RM.fldRequestDate,RM.fldComCanDate)) as 'Calls Resolved' from tblRequestMaster RMwhere RM.fldPriorityCode between 1 and 5and RM.fldTrade = 'IT'--and RM.fldRequestDate between '01-01-2007' and '08-05-2007'and RM.fldRequestFlag like 'D'and RM.fldRequestStatus = 'Y' group by RM.fldPriorityCodeunion select'Total' as 'Priority',--RM.fldEditedBy as
  6. Floetic

    SQL Query

    Thank you very much Yahweh for your help :)Although I couldn't get it working ~ this seemed to work;declare @startdate datetime,@finishdate datetimeselect RM.fldPriorityCode as 'Priority', sum(case when datediff(day,RM.fldRequestDate,RM.fldComCanDate) <=5 then 1 else 0 end) as 'Closed Calls 0-5 Days', sum(case when datediff(day,RM.fldRequestDate,RM.fldComCanDate) between 6 and 10 then 1 else 0 end) as 'Closed Calls 6-10 Days', sum(case when datediff(day,RM.fldRequestDate,RM.fldComCanDate) >=11 then 1 else 0 end) as 'Closed Ca
  7. Floetic

    SQL Query

    --Number of calls closed in 0-5 days; 6-10; 11+ [for a specified date range]declare @startdate datetime,@finishdate datetimeselect RM.fldPriorityCode as 'Priority',count(datediff(day,RM.fldRequestDate,RM.fldComCanDate)) as 'Closed Calls 0-5'from tblRequestMaster RMwhere RM.fldPriorityCode between 1 and 5and RM.fldRequestDate between '01-01-2007' and '08-05-2007'and RM.fldRequestFlag like 'D'and RM.fldRequestStatus = 'Y' --and datediff(day,RM.fldRequestDate,RM.fldComCanDate) <=5 --and datediff(day,RM.fldRequestDate,RM.fldComCanDate) between 6 and 10and datediff(day,RM.fldRequestDate,RM.fldCo
×
×
  • Create New...