Hi

This works for me... whip off the day name, and the ordinal bit of the day of month, then simply convert what's left to smalldatetime. I've avoided generic patindex use...

I like it, thanks! 😀

I knew by suggesting it that a few eyebrows would probably be raised!

Thanks Sean, for adding the links to further info about the nolock hint... as it happens,...

I'd investigate adding the "with(nolock)" hint to your query - it doesn't involve killing processes, and it might solve your problem if it's being caused by an errant lock -...

Hi, it's all possible...

Each time you call the PivotTableWizard it adds a new sheet (with a new pivottable on it), so if you want the pivot to appear on...

Hi,

I think this is because the line expects your "Data" worksheet to be Sheet1 in the excel project - changing "Sheet1.CreatePivotTable" to "ActiveWorkbook.Sheets("Data").CreatePivotTable" should resolve the issue, by making...

Hi,

This should work for you...

In your excel file, insert the following Names:

Range("B5") = Application

Range("B6") = Build

Then, in your file as I can see it (in the screenshot), delete...

Hi,

Polkadot, I think we're both at risk of being lambasted by the "sql-only gurus" :unsure: - if so, before that starts 😀 let me say that the...

Hey Polkadot,

I have an excel VBA based reporting tool that does what you need - accepts user parameters, fires off a query to a sql database, gets a recordset...

Hi Dev,

it would also be feasible to use SSIS (or something else) to automate the whole sqlplus->txt->bcp approach 😀 This is what I did (the something else option -...

Hi,

I've had to do something similar before - numerous oracle tables, some with millions of records, others with just a few... all with a "last-update-date-time-stamp" field allowing selection of only...