Seems to me an ASP.NET webpage would be a relatively easy solution. ASP.NET webpages can contain a nearly identical report that you've generated in RS, and you could...

However, keep in mind that adding the time zone to the DB means having to gather it from the user at SOME point, and it may already be too late...

Reporting services can't do what you're asking it to do, because you're asking it to get information from the client PC. The only way to do that is...

Just to be sure, you might want to go ahead and compare the tables between servers to be absolutely sure they are indeed identical. To quote Sherlock Holmes,...

As I'm not in the corporate world at the moment, I can only speak to what I saw back when I was, and it was AV on every server, no...

beetlejuice,

I have to agree with Bruce here, ... I think you're over-complicating what you need. Also, I have to wonder how much effort you already have into this,...

I haven't messed with the AND, but I am concerned about function performance over a large number of rows. I created the function as is on a...

beetlejuice,

My so-called design is what most folks call "EAV", or Entity, Attribute, Value. Such designs are notorious for poor performance. The biggest problem I foresee...

Ok, but you still haven't answered the WHY question. Why do you need to do this? What's the objective that a database will give you that...

Ok, but then what you're looking for is entirely "generic", such that you could effectively model ANY given class, method, and attribute scenario. The idea that a...

This depends rather heavily on the nature of the relationship. How, exactly, would any one of these "table-based entities" relate to another one? Unless the...

It would appear to be fairly easy, in that you would LEFT OUTER JOIN the following to your results:

SELECT Program

FROM dbo.vw_ABE_FG_Parent1

WHERE MFGPartNo = '51-A3515-47000'

Perhaps as follows:

;WITH PARENT_PROGRAM AS (

SELECT Program

FROM...

I reran my tests with DBCC FREEPROCCACHE in between each of the 3 steps, and got the following results:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

(5503716...

Using the same assumption as the previous poster (that on Sunday, Weekday(Today()) = 1), you can do this even more simply:

=DateAdd("D",2-(Weekday(Today())),Today())

Steve

(aka smunson)

:):):)

I just realized I was comparing the subtraction WITH the conversion back to DateTime. When I measured just the half-day removal, with no conversion of that integer...