What Sean is saying here is that ANSI is not a results type, it is a standard. ASCII is a character set.

Ok... Add a UNION ALL between the 13th and 14th SELECT statements 😉

Please post the query. See how to do this appropriately in my signature; the article by Jeff Moden.

It is certainly a reason why your results do not coincide with SQL Server, but it...

Integration is manipulating or moving data. I expect that the interviewer was asking if you have experience in SQL Server Integration Services (SSIS). If you do not know what...

Well, I ran the query that gave you incorrect results above and I get the right results. So, the problem is not the query, it is your data formatting...

How are you getting these results? These are not SQL results, they are formatted... Where are you running your query?

Run this and post the results:

SELECT TOP 10 expiry_date, DATEADD(d,1,expiry_date)

FROM v_stafftrainingDetails

and this:

SELECT GETDATE()

Try this:

SELECT *

FROM #v_staffTrainingDetails

WHERE expiry_date >= DATEADD(d, 0, DATEDIFF(d,0,GETDATE()))

AND expiry_date < = DATEADD(mm, 2, DATEADD(d, 0, DATEDIFF(d,0,GETDATE())))

lukebaker (4/3/2012)

---

Basically i am building a windows application using c# and i am trying to filter the data using an sql statement. This is being done with a drop down...

Let's start by going back... How do you define 2 months back? Beginning of month? 60 days? Please gice some sample dates and desired results for dates inside and...

lukebaker (4/3/2012)

---

I am trying the below statement but seem to be getting data back which is longer than 2 months away?

SELECT training_No, training_Type, completed_Date, expiry_Date, qualified_Unqualified, first_Name, last_Name, staff_No

FROM ...

The reason that Anders' solution is better is because you are not running the DATEDIFF function on each row, but instead running it once on getdate() and then comparing that...

That really depends on the type of data, transaction load, and many other factors. It also depends on what your definition of "serious overhead" is. Can you build...

Please provide DDL for the responsible tables and sample data with the DML to populate it. Please reference the article in my signature below.

To get a jump on this, though,...