:crazy::crying::pinch:

markpruett_02 (10/13/2010)

---

I have a situation where I have data that looks like the following:

ABC NULL NULL NULL NULL

NULL DEF NULL ...

Nick123-481228 (10/13/2010)

---

Thanks for reply.

Your code updates both NULL values with same max date which is not I am looking.

First Null value in table should be updated with LastChangeDate=20030102

******

Second Null...

Thanks for the feedback... but it makes me curious. How significant is the improvement?

Just a quick note: the "_CI_" in the second one indicates case-insensitive.

The "_CS_" in the first one indicates case-sensitive.

JC-3113 (10/13/2010)

---

Hi Folks

I made the...

I would suggest un-pivoting the data, selecting what isn't null, and then pivoting it back.

The two articles in my signature block on Cross-Tabs and Pivot tables (parts 1 and 2)...

Determine the tables that are on the one filegroup, and rebuild the clustered index on the new filegroup. This will move the data to the new filegroup.

If you have non-clustered...

Since you're on SQL 2008 (at least you posted on that forum), you might want to investigate "Change Data Capture".

The big problem with Gianluca's query is that if you add a new "Query" to the table, this won't reflect it.

You might want read the "Cross-Tabs and Pivot Tables, Part...

ravimodi (10/12/2010)

---

Thanks Craig...for your input. Well, I checked this and just wanted to discuss...basically the query u gave gives the month end records and what i need basically are the...

Does this do what you're looking for?

UPDATE t1

SET LastChangeDate = t2.LastChangeDate

FROM @Prices t1

JOIN (select Id, [Date], CreatedDate, Price,...

arkadyzanadze (10/13/2010)

---

Hi,

I have been trying to pass 'int' and 'date' variables from Access module to SQL Server 2005 function and getting the error: "Invalid column name 'MyVariable'

The number is 7...

Glad that it helped... and thanks for the feedback!

Glad to be of help. Does it work right for you?

@stefan - good response...