|
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?
|
|
|
|
|
have the sql query in a string variable and execute using sp_executesql or EXECUTE Command. something like this should work, try...
@SqlQuery = 'Select * from ' + @MyParam<br />
EXEC sp_executesql @SqlQuery
Regards
- J O H N -
|
|
|
|
|
You should always enclosed the table name in side square brackets just in case it contains any odd characters and the table name should be checked to see if the table exists first. These are very basic security precautions against invalid or maliceous data from causing problems with the database.
|
|
|
|
|
Thanks John,
but
declare @SqlQuery varchar
set @SqlQuery = 'Select * from raiser wHERE raiser.raiserid=3'
EXEC @SqlQuery
Server: Msg 2812, Level 16, State 62, Line 5
Could not find stored procedure 'S'.
doesn't work
what am I doing wrong?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
