Jeff Moden (8/27/2012)

---

BWAAA-HAAAA!!!! In the truest sense, it is, in fact, homework. It's a privately owned laptop for home use that I'm setting up. Thought I'd warm...

At least you didn't say your dog ate it. Then it would have sounded like a homework problem. 😛

You're most welcome but all I did was try.

That's true enough and if the OS came pre-installed it is...

You didn't say whether the OS is 32 bit or 64 bit, but the message says you can install SP1 after installing SQL 2008 to avoid the compatibility issues.

This link...

This should work in SQL 2000:

CREATE TABLE #Temp

(TNID INT, TN VARCHAR(20))

INSERT INTO #Temp

SELECT 3011170, '4402787100'

UNION ALL SELECT 3011170, '4402787101'

UNION ALL SELECT 3011170, '4402787102'

UNION ALL SELECT 3011170,...

You've given us expected results, which is a good thing. Some people like me visualize solutions most easily when this is provided.

However you have not provided DDL for your...

First, start with a better string splitter, like the one from Jeff Moden:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Then use cascading CROSS APPLYs, thusly:

declare @parameter varchar (200)

set @parameter ='1_2_3|4_5_6'

SELECT ss=MAX(CASE c.itemnumber WHEN 1 THEN c.item...

Agreed. The .xlsx format in 2010 has not changed from 2007.

Alas, this is wishful thinking. I wish everybody did. 🙂

shikhar_0511 (8/27/2012)

---

could you explain the code that starts from

SELECT c.Origin, c.Destination, c.Tonnage

,n=ROW_NUMBER() OVER...

Actually you can try this:

select *

from tablename

where id IS NULL or RTRIM(ISNULL(name, '')) = '' OR sal IS NULL

shikhar_0511 (8/27/2012)

---

Actually when i run this on wamp server it shows following error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your...

Or if your data is incomplete, as I have demonstrated by commenting out one of the set up rows, you can explode the CTE1 with a FULL OUTER JOIN to...

shikhar_0511 (8/26/2012)

---

I am really sorry but this one is definitely the final problem

here is the new defined problem(forget about the old one):

I m working on something called the analysis...

No +1 for my performance improvements? :crying: