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)

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)

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)

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)

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)

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)

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)

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