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...

Bulk Insert into a staging table.

Use the "Quirky" update method to strip each row apart into it's parts.

If you can provide sample data, people on this web site will bend...

pvasudha (6/3/2009)

---

Thank you Jack.

But this does not work if i have more ids.

For each id its giving me all dates.But it should only give me max date within 5 days...