Grant Fritchey (12/20/2013)

---

WayneS (12/20/2013)

---

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of these are?

For...

Several reasons come to mind

You might leave the company, SQL Agent probably won't. Depending on how they handle deactivation of AD accounts, it may not become apparent right away. But...

yuvipoy (12/17/2013)

---

page will be having 1000 records (between 1 and 1000 ) in first go.. for each and every scroll there be another 1000 rows (between 1001 and 2000 )and...

tmatthis (12/19/2013)

---

It does sound like a permission error. Check that the account running SQL Agent has access to the folders where the Excel template file is stored (and where the...

The server itself needs to be registered and allowed to delegate.

The account running the SQL svc needs to be allowed to delegate this service on this machine.

Different accounts, accessing indivifual...

samalex (12/16/2013)

---

Greg Edwards-268690 (12/9/2013)

---

SQL Server runs MSSQL Service, and needs to be registered to the machine and service.

Reporting Services runs HTTP service on a machine.

Unsure from your description if these...

Not working right now - took a voluntary leave back in April. :hehe:

Been plenty busy though with family and things I couldn't get to while working.

Liked DB2 and the AS400....

So this gets around the limitation that normally turns the outer join into an inner join.

LEFT OUTER JOIN dbo.Email m

ON m.EKey = e.EKey AND m.Next_of_Kin = 'true'

Mostly used a...

ChrisM@Work (12/13/2013)

---

Greg Edwards-268690 (12/13/2013)

---

Chris -

I agree with a lot of your Why's. See this all the time.

If you could look at this, run the view for next of kin info,...

WayneS (12/13/2013)

---

Greg Edwards-268690 (12/13/2013)

---

jasona.work (12/13/2013)

---

Ed Wagner (12/13/2013)

---

jasona.work (12/13/2013)

---

OK, where did the year go?

I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago...

jasona.work (12/13/2013)

---

Ed Wagner (12/13/2013)

---

jasona.work (12/13/2013)

---

OK, where did the year go?

I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting...

Chris -

I agree with a lot of your Why's. See this all the time.

If you could look at this, run the view for next of kin info, and tell me...

I created a real quick sample of a few tables.

The problem I see, is in doing an outer join and selecting any next of kin records that have information without...

If the columns are all 1 or 0, if a + b + c > 0, one of the columns is populated.

First time playing around with this.

Looks like something I would use from time to time.

USE AdventureWorksDW2008R2

go

with temp_tbl

as (

select

ROW_NUMBER() over (order by PostalCode desc) as Row_Number

,GeographyKey

,City

,StateProvinceCode

,StateProvinceName

,CountryRegionCode

,EnglishCountryRegionName

,PostalCode

,SalesTerritoryKey

from

dbo.DimGeography

where

CountryRegionCode = 'US'

and StateProvinceCode = 'MN')

SELECT...