Digs posted a project spec here on ssc that he posted on GetAFreelancer.com, so for S & G's (plus I am trying to earn some extra cash as things are...

I have to ask. Why does the developer store numeric values as characters? That is simply rediculous. Right there with storing dates as characters. Almost every...

Old COBOL programmers who can't learn new tricks? 😉

Want to talk about broken records?

Joe Celko (11/14/2009)

---

I have never noticed a temp table or table variable that didn't return its data in the same order that it was added. Do I just need to...

Here you go:

declare @yyyymm as varchar(6)

set @yyyymm='200910'

select

CONVERT(varchar(6), DATEADD(mm, CAST(right(@yyyymm,2) as int) - 2, DATEADD(yy, left(@yyyymm,4) - 1900, 0)), 112),

CONVERT(varchar(6), DATEADD(mm, CAST(right(@yyyymm,2) as...

My guess, old COBOL programmers who haven't changed their ways. 😉

Just asked to have this thread moved to a SQL Server 2005 forum.

Actually, I don't find the Dean's c# code very readiable either. Everything is left justified. I'd prefer to see things indented so that it is easier to see...

Why not this:

select

MemberID,

max(FinancialYear) as FinancialYear

from

dbo.MyTable

group by

MemberID;

I am making the assumption that you were restoring the database from a backup?

Try this:

restore database [YourDatabaseName] with recovery;

Francis Yee-483501 (11/13/2009)

---

I learn from a site to get the row count of table(s) by NOT using count(*) but instead of using

" SELECT rows FROM sysindexes WHERE...

Haven't seen any performance problems.

GDI Lord (11/13/2009)

---

Thanks Gail, thanks Lynn.

Lynn Pettis (11/12/2009)

---

If X5 only has the values 'A' and 'B' why are you testing for these values in the WHERE clause of your query?...

GilaMonster (11/13/2009)

---

Bulk insert, bcp and SELECT INTO are all minimally logged if the database's recovery model is something other than FULL. There are other limitations, check Books Online for the...