You could create a proc or view that would return the correct information, then give permissions on that proc or view.

Long answer, short: Yes.

Change your structure. Make the days rows instead of columns. It's going to be MUCH easier to work with in the long run.

You really don't want to have...

SQL 2005 can contain XML data, but it is not, itself, an XML database.

It would look something like this:

;with IDs (ProdID) as

(select ProductID

from dbo.Table

where ProductID = @ProductID

union

select ProductID

from dbo.Table

where...

Glad to see you got it working.

jj, the problem with that is it has to be a duplicate, since the last duplicate.

Getting all the duplicates is easy. Getting the duplicates since the last duplicate is...

I would call worries about SQL upgrade paths a form of premature optimization at this point. In the event that you need to upgrade one database to SQL 2011...

Didn't think to look at pages, just checked the total size. Yeah, a page fragment is the reason. Makes sense. Either way, including the clustered index in...

Yes, that use of Row_Number will give you the ones that are duplicates.

What you have to do at that point is find the first one where the row number is...

Are you sure there isn't more code before/after that, and that the failure isn't there?

I ask because I just ran this:

create table DBO.DATAVWOBJACCESSINFO (

RecID bigint primary key,

DATETIMEX datetime,

HANDLEID int,

ID int);

go

insert...

The scope-creep on this one is why I gave up on it. The original problem, as stated, has been solved for a long time, but it turned out the...

Depending on what you want, there are a couple of ways to go about getting it.

First, SQL Server has a number of functions that will return system data already built...

From what I'm reading, I would see 7 virtual servers for 7 applications as a serious waste of disk space and hardware resources. That judgement is based on your...

You can use OpenRowset to query Excel files, and you can use Update From to update from anything you can query. Or you can import the Excel file into...