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...

There are two ways to approach this. The first is brute force creating each audit or history table and the triggers needed to populate them. The second is...

GilaMonster (3/4/2009)

---

That's easily...

Have you also noted that he changed his name? Now it doesn't match the name in the quoted replies to his deleted posts. :w00t:

I don't have time right now to look at all of this but I will look at it this evening.

Thank you for posting the information asked.

Mangal9i (3/4/2009)

---

NOw this is not done.

My topic was, Answered Posts. Nobody is talking about that and stve has closed my other thread.

You should have locked this thread Steve....