PhilM99 (3/8/2013)

---

I'm a developer and an 'Accidental DBA'. These forums have saved my a%$ more times than I can count. I am always struck by the accuracy and helpfulness seen...

GilaMonster (3/8/2013)

---

opc.three (3/8/2013)

---

You know I am curious about these...

this:

if exists(select 1 from sys.tables where object_id = object_id('dbo.BigTable'))

drop table BigTable; --Drop SOURCE

if exists(select 1 from sys.tables where object_id = object_id('dbo.RefTable '))

drop...

Welcome to SSC. As it appears you are new here there are some things you need to do to helps help you and for you to get better answers...

Full Backup taken Monday night 6:00 PM.

T-Log backups taken every 2 hours starting at 8:00 PM until 6:00 PM Tuesday.

Full Backup taken at 6:00 PM Tuesday.

Full backups taken every 2...

winmansoft (3/7/2013)

---

That...

Me thinks we may have had an epiphany.

alan_lynch (3/7/2013)

---

Hi Lynn

just me again I forgot to mention that yes I want to insert data that does not already exist in the Target Table but if it does exist...

vinu512 (3/7/2013)

---

Brad Marsh (3/7/2013)

---

Thanks Lynn I can appreciate what your saying but the reason I gave you that dummy data is because the data is confidential, I can not simply...

Try this:

drop table BigTable --Drop SOURCE

drop table RefTable --Drop Lookup

--Create a Source table

CREATE TABLE BigTable

(

software_name_raw VARCHAR(255)

)

GO

--Insert records into Source table

INSERT INTO BigTable

VALUES

('Microsoft Office 2003'),

('Microsoft 2003 Office'),

('Microsoft Office 2003 Professional'),

('Sun Microsystems')

GO

--Create...

observe:

declare @TestDate datetime;

select datediff(dd,getdate(),@TestDate)

select datediff(dd,@TestDate,getdate())

set @TestDate = '20130318';

select datediff(dd,getdate(),@TestDate)

select datediff(dd,@TestDate,getdate())

-----------

NULL

(1 row(s) affected)

-----------

NULL

(1 row(s) affected)

-----------

11

(1 row(s) affected)

-----------

-11

(1 row(s) affected)

is250sp (3/7/2013)

---

Try to do this

--> Create temtp table

CREATE TABLE #Test(MonthOfYear int, Year int, Account int,Name varchar(255))

INSERT INTO #Test

VALUES(1,2013,1,'A')

INSERT INTO #Test

VALUES(12,2012,4,'B')

INSERT INTO #Test

VALUES(1,2013,4,'C')

INSERT INTO #Test

VALUES(1,2012,1,'D')

INSERT INTO #Test

VALUES(1,2013,5,'E')

--Build dynamic sql

DECLARE @Month int,...

If the columns are defined as one of the date...

If they are DATE or DATETIME data types why not just do this?

[WorkForce_WorkOrder].[Work Order End Date_WO] <= [WorkForce_WorkOrder].[Previous Work Order End Date_WO]

Sean Lange (3/7/2013)

---

Kansas City area. I am actually in a town just to the West of the metropolitan area with a few miles of farms...