Tagged Questions

Structured Query Language (SQL) is a language for querying databases. Questions should include code examples and table structure. This tag refers to the standard language, not for questions about specific vendor extensions, like MySQL or Microsoft SQL Server, so if you think your question relates to ...

learn more… | top users | synonyms (5) | sql jobs

3
votes
0answers
66 views

Dynamic Oracle Pivot_In_Clause

I'm kinda stuck. I want to do a user-role-relationship pivot table and my query so far looks like this: WITH PIVOT_DATA AS ( SELECT * FROM ( SELECT USERNAME, GRANTED_ROLE ...
3
votes
0answers
88 views

SQL Express client memory usage differs to SQL Enterprise client memory usage

I am experiencing a big difference in .Net application memory usage using the same app against two copies of the same database. The only difference is that in scenario 1 I am using a local copy of ...
3
votes
0answers
31 views

configuration of custome database with openfire

I am using the openfire 3.7.1.I have followed this steps to configure the custom database in openfire.The main problem is that if i set the property provider.user.className = ...
3
votes
0answers
133 views

get a listbox binding on both the calendar and a combobox VIDEO

I have filmed my problem as it is easier to explain on video. I want the listbox to display the time began from the bookings table, that relies on the date from the bookings table and the room from ...
3
votes
0answers
161 views

SQL Server specific types support for OrmLite

I just learned about a genius type that would simplify a lot of my work but it looks like my preferred ORM does not recognize it. Is there a workaround to let ServiceStack OrmLite recognize ...
3
votes
0answers
280 views

Google spreadsheet “=QUERY” join() equivalent function?

This question is concerning joining two databases in Google spreadsheet using =QUERY function I have a table like so in range A1:C3 a d g b e h c f i I have another table c j m a k n b l o I ...
3
votes
0answers
238 views

Magento - Single Coupon marqued as used when payment pending

I've got a problem with magento single coupon code that is marked as having been used at the time the customer click on the ‘Place Order’ button. If the Paypal payment fails or the client abandon, he ...
3
votes
0answers
146 views

Doctrine 2: How can extend entity with sql code column?

I have entity mh\BTBundle\Entity\Post: type: entity table: post repositoryClass: mh\BTBundle\Repository\PostRepository fields: id: id: true type: ...
3
votes
0answers
78 views

How to read tbf file with STAMP encryption

I have Toronto Stock Exchange stock data in a maxtor hard drive. The data is a TBF file with .dat and .pos components. The .dat file contains all the Stamp format transmission information in binary ...
3
votes
0answers
105 views

Is there a way to set defaults for generate scripts in SQL Server 2008?

Most of the time when I generate script in SSMS, I have to changed the exact same number of settings in the Generate and Publish Scripts wizard. Is there a way to set the defaults in this wizard ...
3
votes
0answers
188 views

Quickest method for matching nested XML data against database table structure

I have an application which creates datarequests which can be quite complex. These need to be stored in the database as tables. An outline of a datarequest (as XML) would be... <datarequest> ...
3
votes
0answers
1k views

Weird SSIS Error (Process Exit Code 255)

I'm having an issue with an SSIS job I recently created that is breaking with a strange error. Background Info This is an SSIS package (.dtsx) that is being run with a SQL job (SQL Server 2008, job ...
3
votes
0answers
198 views

Entity Framework migration with already deployed SQL compact database

My situation: EF 4.3, private install of SQL Compact 4, .Net FW 4, c# winform Problem: after the application was deployed there was the inevitable change requested that required me to create a new ...
3
votes
0answers
185 views

QSqlField name() method returns “”

I have a class (ServicesTableModel) which inherits from QSqlRelationalTableModel. In the constructor I have: ServicesTableModel::ServicesTableModel( QWidget* parent, QSqlDatabase db ) : ...
3
votes
0answers
159 views

Nlog database target - to use keepConnection or not?

I'm using NLog in an asp.net 2.0 application; it gets a lot of traffic and logs a lot of data (average about 5000 log records per day), for both error logging and statistical purposes. It uses two ...

1 2 3 4 5 … 1102
15 30 50 per page