Here is what would really help, the DDL (CREATE TABLE statement) for the table(s) involved, sample data (as a series of INSERT INTO statements) for the table(s), and expected resutls...

Steven Willis (4/5/2013)

---

Good catch Lynn. But I don't think just changing to ROW_NUMBER...

Steven Willis (4/5/2013)

---

;WITH sampledata AS

(

SELECT * FROM

(VALUES

(1,'2013-01-01','fred'),

(2,'2013-01-05','ralph'),

(3,'2012-12-31','jane'),

(4,'2012-12-15','suzie')

) DATA (ID,EndDate,Name))

,

cteRank AS

(

...

Don't think you can get it without added an addition WHEN clause to the CASE for t2. You are getting a null where c1 = 1 in t1 because...

ssc_san (4/5/2013)

---

Thanks for the reply Lynn Pettis.

There are two records with a value of '1' for column c1, t1 value for those records is null where as t2 has values...

ssc_san (4/5/2013)

---

Hi All,

I am trying to convert a case login to boolean logic, but I could not figure out one part of it.

Here is the DDL and the query I...

For the database in question, what is the current recovery model?

GilaMonster (4/5/2013)

---

Am I the only person who gets 'I don't think that's true' replies to their posts from a certain person and am I the only one annoyed by it?

I...

kiran.vaichalkar (4/5/2013)

---

Hi Team,

I've Table People Where there are n no of employees involved.

The salaries of the employee are present in Column 'Salary'

So now, i wanted to count the no of...

ScottPletcher (4/5/2013)

---

I don't think that's true. If it is, it...

The best suggestion I could give is to batch your inserts into the table instead of trying to do it as a single insert. Be sure that you put...

Dumb question here, why not just add the description column to the existing table (as a nullable column) and update it there as you get the description(s)? Why maintain...

SQLCrazyCertified (4/5/2013)

---

SQLRNNR (4/4/2013)

---

SQLCrazyCertified (4/4/2013)

---

mp5387 (4/4/2013)

---

I am intermediate in database admin. Please give me your solution for this issue.

Size of my db is growing about 5M every 2...

Here is what I really want to say in response to the OPs last post in another thread:

sql-lover (4/5/2013)

---

GilaMonster (4/5/2013)

---

sql-lover (4/5/2013)

---

So I wanted to open a case and review, without...

johnnyrmtl (4/5/2013)

---

I apologize for the vagueness 🙂

What I have is table1 which has been imported externally with 4 fields including an (AccountDescription) field

srvnameAccountAccountDescriptionDATE_CREATION

-----------------------------------------------------------------------------

I need to be able to copy only...