Something to consider:

select datediff(m, '0001-01-01', '9999-12-31')

returns 119987

That is the largest difference in minutes between the earliest and latest dates handled by SQL Server. The earliest date it can store...

Well, OK. Just do it in a loop, adding portions of bigint that fit into an integer to an accumulating date field.

Something like this might handle the example problem:

declare @t table (txt varchar(max))

insert into @t(txt) values

('"@@"@@T_001_Version = "v2009.01.13.1_1.7"@@T_002_ = "@@T_749_formstatus = "0"@@T_750_finalscorestatus = "Draft"@@M_752_ = "*Hx of AH, VH, and d....')

select...

What units are your bigint in? Minutes, seconds, hours, years, microseconds, months ,picoseconds?

A couple of ways:

1. use an expression for your IN clause:

=split("1W,2W",",")

2. Set up a hidden, multivalued parameter holding your filter values and point to that in your filter.

What have you tried so far? How is the column 'Bit' computed?

Your problem is that the token 'already' is matched by all rows in @message except the first one. So, all rows are returned except the first.

I think that...

Your INSERT query doesn't work. I fixed it like this:

insert into #mytable(current_week)

select '2012-02-24 ~~ 2012-03-01' union all

select '2012-01-20 ~~ 2012-01-26' union all

select '2012-01-20 ~~ 2012-01-26 ' union...

If you like one statement, I would prefer IF... SET ... = 1 ELSE SET ... = 0

I really don't care for the other ones using ISNULL or CASE....

Or, in that same snippet, take advantage of the fact that you initialize the variable @CompleteSetFound to 0 in the declaration. Then you can simplify to:

IF EXISTS (

...

Well, the fix is not complete. I ran into this again in SQL Server 2008R2 just last year. I applied my workaround and voila! Lock gone.

before we begin, would please repost your input data in a code block that includes the DDL and DML needed to populate the data. Then, show the query you...

I feel your pain! Time for a stupid question: What db is the 3rd-party running? Reason I ask is what I read here:

http://technet.microsoft.com/en-us/library/dd239343.aspx

Support for features...

That's true...

Put two images in the footer. Make the visibility of each conditional on the page number. So, if the page number is NOT the last page number, display...