This great article by Paul White will help you:

http://www.sqlservercentral.com/articles/paging/69892/

Syed Jahanzaib Bin hassan (6/21/2011)

---

install the sql server native client 10 on the side of SQL server 2000 and then create a odbc with this driver and then create a...

You need a tally table (or tally cte) for this:

DECLARE @FromDate DATETIME, @ToDate DATETIME

SELECT @FromDate = '10-June-2010', @ToDate = '1-May-2011'

-- It's unclear in your requirements if you need to include...

Hi Barry! How are you doing?

Where have you disappeared all this time?

Yes for RPC in/out or for SQLCMD?

Unless you add the constraint unchecked, SQLServer tries to check the constraint against all the existing rows.

Scalar functions usually don't perform well.

I'll second GSquared suggestion: use FK constraints for this...

Looks like a network connectivity issue.

You could log on to the 2008R2 machine and run SQLCMD to connect to the SQL2000 server. Does it work?

DECLARE @Listing TABLE(

Id VARCHAR(20),

Location VARCHAR(255),

[Status] VARCHAR(6)

)

INSERT INTO @Listing

VALUES

(1, 'LocABCD', 'Active')

,(2, 'LocABCD', 'Closed')

,(3, 'LocDEFG', 'Closed')

,(4, 'LocDEFG', 'Active')

,(3401, 'FOOD & LIQUOR', 'Closed')

,(3422, 'FOOD & LIQUOR', 'Active')

,(3623, 'FOOD & LIQUOR',...

I suspect T-SQL is not the right tool for this task.

Try powershell instead! Here's a sample: http://sqlserverpedia.com/blog/sql-server-bloggers/xp_delete_file-vs-powershell/

You can use PIVOT to get that kind of results.

Can you provide a table script and some sample data? That would make helping you a lot easier.

Brandie Tarvin (6/9/2011)

---

SQLRNNR (6/9/2011)

---

GilaMonster (6/9/2011)

---

You mean the parrot effect? Someone posts a...

Thank you, Jason!

I just hope it's better than the crappy draft you just reviewed for me.

I haven't had the time to fix...

Yes, you do. 😛

Congratulations Gail, and thank you for the countless times you helped me.

Chad Crawford (6/9/2011)

---

So I just started a consulting company and I have a question for you. What should my title be? If I'm the CEO, the company...

...longer than you could ever imagine!

Thank you.