As long as the parameter selections don't change, then the report will use cached data (stored in the project folder with a .data extension).

Technically it is still going to "run"...

You could set the indicator to not visible when the value is N/A

use COUNT() OVER... to select the ones you want.

with uniq as

(

select DOC_NO, REV_NO, FILE_NAME, ADD1, ADD2, ADD3, count(*) over(partition by DOC_NO, REV_NO) as cnt

from MYTABLE

where FILE_NAME <> '-'

)

select DOC_NO, REV_NO,...

Have you tried running SSMS with activity logging enabled?

run it with the "/log" command line switch.

When it dies, before you allow it to restart look at the log for errors.

C:\Users\your...

Select coalesce(c.ViewName, s.ViewName) as ViewName

from Advert.Adverts a

left outer join Category.Child_Categories c

on c.ChildCategoryId =a.ChildCatId

join Category.Sub_Categories s

on s.SubCategoryId =a.SubCatId

where A.AdvertId = @ItemId

I can think of at least phive phive phive sicks nein too won ways of defeating whatever you try and code for.

try this:

declare @dummy nvarchar(50) = 'PM1_BEEL_BWT_MD_2?_RTU.PV';

select @dummy;

The result is 'PM1_BEEL_BWT_MD_2?_RTU.PV', which is what you are putting in the table.

Why? try this:

declare @dummy varchar(50) = N'PM1_BEEL_BWT_MD_2?_RTU.PV' ;

select @dummy;

Same result - the...

Another method I have used for a queue table is to delete the row and insert it into a user queue table, nothing is going to read it if it...

...my guess is that Dan Millman never had to fly economy to go on holiday or he wouldn't...

One more thing, don't forget that you can check where the filtering will occur by examining the Execution Plan - looking at the properties (F4) of the Remote Query operator...

I addition to the answer already provided, I would add that getting a collation match can make a massive difference, and using the COLLATE clause in the query doesn't seem...

SQL_Baby (11/21/2014)

---

Ahh I see what you mean now. Maybe you can look into Server Logon Triggers which you can set to trigger on every connection to your server. There you...

No, it is a normal connection like any other, and the only identifier within the connection...

It is quite clear from the syntax definition that your intuition about bracketing is correct.

http://msdn.microsoft.com/en-us/library/ms177634.aspx

---

[ FROM { <table_source> } [ ,...n ] ]

< table_source > ::=

{

... various options...

You need to reference the local-name() of the element to use a variable in that way.

DECLARE @XML XML = '<Attribute>

<A1>6529</A1>

<A2>6529</A2>

<A3>6529</A3>

</Attribute>';

DECLARE @n VARCHAR(100) = 'A3';

SET...