No, there are no range searches

The from end will be a SSRS report(2008 R2). And I think it should be supporting the font if sql server 2008 R2 is supporting it. As I mentioned in...

For anyone facing same issue, here is how the discussion went:

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/8fb014a7-4505-48c2-9f8c-d35fcd73b208

And depends if you are going on a coffee break or not in between.

Don't join if you have to work alongwith/under the person who asked this.....

Can you pls provide the exact steps you followed to create the ODBC?

In GUI, "Be made..." options are used for logins not defined on above list. If you use a login present in list, then connection will be made using that else...

You may also try using GUI to see the options you didn't get here....

Pls provide some more details. From where you want to fire that query?

Whar do u expect in the returned resultset?

Larry Page(Ehsan.Akbar) (4/26/2012)

---

hi .

i have 3 servers ,and each of them...

I find microsoft press books for these exams quite helpful.

okay, got it. thanks....sometimes you miss to see the very obvious....

Lynn Pettis (4/25/2012)

---

S_Kumar_S (4/25/2012)

---

Now the question is: if datatype of column is datetime, then how 29thfeb2011 got inserted in the...

You are short of luck here. You can't call function without schema prefix.

Now the question is: if datatype of column is datetime, then how 29thfeb2011 got inserted in the table. It is not allowed by sql server.

The datatype of this column in table is datetime, right? if not then there might be some values which might not get convered to dateime datatype.

I picked some values, and...

Can you paste some records that service_data column has? I replaced your Service_date with getdate() and it worked fine.

So can errors with same severity level behave differently? like this case.

If yes, then it can be a problem.

GilaMonster (4/25/2012)

---

S_Kumar_S (4/25/2012)

---

I was looking for some response here but looks...