Hi,

would you please be a little more specific on what you're trying to achieve?

I don't know how your expected result "20090605 Section header+Paragraph+Paragraph+section+Paragraph+Paragraph..." would correlate in any way with your...

The reason why I used a "real" temp table is that you cannot use a table variable within a dynamic SQL unless you declare it inside the SQL statement.

Reason:...

Hi Tim,

sorry for the mistake in my previous post. I've been typing while thinking, not after...

The following code should work regardless of _KEY value structure.

Side note: If possible, please avoid...

Hi Tim,

are the values for _KEY in your real scenario always numbered with prefix (like FIELD1, FIELD2, .., FIELD102)?

If true, there would be a way to get the result without...

What do you mean by "tables"? Could you please provide the structure you want to insert the data?

Also, your requirement of "load all the values into a table" seems contradictory...

Are you sure the provider is installed on your server?

Similar issues have been discussed on different threads before.

You might find a solution at http://www.sqlservercentral.com/Forums/FindPost445277.aspx or http://www.sqlservercentral.com/Forums/FindPost544672.aspx.

It looks like you're missing two quotation marks:

One at the end of 'Microsoft.ACE.OLEDB.12.0 and one at the beginning of Database=C:\contact.xlsx.

Also, there seems to be a mismatch of commas/semicolons as per...

The problem is within in your case statement:

The DATEDIFF function returns an integer, so the resulting value of the CASE statement is always an integer as well. So your ELSE...

I don't consider myself a tuning expert at all but I recognized a few things:

1) The parameter @p_Regions,@p_States, @p_MetroIds seems to hold comma separate lists. Instead of calling the split...

Hi Rob,

the structure of the word file -even if it's saved in XML format- wouldn't let you extract the data into SQL Server in a format you'd probably expect or...

GSquared (5/29/2009)

---

In the OP's example XML, the elements were uppercase on my screen. That might be something with the scripts on the page, but it's how they show on...

Conversion to html format usually is done by a frontend application.

What you could look into is XQuery to save the data in XML format.

@vkoka

would this solution help (based on one of Lynn's date routines)?

declare @wk int

set @wk =22

select dateadd(wk, datediff(wk, 0, dateadd(dd,(@wk-1)*7,'20090101')), 0)

/* result

2009-05-25 00:00:00.000

*/

Nice one...

As simple as efficient. 🙂

Thanxalot, Lynn.

Hi Lynn,

your date routines are really helpful!

One question though:

When I try "set @ThisDate = '20090524'" I get "2009-05-25 00:00:00.000" as Beginning of this week (Monday) which is "strange" - at...