Okay this is similar to Purushotham's suggestion:

DECLARE @table TABLE (id INT IDENTITY(1,1), EnteredTime DATETIME)

DECLARE @StartDate DATETIME

-- doing this so I have a consistent date with which to work

SET @StartDate...

Have you queried sys.servers for PC001\PC001? With and without the brackets. If you set up the linked server using the Microsoft OLE DB PRovider for SQL Server you...

In SQL Server 2005/2008 you can sign a Stored Procedure with a certificate which allows you to grant access to the Certificate User. Here is a link to the...

You could create a trace that filters on that login name.

Is this a Windows login or a SQL Server login? If it is a Windows Login you need...

Your welcome.

The sort on your Oracle source is irrelevant since that is putting the table in a SQL Server table for staging. You need to have an order by...

Jeff,

I didn't take any offense at what you said, I took it as a compliment, and my post was supposed to be a compliment as well. Just kind of...

Ah yes, this is one of those tools I need to remember. I don't have to deal with updates like this that often so I always forget about this...

Steve,

I think you just got a new level for SSC, ThreadHead!:D If you have 100 posts on The Thread you become a ThreadHead!

Bob,

Always willing to share my opinion, even when it probably stinks.

See, I think that it is necessary to consider others abilities whenever coding something. I want the...

I don't know how you would get around that situation.

Jack Corbett (2/24/2009)

---

I don't see anything out of the ordinary that would cause only 1 row to be returned. I think the only reason it would return 1 row...

I don't see anything out of the ordinary that would cause only 1 row to be returned. I think the only reason it would return 1 row would be...

I'm a fan of letting the UI or business layer handle formatting the data and let SQL Server return the data. I know I can do a lot of...

I'd start with something like this:

IF NOT EXISTS(SELECT 1 FROM dbo.tbl_Tracking_WebPages WHERE Page_Name = @Page_Name)

BEGIN ...

I feel your pain. Especially when it comes to DB2. I don't think I am going to be any specific help, but I would suggest that set the...