Search results for query: *

Everything seems fine...just to confirm hope we have updated the "Input Parameter" tab. Alternative: You can use VBScript to update the Source. dim varSql set varSql = "select (select top 1 extnrwg_060 FROM werkgever_060 where intnrwg_060 = intnrwg_250) as extwgnr, factuurnr_250...

Dude...if you are still working on this.. just one thing...make sure you RTRIM your fields when you import them...as they seem to have added space Have had some probs in the past with the same...especially querying the data with added space in the values... Hope its helpful! -------------...

Hey giving it a shot...since i didn't see anyone reply...not sure if you are still waiting... ------------------------------ I believe you have a table that looks like: - BusinessUnit, EmpId, EmplName, ManagerName and would like to create multiple files (excel, csv...etc) for each...

you can connect to the server through Query Analyzer...and perform normal DDL/DML operations. You cannot connect 2000 Enterprise Mgr. Also, make sure the SQL Server 2005 has the remote connections option enabled. By default this option comes disabled in SQL 2005. Hope this is helpful! --...

Here is a quickie which should work for this scenario... One thing tho...the total for each grouping is 785 and not 805 :) --------------------------------- SELECT * FROM ( SELECT DISTINCT A.CITY , (A.CATEGORY + B.CATEGORY) AS 'CATEGORY' , (A.AVALUE + B.BVALUE) AS 'VALUE' FROM...