First, by "count of" sales I assume you mean SUM of sales. Otherwise we'd be looking at a result set a little more like:

WeekEndDate SalesTotal

2011-01-07 1

2011-01-14 1

2011-01-21 1

2011-01-28 1

Lets try...

Jeff's article is certainly a must-read on this topic.

a2zwd (7/18/2012)

---

Hi

I have a table which holds the running total.

DECLARE @CumCredit TABLE(RowId INT, CustomerId INT, TransId INT, Pts INT, RunningTotal INT)

INSERT INTO @CumCredit VALUES(1,123,121,10,10), (2,123,131,20,30), (3,123,141,15,45)

New resultset which needs to...

First, a little more detail would help here....

SQLSACT (7/17/2012)

---

Hi All

How would I setup a script to copy files from a shared location on one server, to a shared location on another server?

The extension of the files would...

dndaughtery (7/17/2012)

---

Is there a way to do it in the declaration?

I was told someone interviewing me would ask this. In my 7 years of DB Development Ive never had a...

-- Sample code

CREATE TABLE #T(ID INT, Unit INT)

INSERT INTO #t

SELECT 1,33 UNION ALL

SELECT 2,33 UNION ALL

SELECT 3,25 UNION ALL

SELECT 4,55 UNION ALL

SELECT 5,55

-- Query

SELECT MAX(ID) ID, MAX(Unit) Unit

FROM #t

GROUP BY...

Sean Lange (7/12/2012)

---

The whole series of subselects sure makes that far more complicated than it needs to be.

Not sure if what you posted produces what the OP wants but this...

I think this is what you are looking for.

-- Sample data

DECLARE @salesStore TABLE([CustomerID] VARCHAR(20));

DECLARE @MyTable TABLE(val varchar(20));

INSERT INTO @salesStore VALUES ('xxx'),('yyy'),('zzz');

-- Insert statement

INSERT INTO @MyTable

SELECT * FROM

(

VALUES ('Store'),('CustomerID'),('int'),('10'),('Sales'),('CustomerID'),('PK_Store_CustomerID')

)...

CELKO (7/11/2012)

---

There is only one display format in ANSI SQL; the ISO-8601 version with dashes "yyyy-mm-dd HH:MM:SS.sssssss". Please notice I said display format.

SQL is an abstract model of data. We...

schleep (7/11/2012)

---

We changed some users AD accounts to a new name (samaccountname, displayname, logon, etc..)

On one SQL server (2 instances), we get the following error on setuser.

Could not obtain information...

DECLARE @date datetime = '2012/06/20'

SELECT CONVERT(CHAR(10), CONVERT(datetime, @date,103),101)

SGT_squeequal (7/11/2012)

---

Racking my brains on this one, does anyone know if it is possible to do a while loop with in a while loop?

what i want to do is...

No problem.:cool:

Sony Francis @EY (7/11/2012)

---

We can simplify the above query to

select @v-2 =case when t1.col2 like '%*%' then t2.col2 else t1.col2 end

from @table1 t1,...