Maybe...

Steve Jones - SSC Editor (12/10/2014)

---

Jack Corbett (12/10/2014)

---

So in a meeting this morning I was going over a matrix for a 3rd-party product that lists what versions of...

Jack Corbett (12/10/2014)

---

So in a meeting this morning I was going over a matrix for a 3rd-party product that lists what versions of the product are supported on...

butcherking13 (12/9/2014)

---

Currently she can't even see it from her client and it is on the same domain.

Although if she remotes into the server she can right click as Administrator and...

hmmm

That's news to me. A quick Google search found sources that agree with you and others that do not. Since one that agreed was a Microsoft Technet page,...

I...

DSNOSPAM (12/8/2014)

---

I have a stored proc that calls a few other stored procs. I've included an edited version of it at the bottom. I assumed that if I...

36524.0 if the required value for DBCC TimeWarp paramater 79...

sestell1 (12/8/2014)

---

There are a few ways to prevent the package from failing when the file(s) are not there.

One is to change the package properties so that it reports...

cbrammer1219 (12/8/2014)

---

I have that, I would like to get the totals for example, Meaning that there are that many accounts in that zipcode.

ZipCode Count

02149 ...

Eirikur Eiriksson (12/8/2014)

---

Window function version of Alvin's code

😎

SELECT

State

,ZipCode

,Count(Account) OVER

(

...

Try:

SELECT

State

,ZipCode

,Count(Account) AS [Accounts]

FROM YourTable

GROUP BY State, ZipCode;

It's kind of hard to answer your question without knowing more about the data, the import process, and the table(s).

How much do you know about SSIS?

Have people stopped taking time to learn the technology they want to use before trying to use it?