Search results for query: *

You're going to over complicate your query horribly. You can use the cube and rollup functions but as I said this will make it nasty! Dynamic sql is a pain in the proverbial at the best of times. When you start adding dynamic pivots into the mix it's probably better to look at alternative...

My Access 2003 skills are a bit rusty as it's so old, but I would presume that Access will recognise it when you open it in 2010 and prompt you to convert it or open it read only.

In the simplest format I would suggest: orders >- orderitems deliveries >- deliveryitems items This will enable to you record the orders as they are placed along with the items ordered. When deliveries come in record these as well with the items delivered. Presuming your delivery notes have an...

If you have working drivers for Oracle, then yes. If not, no.

Create a new report Add a datasource (Connection to your SQL Server or other source if your data is elsewhere) Create a dataset pointing either at your dynamic sql (bad) or your stored proc (good) Drop a graph object from your toolbox onto the report and configure according to your dataset...

I have a custom Outlook task form that allows me to manage work for a client. I use my own notes field as a UserProperty. When I set the form up and create a new task the form displays correctly and I can add comments to my GPCNotes column. However, as soon as I close the form, I can no longer...

Folks, I'm looking for a solution to mapping cloud storage for users in their login script. The cloud accounts are all created using the domain username, the email address, or a global login. What I want to be able to do is connect a number of different cloud solutions as mapped drives via a...

I seem to have gotten myself into a bit of a tangle with this bit of dynamic sql. Can anyone look at it with fresh eyes and clear it up for me? The statement is stored in a table as a string. It's actaully a string that runs against a Postgres database using OPENQUERY. The table is read and...

Ah, of course!!! Thanks djj55. I've obviously been having a blonde moment!

I think I may be missing something really obvious here. I want to create a copy of a table without the data. The tables are dynamic and so I can't look at a given column and do WHERE ID = -1 or something similar. Some of the tables may be very large. What I'd like to do is effectively run a...

I'm from a SQL Server background, and this is the easiest thing in the world to do in SQL Server. In Postgres it seems to be much more difficult. I want to find the date a table was created and/or last updated. This is in the schema in SQL Server, but I can't find anything remotely close in the...

Ah yes, SQLSister, but that's assuming the purpose here is to audit the data. In that case I would agree wholeheartedly, but as we're looking to audit the usage of the sp's, triggers wouldn't help much.

Cool! Thanks George. You're a genius! It's amazing what you learn each day with SQL!

Thanks for the feedback George. Is it possible to read the contents of an sp though vb? If you know how could you dump an example for me? Nice idea about checking a table. Unfortunately, I can't. Their licence agreement prevents them from changing the code. They want to be able to run the...

Hi Folks, I need to add some auditing to a clients database. The sp's to actually do the audit are no problem. However, I need to insert the calls to the audit procs into every stored proc in their database and there are over 300!!! In addition, I'll need to be able to remove the audit calls...

Put the following line of code into the excel workbook: Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub

You'd be better off doing this either from Access or from an SSIS package rather than t-sql. Personally, I'd go with Access as it's easier to control and debug than SSIS.

Without seeing your file it's impossible to say what the problem might be. Post your csv file

Ha! Loomah, you are a genius! Indeed it was. Staring me in the face was a line of application.enableevents = false with a corresponding true that had been commented out! It's the obvious things that you miss when you're looking for something more complex!! Thanks very much.

Why bother going in to the complexities of faxing?? My advice would be to sign up with a fax service such as myfax and have your code send the fax via email. This is much, much easier. Either do it with hooks into Outlook or better still using CDO. The end user recieves a fax in the same way as...