Home » Databases » Page 32198

I would like to start using Node.js for a project I'll be working
on.


I have streaming position information in an electric
car, and I'd like to store this locally on a small database in the car
and synchronize it over a (fragile) 3G connection, when this
connection is up, to a server with a large DB. So:



Car Os 3G Server OS
Data stream ---> ------
---> ---------
Node.js Node.js /> MongoDB MongoDB

Small DB Large DB

The part that I'm worried about is
how to sync the local DB to the ser

I have got the following join:


SELECT l.cFirma AS
Lieferant,
SUM(la.fEKNetto) AS Verbindlichkeiten,

l.kLieferant AS Lieferanten_ID,
100 - gk1.fFaktor *
100 AS Grundkondition,
MAX(gk1.dDatum) AS Datum
FROM
tBestellung b, tArtikel a, tBestellpos p, tLieferant l,
tLiefArtikel la, tGrundkondition gk1
WHERE

CAST('01.01.2010' AS DATETIME) <= CAST(b.dErstellt AS DATETIME) /> AND b.cType = 'B'
AND
p.tBestellung_kBestellung = b.kBestellung
AND a.kArtikel
= p.tArtikel_kArtikel
AND l.kLieferant =
la.tLieferant_KLieferant

hy there!


given:


| name />-+---------------------------
| Josef Knoller
| Josef
Somos
| KFZ Wiesauer

wanted result:

/>JOSEFKNMLRZWIAU

(case in the result does
not matter - it was just easier holding the UPPER key while
writing)


is there any way to do this in mssql?

/>

thanks in advance!


EDIT
sorry ... i've mixed
column and row ...
it's 1 column and n rows

/>

MLRZWIAU


M comes from Somos />L comes from

How would I go about generating a list of sql jobs and their
owners? I would also like to be able to generate this list for SSIS
packages also.


Thanks

I have a table with log data, of this form:


Date
Time Device Configuration
01.01.2012 12.00 8193
12345
01.01.2012 12.15 8193 12345
01.01.2012 12.35
8193 22375
01.01.2012 12.37 7191 32335
/>

I need the maximum Configuration, on each Day, for each
device:


Date Device Configuration />01.01.2012 8193 22375
01.01.2012 7191 32335 />

I can create a cross product of Dates-devices to get
all Date-device combinations,
but how do i find the maximum
configuration for each Date-Device pair?

I created a view. The view's Query works fine. Now I want to write
another Query which uses the first one. As far as I know it should
look like this:


SELECT * FROM myView;
/>

Now there is an Error returned: "Ungültiger Objektname 'myView'"
in English its something like "unvalid object name 'myView'.

/>

How do I refer to or call views the right way? I#M using SQL
Server.

I guess it's quite a common problem in databinding scenarios. />What do you usually do, if you are running a batch update and want
to avoid that a propertychanged-dependend
calculations/actions/whatever are executed for every single
update?


The first thing which usually comes to my mind, is
to either introduces a new boolean or unhook/hook the eventhandler,
...


What I don't like about this approaches is:

/>they introduce new complexity (has to be maintained, ...)
they
are error prone, because you have to make sure that a suppressed
notifications are sent afterwards

I'm wondering if somebody
addr

Question: I've several text files containing sql create
table/column/view/storedProcedure textfiles. Now I want to merge the
textfiles into one textfile.


I go into the directory, and
type:


type *.sql >> allcommands.sql />

Now to problem is I should add the text ' GO ' after
every file's content.


I can append Go by doing

/>type *.sql >> allcommands.sql & echo GO >>
allcommands.sql

But this only inserts go once. />How can I accomplish this with DOS commands ?

Hows does Drupal 6 interact with MySQL for connections and
transactions? Does connection pooling get used? How are transactions
handled? At what level are these things managed by Drupal vs being
handed off to be handled by MySQL?


I did a good amount of
searching on the web and within Stack Overflow, but mainly, I only
found articles for tweaking Drupal performance and scaling needs.


- Technology - Languages
+ Webmasters
+ Development
+ Development Tools
+ Internet
+ Mobile Programming
+ Linux
+ Unix
+ Apple
+ Ubuntu
+ Mobile & Tablets
+ Databases
+ Android
+ Network & Servers
+ Operating Systems
+ Coding
+ Design Software
+ Web Development
+ Game Development
+ Access
+ Excel
+ Web Design
+ Web Hosting
+ Web Site Reviews
+ Domain Name
+ Information Security
+ Software
+ Computers
+ Electronics
+ Hardware
+ Windows
+ PHP
+ ASP/ASP.Net
+ C/C++/C#
+ VB/VB.Net
+ JAVA
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow