Start with a data flow task. Open this >

If you are joining on tables already in a SQL Server database then you will simply use that same SQL statement...

So for the Monday, you want Friday listed,

Same for Sunday.

Would the code not actually read as

(1 indicates a Monday)

iif(Weekday(Parameters!TopLineDate.Value,1) = 1,

dateadd("d", -3, Parameters!TopLineDate.Value),

...

I am interested in seeing what the columns actually are. Can you post this? I suspect you are not satisfying 3rd normal form in your database tables.

Hugo Kornelis (9/16/2016)

A logical...

This is just to illustrate the concept outside of SSRS

Create table #temp (

colA tinyint,

colB tinyint,

colC tinyint,

colD tinyint,

colE tinyint,

colF tinyint,

colG tinyint,

colH tinyint

)

/* inssert some test data into our table */

insert...

Hi, Sorry I dont quite understand the question . You want to know how to alter a view to add two new existing columns? Can you post what you have...

Just wanted to bring up a point of inquiry : the view sys.dm_db_index_usage_stats would not satisfy if any table has no indeces I imagine.

I am not sure...

I find it clearer if AS is used consistently when aliasing anywhere. If I can apply...

Just quick and dirty , I can get the offset as a integer with

SELECT

cast(

left(

right (

cast(SYSDATETIMEOFFSET() as varchar(40))

,6),3) as int)

Again , quick and dirty.

I am in the pacific time zone. Currently , according the time zones of the world , I am eight time zones away from Greenwhich time. My area implements day...

You make a very good point Drew. I dont think strict rules can override common sense in accounting for every situation. Expect exceptions to the rules. A mantra I see...

I just did a quick refresher on replication and did not see anything about renaming tables. I got the impression you have to drop and recreate the article and then...

Is the replication still working otherwise? Are the two servers on the same domain?

The way I interpret what the OP is asking for is that the customer can visit a page multiple times before a order is placed. An accumulating snapshot fact table...

Thanks Steve, yeah that is what I thought.

The page link was posted by Thomas on this thread. I am copying it here. https://msdn.microsoft.com/en-us/library/ms143550.aspx