Recent content by ashark

Hi Freinds, Please can anyone help me with these: Which is the best answer for the Q 1. In Teradata's parallel environment, response time is as fast as -the fastest AMP invloved -slowest AMP involved -sum of all AMPs involved - average performance of all AMPs 2. Does a full table scan require...

How is the size calculated?

Hi Group, How do you find the size of a cube? Regards, ashark

can you please explain me how you insert multiple rows in a single SQL statement.

Hi swampBoogie, Do you want to say that : INSERT INTO Table (PriKey, Description) VALUES (123, 'A description of part 123.') union VALUES (124, 'A description of part 124.')

Hi Group, I wnat to insert more than one row in table. Can you please tell me how that can be done in one SQL statement Thankyou. ashark

Now it says "SQL server does not exist or access denied" Regards, ashark

I am trying to connect to SQL Linked Server.

Hi Group, I am receiving error while trying to connect to Linked Server Error 7399 OLEDB error trace OLE DB Provider 'Microsoft.Jet.OLEDB4.0' IDBInitialize returned Authentication failed. What can be the error? Regards, ashark

Hi Group, I think the Query which you need is SELECT * FROM Members WHERE MemberID NOT IN (SELECT MemeberID FROM Log WHERE PeriodID IN (SELECT PeriodID FROM Periods WHERE FromDate='01/01/2003')) You should not have a NOT in the second Select Query -Asha

Hi Group, What is the difference in the following queries : use pubs select t.title, p.pub_name from publishers as p inner join titles as t on p.pub_id = t.pub_id Order by title asc use pubs select t.title, p.pub_name from publishers as p ,titles as t where p.pub_id = t.pub_id Order by title...

Hi Group, This the First Query where I fill values and Grouping is at Order and Position Level. .... .... CASE WHEN max(OrderLineConfirmationDate) < min(OrderDate) THEN 0 ELSE 1 END AS OrderLineConfirmedFlag, 1 AS NoOrderLines FROM DW_PUR_HISTORY GROUP BY OrderNumber, PositionNumber Here is...

Hi Group, I have a very strange problem. I have a table and have built Views on that Table. I have built a view which fills the value 1 into a Column which is Grouped by OrderNumber and Position Number. I hve built another view on the top of this view which is Grouped by Order Number, Position...

Hi Group, Can following Condition be placed on the input paramteres? There are 2 input parameters A and B and the Sum of A and B should not be greater than 100 eg 1. A - 85 B - 15 should be allowed 2. A - 25 B - 15 should be allowed but A - 55 B - 55 should not be allowed...

Hi Group, I have some data which is Grouped by Items. I do some calculations and then divide Items into A, B, C. I have a calculated field for dividing Items into A, B, C. Now I need a Line graph on which X Axis is the Calculated field (which contains A, B, C) and on y axis some amounts. Can I...