Please read the first article I reference in my signature block below. Follow the instructions on what and how to post the information we need to help you. ...

What would help is if you have (or create) a sandbox database where you can test your scripts outside of your database to ensure that they work before posting them.

Also, we are volunteers. We may have read it, just didn't have time to work it.

Try this is a test environment.

delete from TABLEA

where exists(select Personid from TABLEA except select Personid from TABLEB);

Eugene Elutin (3/13/2012)

---

Lynn Pettis (3/13/2012)

---

Eugene Elutin (3/13/2012)

---

Can someone explain why everyone suggesting huge concatenation logic when date in YYYYMMDD format can be produced as a simple convert with option 112...

Here is a rewrite of the TVF as an inline TVF without a loop:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[udf_DateInc]') AND type in (N'FN', N'IF', N'TF',...

Don't know....

capn.hector (3/4/2012)

---

SQL KnowItAll thanks for pointing out the TVF's made this alot more efficient. krhind, Here is the function followed by the query that will produce your requested output....

Try this:

cast(year(EffectiveDate) as char(4)) + right('0' + cast(month(EffectiveDate) as varchar(3)), 2) + right('0' + cast(day(EffectiveDate) as varchar(3)), 2)

GilaMonster (3/13/2012)

---

A very small percentage of queries (and I mean...

mtillman-921105 (3/13/2012)

---

Ha! That's about right.

'Hate to beat up on...

If you would like better answers, please take the time to read the first article I reference below in my signature block regarding asking for help. Follow the instructions...

You really should consider passing the datetime in using the ISO standard format. SQL will properly recognize the...

I may be wrong but as written I don't think good indexes would help this query. Just looking at seems to indicate that tables scans are going to be...

mtillman-921105 (3/13/2012)

---

I remember using Lotus Notes at a company I worked for years ago. I thought it was really quirky and cumbersome. But it had (IIRC) some capabilities...