Ok here is query 1. This query looks up...

I get your trying to teach me, I wish i had more time to dedicate to learning SQL more. But I think i figured it out anyway. Im...

ok im all sorted out now working just how i want it.

I had another requirment come up last night however and try as I did I couldnt figure...

Lynn Pettis (2/8/2011)

---

lance.kentwell (2/8/2011)

---

I figured it out 🙂

SELECT DATEDIFF(s, '1970-01-01 00:00:00', (SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0))))/86400

SELECT DATEDIFF(s, '1970-01-01 00:00:00', (SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,getdate()),0))))/86400

I also added "/86400" on the end to convert the whole...

I figured it out 🙂

SELECT DATEDIFF(s, '1970-01-01 00:00:00', (SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0))))/86400

SELECT DATEDIFF(s, '1970-01-01 00:00:00', (SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,getdate()),0))))/86400

I also added "/86400" on the end to convert the whole tings to days...

ok, first I am using this query to get first day of the previous month:

SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0))

Then I take the result and convert it to epoch time suing this...

Actually using a staging table is an option. problem is im such a newbie all the ways you suggested to remove the duplicates etc are chinese to me. ...

Nope, not an option unfortunately, the service populating this file wont allow it.