Search results for query: *

Many thanks. That's an approach that hadn't occurred to me. I'll think it through and see if it will provide what I'm looking for. I already have a separate DB on the server that acts as the 'controller' for the queries. The main purpose is to provide a means of producing company reports...

I have a need to write some common queries that will work across multiple databases (all on the same server). The databases all have the same schema but are 3rd party so I am not allowed to create Stored Procedures or User functions in these databases. For this reason I have a separate database...

You don't say how you are doing this but I would use the Data Import Wizard that you can access via Sql Server Management Studion 2008. Open a connection to your server and select the target database. From the right click menu select Tasks|Import Data... For the Data Source select the...

It could be to do with the way Vista protects itself against malicious software. On the Vista machine you may need to mark the C:\ProgramData folder as Trusted via the Trust Center. Regards Bob Boffin

First I would recommend that you get confirmation of the move to SQL 2008 as the reporting services are greatly improved over 2005 and if possible you should avoid having to upgrade from 2005 to 2008. If necessary you can develop 2008 reports using SQL Server Express 2008 with Advanced Services...

If I've followed this correctly an even simpler approach is to place each set of 'child buttons' on separate Panel components all sharing the same location and size. By default initially all these panels are not visible. Then when a parent button is clicked you simply make the required panel...

The suggestion of using a TableAdapter is a good one but you may find the process of creating one somewhat obscure. 1. add a new DataSet to your project. The dataset designer opens. 2. add a TableAdapter to the Dataset design surface and right click on the section headed ...TableAdapter and...

Have you tried Right-Click and select 'Save Target As'? Bob Boffin

OK. The attached file should create the sample tables and populate them with some sample data where I've blanked out the DOB and Address fields. Let me know of any problems. Bob Boffin

I have to be a bit careful about sending any real data as it relates to the social services department of a London borough. I'll see if I can neutralise a couple of examples and send them to you. Watch this space... Regards Bob Boffin

Thanks again. Changing the OR to AND in your original solution didn't help as this requires 'sarah' and 'davidson' to be in the same record. In fact it returned no rows. The second option is more interesting as it introduces me to some new syntax the OVER .. PARTITION BY clause. Unfortunately...

That's an interesting solution but it doesn't give the same results as my example. This is probably because of the data. The records in the ItemDescription table are the details of persons living at the same address so if you search on the surname Davidson it is probable that there will be more...

I have two tables: ITEM ItemID INT (PK) AccountID INT . . ITEMDESCRIPTION ItemID INT ) (PK) Sequence INT ) ItemDesc NVARCHAR(255) Thus there may be multiple rows in ITEMDESCRIPTION for each ITEM record. I need to find all items for a specific account that have two...

This is a greatly simplified version of the table schema which is, as you suspected, immutable as it's a 3rd party DB. They chose float for what, I agree, should really be a Money column. The Price Detail table is separate and has its own primary ID as there may be multiple Price Detail records...

I have a situation where I need to find a valid price for an object. I have three tables: Price with columns PriceID int ObjectID int AccountID int PriceDetail with columns PriceDetailID int PriceID int ChargeRate float Object with...

Since this is a VB.NET forum may I suggest using the more efficient StringBuilder for creating a long text string like this and to use the AppendFormat method to help with getting the values inserted correctly. Dim lB as New StringBuilder("INSERT INTO 2001_DBASE_KS ") With lB .Append("([First...

Have you checked the log for the SMTP host "RepProductions"? This will tell you whether the message was received and sent. You may have to turn logging on as it's often not enabled. It's also possible the the host smtp service is actually stopped. Bob Boffin

Alternatively you can give aliases to all the columns in your SQL query and then derive your dataset from the results of the query. Just remember that you'll have to hand code any Insert or Delete commands as the dataset won't map them correctly. Incidentally this also applies to renaming the...

Take a look at the XMLTextReader class which should do it all for you. All you have to do is persist the nodes you want in some way. Bob Boffin

Assuming that you are using Windows Pocket PC or CE devices checkout a program called Spb AirSetup that does exactly what you want. I used it a few years ago to update handheld devices over GPRS. It should work extremely well over a wifi connection. Bob Boffin