*bump*

I think it has something to do with the DataElementOutput property of the tablix static members, but I can't seem to find a setting that works. When I set...

--DECLARE VARS

declare @date datetime

,@no_time datetime-- time stripped off

,@fdom datetime-- first day of month

,@ldom datetime-- last day of month

,@fdoy datetime-- first day of year

,@ldoy datetime-- last day of year

--ASSIGN VARS

select @date...

That's a great idea! I'm totally stealing that 😀

I would make the parameters dependent as others have suggested.

If you absolutely had to produce an error message, you could set a hidden boolean parameter (e.g. HIDE) and...

Thanks for the reply. I figured Profiler was going to be the answer.

I am under the same impression as Lynn, but what's more is that you can't guarantee which part of the AND will be evaluated first.

If you only want to match the On_site to apptdate on the DAY then you need to scrub off the time from both the date time fields. If the...

Thanks Gift Peddie, giving him permissions on reportserver AND reportservertempdb was exactly what I was missing.

Thanks for the reply.

The user can see and execute reports in Report Manager. So I need to elevate the users permissions on the ReportServer, and ReportServerTempDB databases?

First run on a set with 1.3 M rows. The result set expanded to 3.8 M rows.

I had 167323868 logical reads against my temp table, 0 physical.

Unfortunately that took...

It's funny you should ask. I'm using a modified version of it in testing right now. I've run it against about...

So, here's how it plays out.

In the OLE DB data flow source, rather than using "table or view" as the Data access mode, you have to set it...

Thanks for the reply!

I haven't tried converting at the source yet, but I'm looking up the syntax right now. I eventually need to use a SQL command anyway to...

I don't know if this thread is still live, but I'll throw in a couple things I've run into in my brief SQL career.

I've run into problems in...

AND CRD_TXT.EXPN_DTE IN (SELECT MAX (TOCTX_CARDTEXT.EXPN_DTE)

FROM TOCTX_CARDTEXT,

PNCDH_CARDHOLD,

PNCEN_CUSTENRL

WHERE TOCTX_CARDTEXT.UNQ_CRD_NBR = PNCDH_CARDHOLD.UNQ_CRD_NBR AND PNCDH_CARDHOLD.ENR_NBR = PNCEN_CUSTENRL.ENR_NBR AND TOCTX_CARDTEXT. UNQ_CRD_NBR = CRD_TXT.UNQ_CRD_NBR AND TOCTX_CARDTEXT.EFF_DTE <= CAST(FLOOR(CAST(CURRENT_TIMESTAMP AS float)) AS datetime)

AND PNCEN_CUSTENRL.CUST_NBR = 00000

-GROUP...