Home » Databases » Page 32198

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

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
SUM(la.fEKNetto) AS Verbindlichkeiten,

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

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

hy there!


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

wanted result:


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

is there any way to do this in mssql?


thanks in advance!

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



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.


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

Time Device Configuration
01.01.2012 12.00 8193
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

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:


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

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

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, ...)
are error prone, because you have to make sure that a suppressed
notifications are sent afterwards

I'm wondering if somebody

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 *.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 >>

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
+ C/C++/C#
+ VB/VB.Net
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow