Search results for query: *

OK - So I'm a twit. It needed to be a FILE connection not a FLATFILE connection as it is a self-extracting zip. Still, good to have learnt this! Fee "The cure for anything is salt water û sweat, tears, or the sea." Isak Dinesen

Hi All, I'm not an expert at SSIS by any means but am trying to learn as I go along. I've been following the instructions from this web page http://microsoft-ssis.blogspot.de/2011/05/download-source-file-from-website-with.html And have got most of the way to do what I need. However, for me...

You can do this with no code at all you know? PLace you curser in your data - use [ctrl] & g - the select special then blanks. In you cell type = then up arrow, then use [ctrl] & enter. (Just saying!) Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

Perfect! I shoulda thunk of that. Must be that my brain is finally full up. Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

Hi All, I have a spreadsheet that has two buttons to print to PDF. One prints one set of pages - the other a different set of pages. At present it works by selecting the sheets into an array. However, this means that if the user presses 'Print to PDF' and then 'cancel' all of the requisite...

In settings => Cellular => switch on the personal hotspot option. Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

Skip - as always - I should just listen you! So - have followed your advice.Now my 'OnChange' I clear the second list box and then read the first and use it via the SQL to populate the second. I had a bit of trouble with error trapping (if you click but don't manage to get a tick in the box)...

Basically the first box is a list of organisations in the UK NHS. as one is selected then the doctors within that organisation populate the second box. The idea is that the user can selected several doctors across various organisations. I was try to avoid them selected an organisation and then...

THe data I use is in a specific format hence using SQL to populate the second box. I can't simply empty it as the user may select multiple items from Box 1. The data is provided in the format: Boxitem1FirstColumn Box1 hence using the SQL as I do. So maybe I need to have the SQL check which...

Hi All, I have two list boxes on a form - I'm currently populating the second list qwhen the first changes. Howewver, that means if you deselect the item from the first listbox it doesn't remove the items from the second; which is the behavour I'm aiming for. My current code looks like this...

OK thanks - I guess I need not to start from the wizard. Thanks. Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

I have SQL Express locally on my machine, but I'm connecting to an SQL Standard install (x64) via the SQL Server managment studio. If I remote access to the server I can do it, but that's not ideal really. Just don't understand. And so far my regional ISIT don't seem to be too sure either...

Hi All, I'm trying to build up an SSIS package based on some import-export wizards as I'm not yet au fait with SSIS. My server is SQL 2008 Standard. When I try to save this I get an error telling my that I must upgrade from SQL Express. I do have SQL Express on my local machine. Do I need to...

YEY! Used the ;with FeeQuery as then it works! I don't really understand why at the moment, but perhaps I'll worry about that after I have worked out how to finish the rest of it. THanks Muchly, Fee Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

This is the line to produce the date - am I being really dense? right(convert(varchar(20),period,06), len(convert(varchar(20),period,06)) -3) as MQT, Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

If I run your code exactly as is - then I get the correct answer. But when I run my query i don't. Curiouser and curiouser.... Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

BUt I get no pivot. AM using 2005 - but this should stil lwork? It works in other cases! ARGGGGG Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

Morning all. I have a query that I really want to pivot in output. I've looked at everything and I really can't see where this is going wrong... My query looks like the following: select CCGHB, Brand from ( -- actually query by yer) ) pvt pivot (sum(TotalNIC) for MQT in ([Feb 13],[May...

I think I did. But, what I since tried was to copy each worksheet into a new book and then import the VBA bits. That works fine in 2010. I've just found that someone who needs to use thisis going to be using 2007 though. I opened the new (no-longer-says-repaired) workbook in 2007, and Excel...

I've done that and the [repaired] still shows. Also, I biult this in 2010, and have just tested to see if it works in 2007 and it repairs again and removes all of the macros. ARG! Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen