I have a table containing 6 fields ( Varchars ) I have ceated a query Select F1, F2, F3, F4, F5, F6, Count(f1) AS TOTALRETURNED From Table 1 Where (F1 = ' Value' AND F2 = ' Value) Group By F1, F2, F3, F4, F5, F6, TotalReturned This should only ever return 1 record. The problem i am ge...more >>

when i compile the dmsamprovider code ,there are some wrong as follows: e:\dmsampleprovider\putl\putillib.h(48) : fatal error C1083: Cannot open include file: 'jetoledb.h': No such file or directory Can you tell me the reason for this,and i want to know if i want to add my algorith...more >>

Hi All, There is a function in Access called "Last()" which returns the last record value in a group. For example. A B ------- 1 10 1 7 2 21 2 2 2 4 3 6 Here, Last() function In Access returns as follows: A B ------ 1 7 (the last value for A=1) 2 4 (th...more >>

Hello, I want to find out which is the best and efficient way to delete duplicate records in one table? Any ideas? Thanks, Derek...more >>

Hi, I run the following query select distinct a.fk_productid from v_testview a inner join TestProduct b on a.fk_productid = b.fk_productid Where b.fk_rsuid = 5 and b.active = 1 and a.quantity > 0 and a.fk_rsuid = 5 If I use fk_rsuid=1, then it only take about 14 sceonds. If I use ...more >>

I am trying to create a mining model so I can predict a shipment date based on past purchases. Can I have the shpment date be the predictable column or is that considered continuous and will not work? Also, I am a bit confused as to how I would tie together the purchases, shipments and p...more >>

I'm trying to find a way to set the decimal places returned in an expression through a view, I've listed the SQL statement below. The two expressions I am looking at are the PagesHr and the BatchesHr, they are showing 12 decimal places and I would like the to show only 2. I've used the LEFT and...more >>

The scenario: two tables CustomerTable --------------- CustomerID OrderID CustomerName CustomerEmail CustomerPhone OrderTable --------------- OrderID ProductID ProductName ProductCost This database was handed to me and I was asked to solve a problem - it looks like an inner j...more >>

Hi :) and thanx for reading my post. I have to create a view based on a character in a number-field (fnr) which is 11 char's long. I have to get character nr "7". The problem is that i cannot use : --> SELECT fnr FROM table WHERE substring(fnr,7,1) since it's not a string. Any other wa...more >>

hi all I'd like to know the differences between set @var=var select @var=var They are used to assign the var to @var. but is any difference in order to use the cache? I assume there is no difference because I dont change any table, so the sp is recovered from the cache either way. is...more >>

Greetings - My company is looking at bringing several of our people up to speed on Microsoft SQL Server 2000 Analysis Services - Course Number MS2074 or equivalent...... Can anyone refer us to a Washington, DC-area trainer with whom we might be able to strike a deal directly? We're also co...more >>

Date: Wednesday, November 19, 2003 Time: 10-11 AM Pacific Time (11-12 PM MT, 12-1 PM CT, 1-2 PM ET, 18:00-19:00 GMT) Join experts from Microsoft and Aspirity as we discuss topics ranging from simple calculated members to advanced MDX expressions and queries that maximize the information st...more >>

Thanks to Peter Kim's detailed instructions, I ran the a simple artists to customers mine and was successful in retrieving the data, but I am having trouble reading the results from Analysis Server. It shows a number of colored boxes connected by missing/exists lines. Here is my question:...more >>

I'm new to this SQL stuff i have a SQL DB that has MS Word documents stored in OLE blobs. is there any way to search the text in blobs? Any advice is appreciated thanks Joe ...more >>

Is there any type of formula to determine how much disk space is needed to fully process a mining model in AS. I have tried running one against a DB with only 130,000 appx records with over 7GB free and it keeps running out of disk space. Any estimate would be appreciated. Thanks...more >>

Hi, I created a cursor for a temporary table. such as : declare person_cur cursor for select person_number, provider from #temp_col order by person_number But later, I tried to update the data in the temporary table, like: update #temp_col set provider = 'N' where current of perso...more >>

Hi, How can I comapre two fields if one is the a substing of the other? Thanks, ...more >>

Hi, I'm using the SQL like syntax for Data Mining and would like to output a prediction and the associated probability, so initially I thought I would use Predict ([A}), PredictProbability([A]). The Predict function by default excludes NULL values which is what I want, however the PredictPr...more >>

Need a help! Anybody knows easy way to resize the database? I originally create with 40 gig and I need to resize to 2 gig. Thanks....more >>