Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mharroff

    Using single user entered attribute in where to match one of 4 different columns

    SELECT SPU.id_num , NM.last_name , NM.first_name , SPU.sports_cde , SPU.yr_cde , SPU.trm_cde , CONVERT(VARCHAR, SPU.JOB_TIME, 101) AS LAST_CHANGE , SPU.trm_bk_fall , SPU.trm_bk_wint , SPU.trm_bk_spring ...
  2. mharroff

    Barcodes on a label created with SQL

    For our barcoding needs in SSRS we use NeoDynamics Barcode Professional for SSRS (https://www.neodynamic.com/products/barcode/cri-ssrs-reporting-services/)
  3. mharroff

    Conditional statement built dependent on variable values

    Check these 2 lines and try adding the quotes I put in red set @Conditions = @Conditions + ' WHERE [Company Name] = ''' + @FilterCompany + ''' ' Set @Conditions = @Conditions + 'AND [Syspro Code] = ''' + @FilterSyspro + ''' '
  4. mharroff

    Count if an event occured each day of the year from date ranges

    SELECT t.PatientID, COUNT(DISTINCT d.CalendarDate) FROM Dates d JOIN #Temp t ON d.CalendarDate BETWEEN t.RxFillDate AND DATEADD(DAY,t.DaysSupply -1,t.RXFillDate) WHERE d.CalendarDate >= @StudyStartDate AND d.CalendarDate < @StudyEndDate GROUP BY t.PatientID
  5. mharroff

    IIF Expression with Scope

    Try moving one of your closing parenthesis prior to the comma before "Khaki". =IIF(Fields!SvcDate.Value,"table1_ClientName"=Previous(Fields!SvcDate.Value,"table1_ClientName"), "Khaki", "White")
  6. mharroff

    if statement not working

    Try select @salesrepcode = salesrepcode from orderheader where jobnumber=@jobnumber
  7. mharroff

    SSRS 2005 export to Excel

    I am using SSRS 2005 and have written a report that has groupings that are set to toggle based on clicking a field. When the report is rendered by SSRS the grouping is working as expected. When I try and export the report to Excel and open it I do not have any of the grouping toggles available...
  8. mharroff

    Building array with GetString result

    why not use myArray = rs.GetRows()
  9. mharroff

    Loop help!!

    You need to move this linktoLuniqueID = right(year(now),2)&month(now)&day(now)&hour(now)&minute(now)&second(now) inside the loop
  10. mharroff

    Trying to get rid of un-wanted spaces in name

    What about a simple loop thru each character of your string looking to see if the space is followed by an uppercase letter. If it is then leave the space else delete it. Similar to the following: For p = 1 To Len(tab) If Mid(tab, p, 1) = " " Then If Mid(tab, p + 1,1) >= "A"...
  11. mharroff

    SQL2K Log Shipping between 2 Domains

    Being that these are SBS servers, they are both DCs, so there are no local users. You are correct about not being able to set up trusts between 2 SBS domains.
  12. mharroff

    SQL2K Log Shipping between 2 Domains

    I have a W2k3SBS server (server1) and a W2kSBS server (server2) both running SQL2k. I need to set up log shipping between these servers. I have tried setting up log shipping per MrDenny's FAQ. However, since these are both SBS I can not have them in the same domain and I can not save the...
  13. mharroff

    Looping Issue

    Sorry, that code was for SQL, if you are using Access try this SELECT P.TeamID , Sum(Win)+Sum(Loss)+Sum(Draw) AS Played , Sum(P.Win) AS Wins , Sum(P.Loss) AS Losses , Sum(P.Draw) AS Draws , Sum(P.HomeGoals) AS GF...
  14. mharroff

    Looping Issue

    You can use this query to calculate everything. SELECT T.Name , Sum(Win)+ Sum(Loss) + Sum(Draw) AS Played , Sum(Win) AS Wins , Sum(Loss) AS Losses , Sum(Draw) AS Draws , Sum(HomeGoals) AS GF , Sum(AwayGoals) as GA , Sum(Win) * 3 + Sum(Draw) as POINTS FROM (Select TeamID, Case...
  15. mharroff

    How to use response.write (&quot;eval....&quot;) with sql record

    Why store the quotes in the database? You could just use dim strName strName = request.form("FirstName") response.write (replace(rs.fields("Sentence"),"varFirstName", strName)
  16. mharroff

    Incrementing recordset help

    Oops, strPWChangeDate = FormatDateTime(strChangeDate, vbLongDate) intExpiresIn = PasswordExpiry - intPassAge should be 2 lines like strPWChangeDate = FormatDateTime(strChangeDate, vbLongDate) intExpiresIn = PasswordExpiry - intPassAge
  17. mharroff

    Incrementing recordset help

    Prior to you loop set a variable equal to 0 (eCounter in my example). Within you loop whenever you call SendEmailMessage add 1 to the variable (eCounter = eCounter +1) Also, since the ElseIf are basically identical you can reduce the code like below. eCounter=0 Do Until objRecordSet.EOF...
  18. mharroff

    Excel Series - IP Addresses

    Also you could try ="123.45."&ROW()+600&".0"
  19. mharroff

    Why Are Zero Things Plural?

    Actually " ... no hits, no runs, and no errors" can potentially be said at the end of every half inning so therefore it isn't that rare.
  20. mharroff

    How to select non continuos cells?

    For x = StartCell To EndCell If Range("A" & x) = Criteria Then If Len(strRange) = 0 Then strRange = "A" & x Else strRange = strRange & ",A" & x End If End If Next Range(strRange).Select

Part and Inventory Search

Back
Top