Search results for query: *

Is there a way to set a parameter and only type in part of the word? Below is what I currently have: {?Recruiter} = "All" or {Command.FullName} like {?Recruiter} I am entering Recruiter as: 'Amb%' I am using like because one might not know the full/correct spelling of the recruiter name so...

I am struggling with the "Incorrect syntax near the keyword 'UNION'" in the below code. Could someone please tell me what I am doing wrong in the below code: DECLARE @StartDate datetime SET @StartDate = '2008-1-1' DECLARE @EndDate datetime SET @EndDate = '2008-1-31' Create table...

Does anyone know how to print a value as a column heading in the report? Here is the data I am pulling: [Week1] = sum( case when DATEPART(ww, weekending) = 1 then isnull( e.AllTCHours, 0) else 0 end ), [Week2] = sum( case when DATEPART(ww, weekending) = 2 then isnull( e.AllTCHours, 0) else...

What I need to accomplis is: 1- get all candidates who has at least 90-180 days between startdate and @quarter: declare @quarterstart datetime SET @quarterstart = '4/1/2009' Create table #candidates (candidateid int, indentificationdetails nvarchar(50), firstname nvarchar(50), lastname...

Below is the current code I have summing data based on a month, how can I get it to be broken down by week? Here is the code: [Jan] = sum( case when Month( WeekEnding) = 1 then isnull( e.AllTCHours, 0) else 0 end ), [Feb] = sum( case when Month( WeekEnding) = 2 then isnull( e.AllTCHours...

I am trying to create a or statement and what I have is a case statement to handle the 2nd half of it. This is what I need to accomplish: anyone who has at least 90 days of employment between their earliest start date of all of their jobs, and their latest end date of any of their jobs (or the...

I have the below code: --build our data for each profit center: INSERT INTO #profitCenterSummary(profitCenterId,workperiodnum, fiscalyear, tempsonstreet, clients, totalhrs, reghrs,otherhrs,avgpayrate,avgbillrate, fulltimeeqiv, avgtothrs, avgreghrs, aveotherhrs, markuppct...

I have the below code and it is not giving me the correct return value: DECLARE @PeriodStartDate datetime DECLARE @LastYTD datetime DECLARE @EndDate datetime SET @EndDate = '2009-2-15' select @PeriodStartDate = StartDate from FiscalWeekMap where EndDate = @EndDate SELECT @LastYTD =...

What am I doing wrong in the below codeto generate the error below. I added the open and close parentheses, but that didn't fix it: Incorrect syntax near the keyword 'if' Create PROCEDURE WeekEnding ( @endDate datetime, @weekEndingDate datetime OUTPUT, @WorkWeek int OUTPUT ) AS if @endDate...

I am creating a report and need to pull all active employees whose startdate is at least 90 days prior to the first day of each quarter (1/1, 4/1, ect.) and the enddate is null. Please advise! Thanks a bunch!! -T

Is this Case Statement written correctly: 'AvgPayRate' = Case when sum(isnull(o.pay,0)) = 0 then 0 when sum (isnull(o.totalhours,0)) = 0 then 0 else sum(isnull(o.pay,0))/sum (isnull(o.totalhours,0)) end, 'AvgBillRate' = Case when sum(isnull(o.billing,0)) = 0 then 0...

Below is the code that I am receiving this erorr for: Server: Msg 156, Level 15, State 1, Line 21 Incorrect syntax near the keyword 'Group'. Please help because I cannot seem to figure it out! Create table #vacationpay_types (paycodeid int, paycodedesc varchar (255)) insert into...

Could someone please explain to me why the below IF Statement will not return the word 'NULL": If {Command.fullname} ="" then 'NULL' else {Command.fullname} Thanks! Thanks a bunch!! -T

Could someone pleasssssse help me with the error above? Here is the code: select m.parentprofitcenterid, workperiodnum, fiscalyear, c.customerdescription, 'TempsonStreet' = count (distinct o.candidateid), 'Clients' = count (distinct o.clientid)...

Could someone please help me figure out what I am doing wrong in the code below: Select 'Customer' = c.name, 'EmployeeID' = h.employeeid, 'First Name' = h.firstname, 'Last Name' = h.lastname, 'Job Description' = h.jobdesc, 'Regular Pay' = Case when r.paycodeid = 1 then t.payrate else 0 end...

Does anyone know how to remove the default parameter values that appear in the drop-down list? **The parameters were created in SQL? Thanks! Thanks a bunch!! -T

Could someone help me figure out how to calculate the below formula without getting the #DIV/0! error: =AVERAGE(D8,J8,P8,V8,AB8).. What is happening is at some points one of these cells may be empyt. I tried using the is Blank function, but that doesn't help. For this week, D8 is null...

I have the below formula: CONVERT(varchar(10), m.DOB, 101) that returns: 12/23/2008, how can I get it to return only 12/2008? Thanks! Thanks a bunch!! -T

I have the below formula: Case when sum(isnull(o.payrate,0)) = 0 then 0 else sum(o.payrate)/count (distinct o.candidateid) What I need to say is: Case when sum(isnull(count (distinct o.candidateid),0)) = 0 then 0 else sum(o.payrate)/count (distinct o.candidateid) But I can't use count...

Could someone please help me figure out how to change the below code: a.effdate between @PrevQtrClose + 1 and @enddate to say between @PrevQtrClose + dateadd (sec + 1)? What I need is to capture all data between the prevqtrclose and the next day, and right now I missing anything that falls in...