Ghanta (6/4/2009)

---

I was wondering if varchar(max) can handle more than 2gb of data in a file as the entire file will be loaded in one varchar(max) field? Few files will...

For a small list, use the Numbers / Tally table method.

For a large list, use XML. See my article[/url] that covers this. It even includes a comparison to the Tally...

Hey friends, please help me out here. I'd really like to have an understanding of why this changed.

Thanks!

Jeff Moden (6/3/2009)

---

The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with the "Pseudo Cursor" method...

Well, actually it's the second in a series.

Jeff Moden (6/3/2009)

---

Heh... understood about writing cursors... I only do it when I want to show how bad they can really be and I have to lookup how to make...

Jeff Moden (6/3/2009)[hrThe other reason to do this is that I've recently got a call from OSHA. They told me if one more person rides my hiney about this,...

Lowell (6/3/2009)

---

2. if the column is a foreign key, it is the same name as the column in the parent table it references. So a table named Customers has CustomerID...

This article[/url] is about using XML for string manipulations, but it does explain (and show) how these different XML parts work.

How's this?

if object_id('tempdb..#Temp') is not null DROP TABLE #Temp

CREATE TABLE #Temp (

LineText varchar(max))

-- you will need to replace this with a bulk insert.

-- I'm using this just to...

computer.mike (6/3/2009)

---

select * from @T1

where (Customer >= @BeginCustomer OR @BeginCustomer is null)

and (Customer = @BeginCustomer and Customer <= @EndCustomer

GO

[/code]

In this way, each separate procedure has an...

Sam Lowry (6/3/2009)

---

Hi,

I'm running into an sql query optimization issue that I would like to share and get help to overcome it best.

The environment is based on SQL 2008 Express...

byron.vanwyk (6/3/2009)

---

Derek you are the man 😀

I couldn't quite understand exactly what you did 🙂 but took some stuff you used and added it to my query. The result ........

Now you are doing a lot of extra work. After your IsNumeric check, just...

rs80 (6/3/2009)

---

I have 4 tables each one having it's own dataset. I have to repeat these 4 tables for eight companies. I want to create a multiselect drop...