Recent content by mharroff

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 ...

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

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 + ''' '

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

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")

Try select @salesrepcode = salesrepcode from orderheader where jobnumber=@jobnumber

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...

why not use myArray = rs.GetRows()

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

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"...

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.

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...

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...

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...

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)