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

I would really have to see the data flow here as a diagram. If proc B is calling proc A (after already being ran), what is proc A doing this...

It sounds like a good idea in a high transaction system. But maybe the business should be the one deciding that as opposed to the developers. If I am a...

Maybe I am getting my terminology mixed up. The article mentions that replication between 2008 and 2016 is unsupported. This under the heading of "Items Deprecated in SQL Server...

I keep things simple, if it is in sys.tables then it is a table even if it is not ordered. I can always use an ORDER BY clause to pull...