Search results for query: *

I have an order processing system, which needs to provide a customer with his position in the waiting queue for his order. I tried to use the ROW_NUMBER() function in a CTE (Common table expression) and then select the row pertaining to the Customer. however it says i cannot use a ORDER BY...

I have a table structure that represents a queue, like so.. ItemNo PrecededBy 1 NULL 3 1 4 3 5 6 6 4 can anyone suggest any efficient ways of processing such a structure? for example if i need to find the last item in the queue etc.. im...

I need to update multiple coulmns in a table based on multiple from a Crossrelated subquery. the query to update a single column is as following UPDATE VERSION VER_ID = SELECT MAX(VER_ID) FROM MEETING_VERSION any ideas on how to do this to update multiple columns?

hi.. i have a periodic job running on a table. the job script includes a transaction. there is a separate .NET application accessing the table for data reads. due to the very large frequency of data reads, i need to avoid blocking by the job. how can i achieve this? the following is a sample...

Im using VC++.NET as my IDE and create an ATL project using it. basically the program is a Wrapper DLL for a DLL already written in VC. the wrapper is written to interface between VB and the original DLL cos of type incompatibilities. basically the problem is im unable to declare a variable...

I have a enum declared as follows enum StatusLevels { eConversionStatusNone= 0, eStatusInProgress = 1, eStatusSuccess = 2, eFailed = 3 } StatusLevels; im using this within code to cast a variable of type short to the enum type as follows StatusLevels eStatus; eStatus=static_cast<StatusLevels>...

Im involved in maintaining a already developed application of which a major component is written in VC++. i have a requirement to add a global enumeration to the component. so that it maybe exposed to the VB application tht is using the DLL. currently global enumerations have been defined in...

I have a ASP.NET web application in which i need i have a multiline textbox in which part of the text need to be colored and highlighted. i can achieve the same thing in a windows app by using the Richtext box and its properties of SelectionStart, selectionColor and SelectionLength. however the...

i basically want to get a count of all distinct values in a specific column. i have the following statement which returns unique tranid's . distinct clause is necessary cos table contains duplicate tranid's. "select distinct tranid from temptransactions" how do i get a count of these fields...

i have a transaction table that which looks somewhat like this, only a lot more data TranID ITEM 1 soap 1 coke 1 bag 2 coke 2 apple 3 soap 2 apple i have the following statement to show association rules...

is there anyway i can restore a Sql server 2000 backup on version 7..or any other way i can use the same database on version perhaps by attching the database

im trying to access 2 exchange server admin mailboxes.. each on a different LANs. on LAN 1 , im the server administrator . i created a mail profile under my name and opened it. and i was able to access the necessary info through CR . i created a diff mail profile under the name of the LAN 2...

i'm using CR 8.5 and i have a detail report displaying records from the database. the table has call logging info ..such as dialledno,date,time,duration ,charge etc. i need to filter all dialled no's which have been taken within 10 minutes (variable) of each other. how can i do this?

i'm creating a report in CR 8.5 which displays recprds from a database. i have grouped the report using a field. and i want the records relating to the group to be printed only if a summary field i have added for the group exceeds a particular amount. other wise i need to suppress the whole...

i have a report grouped displaying summarised information in the form of running totals. the running totals are in the footer, while the group name is in the group header.the detail section have been suppresed. the problem is in some pages, the group header is displayed at the bottom of the...

i'm using CR 8.5 and i have a set of numbers which i want rounded up. i used the format menu to round..it but it seems to add to the higher number when the number is a 5. for eg: 5.875 rounded up to 2 decimal places is 5.88 which is correct , because the preceeding digit before 5 is 7 and...

i have 2 tables to extract information from. one is really huge..around 200000 records and one has around 100. i have restricted the displayed reccords by using a selection forumula..which looks like this {dps.calldate}>=cdate({@DateFrom}) and {dps.calldate}<=cdate({@DateTo}) {@DateTo}...

i have two apps one using crystal 7.0 one using 8.5 .. the app using CR 7.0 does not work when used with the 8.5 ocx b'cos apparently CR 7.0 had a bug in it's original version and as a result reports done using CR 7.0 does not work in 8.5 without modifications. then again CR 7.0 will not...

I have two Applications which uses Crystal reports, one developed using a version prior to version 7 and one using 8.5 the one's developed using the old version compares bit data type field (boolean on SqlServer DB's) by comparing against 0 or 1. for example present=0 or present =1 (Present...

i have a report which summarises content in my employee database.i am using 6 tables Employee ,Dept,Section,Category,Attendance and Budjet the problem is when i include a field from the budjet table the summaries the report generates is incorrect. i have tried using formulas and running...