Search results for query: *

Hi, I have a data flow task that truncates and appends to a table. The thing is that if this table has any results then these need to be investigated so after the data flow task I'd like a task that checks to see if the row count of the table is > 0 and if so sends an email. Also I have a few...

...> sysdate GROUP BY ci.item_desc, stcu.prefix, rscu.rng_code, ci.ref_no, stvtu.state_code ORDER BY ci.item_desc ASC' set @SQLString = 'Select * from OPENQUERY ( DWH_NAT_PR , ''' + REPLACE(@SQLString, '''', '''''') + ''')' print @SQLString EXEC...

...@SQLx VARCHAR(200) Set @SDATE = '1 apr 2008' Set @EDATE = '9 apr 2008' Truncate Table BI_Datamart.tblCPMTemplatesRawExtract Set @SQLx = 'select * from OPENQUERY ( DWH_NAT_PR , 'INSERT INTO tblCPMTemplatesRawExtract (item_desc,prefix,rng_code,ref_no,state_code,qty_sold) SELECT...

Remou, works perfectly and saved me hours of staring at a screen, love your work. Mike

Hi, Using access 2000 I have 2 list boxes that are supposed to perform the same action so I moved the code out to a module so I didn't have to repeat code, but I'm having trouble with that. Below is my code which works fine when the listbox name is hardcoded into the for each line but I get an...

Hi, Using acess and excel 2002, I have the below access vba that pulls data from local access tables and then adds the items to combo box on the excel sheet. (Connection lines omitted.) This works brillantly a populates the excel combo with all the data, until you save and close the excel file...

..."Invalid Date" Exit Function End If strDate = Format(strDate, "yyyy-mmm-dd") If IsNull(strDate) Then Exit Function CurrentDb.Execute "Delete * from tblNonComReport" sqlRet = "SELECT CRN.[dtmCalMondayStart],CRN.[intPKState],CRN.[lngFKProductNo],CRN.[idsPKCompetitor],CRN.[chrStateName]"...

Great! thanks for the help

Hi, This may be a noob question so pls forgive. Using PHP, Apache and MS_SQL2000 I have a page that has a text box, a select box and a submit button, this posts to another php file that then does a search using these parameters, the problem is that the select box's values have gaps and this...

Hey, Thanks for answering, I'm not sure about your first point but your second point was spot on. had an error in the adodb file adodb-lib.inc.php line 426. I then went googling and found that this line is most likely incorrect and can be fixed by replacing $rewritesql with $sql. Thanks Mate

Ah! good point thanks mate, well worth a star.

...$db->Connect('Driver={SQL Server};Server=localhost;Database=gb32_Tims', 'sa', 'potty'); //Get total no of rows in table $sql = "Select Count(*) from account"; $rs = $db->execute($sql); $TC = $rs->RecordCount(); $rs->close(); //Get limited results and row count of returned results $sql =...

Hi, Using PHP, Apache and a ms sql 2000 db I'm trying to recreate the simple scrolling through a recordset process as depicted on http://phplens.com/adodb/tutorial.implementing.scrolling.with.next.and.previous.html I get everything except for the scroll links and I'm wondering if this method...

Santa thats great and I'm sure it would work fine if we were using a current version of Oracle, I think the trouble I'm having is that were using an older version that doesn't support the rank function. You've already been heaps of help but would you have an idea how to do this in older oracle...

...= sd.PRICE_ID AND sub.ACCOUNT_NUMBER = a.ACCOUNT_NUMBER ) as t2 on t1.SUBCONTRACT_NUMBER = t2.SUBCONTRACT_NUMBER and t1.PRICE_EFFECTIVE_DATE <= t2.PRICE_EFFECTIVE_DATE group by t1.SUBCONTRACT_NUMBER , t1.PRICE_EFFECTIVE_DATE , t1.PRICE_PER_BLOCK having count(*) <= 2

Hi, [Originally posted in Access queries but reposted here in case there's a VBA solution] Using access 97 and connecting to Oracle I have 2 pass through queries that are connecting to the same oracle db but two different schemas in that db. Access to these different schemas is by the login...

Hi, Using access 97 and connecting to Oracle I have 2 pass through queries that are connecting to the same oracle db but two different schemas in that db. Access to these different schemas is by the login so I have different logins in either pt query which works fine when you run the 1st query...

Finally Sucess! Thanks for your help Remou, well worth a star. It worked by using a multi-dimensional array and a DAO recordset. Dim RstArray(1, 2) Dim rs As DAO.Recordset Set acapp = CreateObject("Excel.Application") acapp.displayalerts = False acapp.Workbooks.Open ("G:\Bsprice\BA Team...

Remou, It debug.printed all the table and tab names perfectly so I guess it's some kind of problem with the .copyfromrecordset, I thought maybe it was a timing thing but this error still happens when I step through the code also. Any more ideas? Thanks heaps for your help so far. Mike

...= Split("tblAll,tblDefault,tblContractFinal", ",") StrWS = Split("AllData,DefaultData,ContractData", ",") For i = 0 To 2 rst.Source = "SELECT * from " & strTables(i) rst.Open With acapp.worksheets(StrWS(i)).range("A2") .CopyFromRecordset rst End With rst.Close Next...