We help IT Professionals succeed at work.

add where t0.u_iis_dddt is >= 1.1.09

Medium Priority
193 Views
Last Modified: 2012-05-06
my mind has gone completely blank! How do i add >= to 1.1.09?

Thanks

K
SELECT  T0.[U_IIS_DDDT],  T0.[U_iis_plan], t0.U_AVL_offered, dbo.fhGetWorkingDaysWithoutWeekEnds(T0.createdate, T0.[closeDate])                     AS DaysToClose, t0.u_avl_na1,T0.U_AVL_na2, T0.U_IIS_INSCODES, T0.subject, T0.U_IIS_INADR, T0.custmrName FROM [dbo].[OSCL]  T0 LEFT OUTER JOIN [dbo].[OHEM]  T1 ON T0.technician = T1.empID INNER JOIN OCRD T2 ON T0.U_iis_job = T2.CardCode INNER JOIN OUSR T3 ON T0.assignee = T3.INTERNAL_K INNER JOIN OSCS T4 ON T0.status = T4.statusID WHERE LEFT(t2.ZipCode, 2) IN ('BH','OX','RG','sl','so','sp') order by t0.U_IIS_DDDT, T0.U_IIS_PLAN, T3.U_NAME, T2.ZipCode

Open in new window

Comment
Watch Question

SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This will do
SELECT  T0.[U_IIS_DDDT],  T0.[U_iis_plan], t0.U_AVL_offered, 
dbo.fhGetWorkingDaysWithoutWeekEnds(T0.createdate, T0.[closeDate]) AS DaysToClose,
t0.u_avl_na1,T0.U_AVL_na2, T0.U_IIS_INSCODES, T0.subject, T0.U_IIS_INADR, T0.custmrName 
FROM [dbo].[OSCL]  T0 
LEFT OUTER JOIN [dbo].[OHEM]  T1 ON T0.technician = T1.empID 
INNER JOIN OCRD T2 ON T0.U_iis_job = T2.CardCode 
INNER JOIN OUSR T3 ON T0.assignee = T3.INTERNAL_K 
INNER JOIN OSCS T4 ON T0.status = T4.statusID 
WHERE LEFT(t2.ZipCode, 2) IN ('BH','OX','RG','sl','so','sp')
  AND t0.u_iis_dddt is >= '2009-01-01'
order by t0.U_IIS_DDDT, T0.U_IIS_PLAN, T3.U_NAME, T2.ZipCode

Open in new window

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.