Without seeing the code not much we can do to help. It is possible that you are experiencing parameter sniffing.

Please read the first two articles I reference in my...

Not sure what you are talking about at this point. Please show what you mean by three codes. If you mean you have 2 codes and you need...

mamet_bundar (11/15/2009)

---

Hi, I'm a newbie on SQL programming

I want to asking about how to display data which have different code in same table

CODE NUMBER QTY

C10 1111911101 10

C10 112789930K 20

M10 1111911101...

No, variables are not affected by transactions. This is also true of table variables.

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;