|
thanks for Solution,
but i wanna something like this cause the speed is very hight and wont take time :
SELECT tt.IdAmlak, tt.ParentId, tt.NameOpp, tt.Price, tt.[Square],
tt.OstanShahrMantagha, tt.PhoneAddress, tt.CountAmount
INTO TestTable
FROM tblTesting tt
tblTesting : Table in database Sql Server 2008 in server internet <br />
TestTable : Table in Database SQLite in local (android mobile)
|
|
|
|
|
Well, if you can have an ODBC connection to the server on the web, and one to the android device, there's no reason why you couldn't do something like that. I'm not convinced it would be quicker than simply downloading the csv file and processing it locally in one go...
|
|
|
|
|
thanks for solution
can u give me a sample for
csv file and processing it locally
and i can do this also ,so plz give sample :
if you can have an ODBC connection to the server on the web, and one to the android device
|
|
|
|
|
To create a csv file, simply run a query on your sql server and save the results to a file.
For the ODBC connection, create a couple of DSN's locally (one to the sql server, one to sqlite), then from a common location connect to both and run your query. This might be possible through a local SQL Server Management Studio copy, or through anything else that allows you to attach ODBC databases, even MS Access... Warning - MS Access will be very, very slow.
|
|
|
|
|
i have googled
what about this sp :
insert into CRM-CMS.dbo.tableName
select * from [217.66.216.77,1633].CRM-CMS.dbo.tblTesting
|
|
|
|
|
Try just running the select portion of it and see if you return results.
Your insert will need to use a field list though, not *. eg: insert into table1 (field1, field2) select field1, field2 from table2
Also, you would need to clear the data from your local table first if you are wanting to replace it with the data from your server.
|
|
|
|
|
i got this code :
but cannot run for SQLite :
i get this error in sqlite :
SQLite error near "INTO" : syntax error
cmd.CommandText = @"SELECT top(5) IdAmlak, ParentId, NameOpp, Price, [Square],
OstanShahrMantagha, PhoneAddress, CountAmount
INTO Melk
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir'
).[CRM-CMS].dbo.tblTesting";
|
|
|
|
|
You don't want to do this using a linked server; cleanest way is to generate the CSV (there's documentation on the internet); to send the CSV, and to bulkload it.
SQLite does not use TSQL. If you use multiple database-systems from different vendors, it'd be preferable to keep your SQL in the SQL92-dialect.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Realy thanks!
I have installed an app android that do same as what i wanna and i have installed it and got this file that have info but cannot read that.
what type of data it have .is it SQLite or something else.
how can i do that same?
download the data file :
http://upload.ugm.ac.id/221asnaf
and download app :
http://upload.ugm.ac.id/561A0829-MashaghelHamrah.apk[^]
thanks in advanced !
|
|
|
|
|
Is this a once off operation or do you need to repeat it. One time, use the CSV method.
If it must be repeatable then you need to set up a service (WCF) between the databases, you should not connect an online database directly to a remote database.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
thanks for solution
I need to connect and get all info every 2 days.
cause the data of that table change every 2 days.
|
|
|
|
|
Then you need to build a service between the databases, we use WCF.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
can please give small sample?
|
|
|
|
|
There are plenty available with a quick search here articles[^] and google[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i got this code :
but cannot run for SQLite :
i get this error in sqlite :
<code>SQLite error near "INTO" : syntax error </code>
<pre lang="sql">cmd.CommandText = @"SELECT top(5) IdAmlak, ParentId, NameOpp, Price, [Square],
OstanShahrMantagha, PhoneAddress, CountAmount
INTO Melk
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir'
).[CRM-CMS].dbo.tblTesting";</pre>
|
|
|
|
|
At a guess I would say SQL Lite does not support INTO so make the query like a normal insert statement.
Insert Melk (field, names, list) Select ...
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Ok here is my issue. I know how to do a count, count distinct and all that.
I have a column in my table that has 3 different values(only three, never more), so every row that is entered with have one of those three values.
The values are,
Bundle
Bowed Board
Jam
I am trying to figure out how to write a query that will count how many times of EACH value there is in the table. ie... 55 bundles... 10 bowed boards.... 5 jams...
for some reason I just cant get this one in my head. any help to be had? I do need it to be a single query as it is going in a dataset for a SSRS report Matrix.
Treat stressful situations like a dog, if you can't eat it, play with it or screw it, then just piss on it and walk away.
Be careful which toes you step on today, they might be connected to the foot that kicks your butt tomorrow.
|
|
|
|
|
select sum(iif(FIELDNAME = 'Bundle', 1, 0)) as NumBundles,
sum(iif(FIELDNAME = 'Bowed Board', 1, 0)) as NumBowedBoards,
sum(iif(FIELDNAME = 'Jam', 1, 0)) as NumJams
from TABLENAME
One option that doesn't rely on any rollup or compute magic...
|
|
|
|
|
That didn't quite work but it did set me on the right train of thought and for that I thank you much.
Solved with a couple of simple views combined in a query and let the SSRS report handle the count..
And I can easily reuse the views in a couple of other reports for different level of management..
Treat stressful situations like a dog, if you can't eat it, play with it or screw it, then just piss on it and walk away.
Be careful which toes you step on today, they might be connected to the foot that kicks your butt tomorrow.
|
|
|
|
|
No worries... Glad someone's making progress today... I'm still in SQL hell... (See post below)
|
|
|
|
|
What is wrong with group by and count
Select Fieldname, Count(*)
from Tablename
Group By FieldName
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The OP said they already knew about count, so I assumed they were wanting the three values on a single line...
|
|
|
|
|
Missed that, it did seem too simplistic to me!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi
Its simple Use COUNT Function... like as follows
SELECT CAST(ISNULL(COUNT(ProdType),0) AS VARCHAR(10)) + ' '+ ProdType FROM ProdDtls GROUP BY ProdType
Regards,
GVPrabu
|
|
|
|
|
One of my clients has upgraded to 64bit SQL Server 2012. We have moved the test database there and I am having a bizarre issue that's doing my head in...
Even the most simple update query causes an error, which of course, is causing stored procedures to fall over...
update tbl_User
set USR_Email = 'myemail@domain.name.au'
where UserID = 5
causes the following error: "Msg 102, Level 15, State 1, Procedure tbl_Userupdate, Line 53
Incorrect syntax near '@errorNumber'."
The strange part is that the query itself runs fine. Any suggestions? Perhaps a setting that's been missed by the sysadmin who did the installation?
|
|
|
|