TomThomson (3/28/2016)

---

Lynn Pettis (3/28/2016)

---

diamondgm (3/26/2016)

---

The results should be visible here

If the BI gods do their thing, the report should update hourly

You should also be able to download the data by...

It works as long as there aren't two rows of data for the same Download, AccountNum, RootPolicyNum where CurrentStatus = 'Renewed' for both.

I came up with the following:

if object_id('tempdb..#Policy') is not null

set noexec on;

create table #Policy

(

Download varchar(20),

AccountNum varchar(20),

RootPolicyNum varchar(20),

PolicyNum varchar(20),

CurrentStatus varchar(20)

);

set noexec off;

truncate table #Policy;

insert into #Policy (Download,...

Or datetime2 where it is...

Personally, every backup to its own file whether full, differential, or transaction log. Also, personal preference is to disk, then if needed backup the file(s) to tape.

This will work, but I'd ask what your intentions are for this as I personally would not use the dates for a close-ended query on date ranges.

with qTally as (

select

...

Run this and post results:

select

name DatabaseName,

log_reuse_wait_desc

from

sys.databases;

Welcome to SSC. First thing I am going to suggest is that you read the first article I reference below in my signature block. It will walk you...

I had a coworker at a previous employer where I was actually writing PL/SQL :sick: that had TOAD set up to format the code the way he liked it. ...

diamondgm (3/26/2016)

---

The results should be visible here

If the BI gods do their thing, the report should update hourly

You should also be able to download the data by clicking on the...

Making it easier for others:

http://www.rdx.com/

Brandie Tarvin (3/10/2016)

---

Grr. Having this issue with another login.

This login does NOT have sysadmin and can't create endpoints. In fact, when I run all the code, I can't find...

Ed Wagner (3/23/2016)

---

Lynn Pettis (3/23/2016)

---

Ed Wagner (3/23/2016)

---

Lynn Pettis (3/23/2016)

---

Ed Wagner (3/23/2016)

---

Alan.B (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a...

Ed Wagner (3/23/2016)

---

Lynn Pettis (3/23/2016)

---

Ed Wagner (3/23/2016)

---

Alan.B (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did....

Ed Wagner (3/23/2016)

---

Alan.B (3/23/2016)

---

ChrisM@Work (3/23/2016)

---

How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.

The...