Recent content by neemi

Hi All, I need help with a bit of SQL... I have a table which shows the below: season | ValueThisYear AW17-1 | 100 AW17-2 | 205 AW18-1 | 199 AW18-2 | 300 I need to create a view based on similar columns which will give me the...

HAHAHAHA!!! SOLVED! As soon as I posted this I saw my mistake! spent two days pulling my hair out and the mistake was I mistakenly typed "SumIfs" instead of "SumIf"!!!!!

Excel 2007 i am trying to create a function to do a sumif using workbookFunction in VBA so that I can pass in a named Range and worksheet name via a control row on a worksheet to create the data and formula's where needed. However I just can't get it to work. It seems to stop on the line i...

All sorted now. FYI. using multiple joins required bracketing around the joins and "LEFT JOIN" instead of "LEFT OUTER JOIN

EXCEL 2007 Does anyone know what the syntax for joining multiple sheets via ADO to populate a recordset would be based on multiple sheets? I am trying the below but it does not work. SELECT [Sheet1$].[column1] ,[sheet2$].[column2] ,[sheet2$].[column3] FROM [Sheet1$] LEFT OUTER JOIN...

Can someone please tell me if an application written in MS access 2003 will run using Access 2010 runtime? I am looking for some official explanation/document etc online which will state if this is true or untrue. and also what issues are possible if any? I have searched the web but cannot find...

is it possible to write a macro/procedure/function to insert data to a particular table with the database name of where the data is coming from as a parameter to the macro. CREATE MACRO InsertData (pDB as varchar(25)) ( INSERT INTO DestinationTable SELECT column1, colum2 FROM...

thank you all for responding. I ended up finding a solution and using a combination of SUMproduct and subtotal: =SUMPRODUCT(SUBTOTAL(3,OFFSET($AL11:AL$11,ROW($AL11:AL$11)-MIN(ROW($AL11:AL$11)),,1)), --($AL11:AL$11=$AL11)) and then when formula's were copied down I could do a search for...

any pointers as to how I would use subtotal to only count unique values? I am looking at frequency but not sure if this is correct. Also the values I want a unique count of is not a number but is text. many thanks. neemi

I have an excel spreadsheet which I am trying to count the occurance for only within a filtered range. Does anyone know how I can do this? What I am ultimately trying to do is build this into a sub total row so that it only adds up the values once within the sumproduct. I thought if I can...

Hi I am trying to run my first fast export script however I keep getting an error and have no clue what this could be? I have simplified the sql just to try and get something working but still no joy. The error I get is as below UTY3401 End of file was reached with an unbalanced number of...

Hi I am new to Teradata fastexport but it sounds like exactly what I need to be able to export large amounts of data from a teradata db, But I need advice on what I need on my machine to be able to use this? I currectly have Teradata SQL assistent and the teradata utilities which only include...

Can someone please point me in the right direction as to which files I need to be able to run a FastExport Script I know with fastload there is FastLoad.exe. and to be able to run a script certain files need to exist. Is fexp.exe is what is needed to run a fastExport script? and if running...

Hi I just wanted to get idea's from people how they handle cross universe reporting, and also to get any possible idea's of alternate ways of doing this. The scenario is that we have 3 universes with various number of databases on each representing various countries for example. My problem is...

can someone help me with how I would remove spaces from a field in teradata. I know I can use trim for white spaces but I want to remove all spaces in the field so for col1 if a record has "123 456 72" I want to return "12345672" back in my results. Many thanks, Neemisha