Steve Jones - SSC Editor (2/19/2014)

---

My kid is studying GIS and starting to learn SQL. He actually had some good questions last night about how to translate some questions into...

sqldriver (2/17/2014)

---

mickyT (2/16/2014)

---

Hi

I've never compared my processes against a power shell equivalent (or anything else for that matter:-)), but I have some large text files (around 1.5 GB) that I...

Hi

I've never compared my processes against a power shell equivalent (or anything else for that matter:-)), but I have some large text files (around 1.5 GB) that I pre-process before...

Another option ... though without some sample data it is difficult to test

select c.dbpatid

,case when c.LdgAmt = t.LedgerAmount then 1 else 0 end as Paid

from (select dbpatid, sum(LdgAmt) LdgAmt from...

Hi

If I have understood your requirements correctly, this should do what you want

SELECT Symbol,

ExpDate,

CASE

WHEN expdate = '2014-03'

AND COUNT(*) OVER (PARTITION BY Symbol) > 1

THEN 1

ELSE 0...

oliveraustin (1/28/2014)

---

Ah ha, thought how to reduce the problem size down to 12 groups 🙂

Since the Roles with multiple groups consist of<=12 groups and the rest of the all I...

Hi

The culprit would be the join condition in the update clause. This will return both splits for prices past Mar 2013 because of the >= operator. If you...

I'll try and have another look at this tomorrow and thinking about it, the tally tables should have at least (14 * 12) 168 rows in it for this...

OK I set up the following as a test

CREATE TABLE #InventoryTran (

IntLotKey INT NOT NULL,

IntTranDate DATE,

IntTranQty INT

)

INSERT INTO #InventoryTran

SELECT TOP 100000

IntLotKey = FLOOR(RAND(CAST(NEWID() AS VARBINARY)) * 30000)

,IntTranDate =

CAST(2000...

dwain.c (1/21/2014)

---

mickyT (1/21/2014)

---

gcresse (1/21/2014)

---

One more small request 🙂 The Balance returned from the cte is the Ending balance. Is there a way I can also get the Beginning...

Here's a link:-) http://technet.microsoft.com/en-us/library/ms189461.aspx

gcresse (1/21/2014)

---

One more small request 🙂 The Balance returned from the cte is the Ending balance. Is there a way I can also get the Beginning balance for...

You're welcome

I've made a small change to handle the summing of multiple values in a month

WITH cteSmallTally AS (

SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1 N

FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) E1(N)

,(VALUES...

I've had a go at this using the new windowing options in 2012 to do the running total.

I'm not sure what the performance of this will be like with larger...