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...

Thanks for the feedback. And I wont bog you down with questions, just that if you want to let us know the exact issues you encountered then we can certainly...

Done. Ohh was this a question? 😛

Did you have to draw this out on a...

I know this is the quickest and easiest way to go about it. You know that you are storing a...