Search results for query: *

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...

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...

Hi Group, Is there a function in crystal report which returns the number of days in a month if given a particular month and year. For eg. if i input 01-2003 it should return 31 02-2000 then 29 02-2001 then 28... Please tell me if there is a function...

Hi Naith, mbarron, I had tried by removing the Thousands separator but it didn't work. But by using totext({your number field},0,&quot;&quot;) I could remove the (,). Thanks for your help. Regards, ashark

Hi Group, I have customized a group name. It consists of a number field and a string field. eg. I have employee Number and Name 123456Employee1 My problem is I am getting a comma (,) 123,456Employee1 How can I remove the (,)???? Regards, ashark

Hi dgillz Thankyou very much. It helped. Regards, ashark