|
how to use Distinct in ms access
i want to count distinct starttime from table
i am using
SELECT Count(*) AS MessageCount
FROM
(SELECT DISTINCT StartDateTime FROM messages) AS T;
but it show all starttime count. its not show according different starttime count
Piyush Vardhan Singh
|
|
|
|
|
That should work. Are you sure that your values are not distinct? Have you taken into account differences in the time portion of the values?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Good Morning All
i have a Problem with my dts's , i see this Error. and i have to such DTS named "DTSSTEP_DTSDATAPumpTask_2" in my local dts that i use. where is it located ? here is the Error Message
http://vuyiswamb.007ihost.com/err.jpg[^]
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi All,
Iam having one table in that i have 3 fields
UserId Password ULock
veeresh xyz 1
1-Unlock
0-Lock
If some budy enters wrong password 3 times that userid should be locked.
i.e ULock value should be 0.I need c# code for this.Please help me on this.
i want to join this group
|
|
|
|
|
Hi,
Thanks friend.I wil try it now.
Veeresh
i want to join this group
|
|
|
|
|
My MFC Apllication connected to MS Access Database using ADO via Jet 4.0
(the connection string look like this
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=xxx.mdb)
Will my application work out of the box for every Windows XP/Vista ?
Is Jet OLEDB 4.0 Database Engine pre-installed on both XP/Vista ?
|
|
|
|
|
Ok, this is most likely an easy question, but for some reason I can't seem to get it to work. I have a SQL statement that is selecting data greater than a specific date. Do I need to convert the date somehow, because I keep getting incorrect syntax errors.
SELECT...
FROM...
WHERE DATESUBMITTED > 20040404 23:59:59
I tried single quotes, double quotes, leaving the time off... with no luck. There has to be a simple answer. I have a Pocket guide for SQL which has a few samples of convert logic, but is that really needed for this type of simple statement?
Any help is appreciated. 
Lost in the vast sea of .NET
|
|
|
|
|
Try putting the argument on the right side of your expression in single quotes.
...<br />
WHERE DATESUBMITTED > '2004-04-04 23:59:59'
I admit. I googled this. You can find more DateTime comparison methods here:
http://www.demiliani.com/blog/archive/2006/01/19/3384.aspx[^]
And probably in CodeProject as well.
|
|
|
|
|
Thanks, that worked! I just needed the dashes. 
Lost in the vast sea of .NET
|
|
|
|
|
|
The key is time,for example, every 10 records compose a group, so
group 0: 1st 2nd ...
group 1: 11th 12th ...
group 2: 21st 22nd ...
...
Now I want to get the sum of the first record of ten continuous group, so the values are from
records: 1st 11th 21st ... 91st
Does ado/mssql support this? Because my program need performance.
Thanks very much.
|
|
|
|
|
Hi,
Can you explain the table structure, like what keys you are having on it, its columns and their datatypes, etc?
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
OK, essentially, it is like this
Col Name Type Length(bytes)
Time(key) datatime 8
Price real 4
|
|
|
|
|
Hi,
You are using MS SQL 2005? And are you using group by on time column and want to sum the price, am i right my friend?
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
I'm using MS SQL 2000, I want to get the first record every n records.
For example if every group has 10 records, then the records I want are
1,11,21,31,41,51...
Doing it manually is too slow.
|
|
|
|
|
Hi,
Hopefuly one last question, do you have prior knowledge of the groups you will be making?
I hope i am not irritating you!
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
No other prior knowledge of grouping.
Like the Moving Average Line in stock software, only how many records consists of a group is known when grouping.
-- modified at 3:28 Wednesday 14th November, 2007
|
|
|
|
|
Hi,
I haven't tried it, just a thought, try with the preprocessing of the data, like write a procedure/routine for knowing groups, and keep a count of each groups rows, and pick by using that count.
Second idea is, to try with a Top function, in multiple sub queries, or via partitioning.
This is tricky, because you are trying to do multi-dimentional sort of activity, on a DBMS which is not much familiar to it!
Even in MS SQL 2005, it is bit difficult, but do-able, using the ranking function with top function.
Hope this is of some help.
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
I just worried about the performance, now I find that a creating a temporary table would solve the problem.
Thank you all the same.
|
|
|
|
|
im looking if exist Query do this
1-back up the database into specific path,
2-restore data from specific path.
3-return all of the user tables in specific database
thx
|
|
|
|
|
|
Why does this not work.....SQL
Declare @MyParam varchar (20)
Set @MyParam = 'MyTableName'
Select * from @MyParam
Seems obvious that it should, is it all TEMP TABLES needed.
|
|
|
|
|
Where exactly are you defining a temporary table in this example?
|
|
|
|
|
Hi, I'm not.
Just want to use a variable to access an exisiting table.
Select * from @parameter
is this not possible?
Thanks for the interest
|
|
|
|
|
ASAIK, you can only create a table[^] variable, fill it with data and then use in SELECT statements.
imnotso# wrote: Just want to use a variable to access an exisiting table.
BTW, why do you want to do something like this?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
