The path to your answer starts by reading the first link in my signature.

In other words we need ddl, sample data and desired output. You did not post near enough...

Have you updated your...

Nadrek (6/20/2012)

---

Sean Lange (6/20/2012)

---

I too have struggled with this occasionally. I use this splitter in a lot of very unconventional ways. For example say I want to find all anchor...

And now you have two explanations to the same thing. 😀 There I go trying to explain other people's work again...

dustinprevatt (6/20/2012)

---

It worked!

Could anyone go into detail about what this actually means ?

postdate>= dateadd(dd, datediff(dd, 0, getdate()), 0) and postdate < dateadd(dd, datediff(dd, 0, getdate()) + 1, 0)

I'm glad...

isuckatsql (6/20/2012)

---

Sean,

The Joins were slower than the subqueries, and actually adding the recentwages and recentjobtitle fields back to the profiles table, gained 30% in performance! That is just something i...

dustinprevatt (6/20/2012)

---

Is getdate the same as curdate?

If so how would i use the example in the link to show the beggining of the current day thru the end of the...

Try adding an order by to your select top 1 query. Without an order by there is no way to know which row will be returned.

Dates are a datatype. Formatting is for display. You can't change the format of a datetime. You can however get a string representation in just about any format you want.

dustinprevatt (6/20/2012)

---

Here is the query I am working with.

select *

from table where cast (postdate AS int(128)) between ({fn Curdate()}) and ({fn Curdate()}) + ({fn minute(1439)})

I originally had this

select *

from table...

isuckatsql (6/20/2012)

---

I dont know what they do, other than make the query faster!

I have had a few DBA's and Microsoft Enterprise support work with me on this query, and was...

WOW not sure where to begin with this. You should start by reading Gail's blog about catch all queries. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

It actually looks like you have probably read parts of this....

Why all the join hints? Do you know what they do? Can you explain and justify very clearly why you need them? (to make it faster does not count, you...

Oh....are you trying to connect via remote desktop for administration?

So no error message? How do you know it doesn't connect?