It's out of my area of expertise, but I had a supervisor that told me that he...

Ninja's_RGR'us (3/4/2009)

---

Grant Fritchey (3/4/2009)

---

Ninja's_RGR'us (3/4/2009)

---

Holly crap!! If THAT GUY is an MVP, why the hell didn't I ever make that list?

Looks to me like we need about another 2000...

What is your normal way of writing dates: mm/dd/yyyy or dd/mm/yyyy. If the later, then that is probably why the dates in character format needed to be that way,...

Stepping out of my area a bit, but when you say the DNS changed, could you elaborate on that some more please?

Code ran just fine on my system. What is the compatability level of your database?

My first thought was that you were using SQL Server 2000 and had posted in erronously in a SQL Server 2005 forum, but that isn't the case.

Could you post the...

What version of SQL Server are you currently running?

The_SQL_DBA (3/4/2009)

---

Today I am trying to run this query for today..

I want to hard code the time but the date should be retrieved from getdate().

The field takes input as...

Since it is for today, change the -1 to 0 in my code in my previous post.

First, boy has this put him under the microscope. Second, I'll have to wait until I get home to look at these posts of his as our web filter...

mikekay (3/4/2009)

---

The problem was caused by my trying to change the port connection, from the default to a different port number. This should have worked and I'm not sure why...

I think this thread will provide you with what you need to solve your problem.

Let us know if it helps.

[font="Courier New"]

declare @StartDate datetime,

@EndDate datetime;

set @StartDate = dateadd(hh, 7, dateadd(dd, datediff(dd, 0, getdate()), -1));

set @EndDate = dateadd(hh, 7, @StartDate);

select

...

The_SQL_DBA (3/4/2009)

---

Well thanks for the above script but heres the thing...

I am getting the output as 2009-03-04 07:00:00.000

but my callentry gives me empty data with the above result set

for it...

winston Smith (3/4/2009)

---

I have this condition in a select statement

tbl.columnName <> 'ACT'

In the actual table tbl.columnName is NULL. I thought NULL is not equal to 'ACT'. but nothing is selected...