Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server (for this, use the sql-server tag), nor does it refer to specific dialects of SQL on its own.
0
votes
0answers
15 views
database design for Media company in SQL 2008
I have to make the report for one of the client. There are three sources from I will get all raw data, so eventually I will have to marry those all data from different sources and make one report. ...
-1
votes
0answers
41 views
Storing text file to SQL Database Table in C#.net [on hold]
Can you please help me store a text file which consists of 4 letter words sepperated by space, looks like this: ASDF FGHJ JKLP UTYP etc... in an SQL Server database which has ID of the word ...
3
votes
3answers
335 views
Is it better to use a switch statement or database to look through 5,000 to 10,000 instances?
I have some JSON data in this format (5,000 instances for now):
{"id":"123456","icon":"icon.png","caseName":"name of case"}
I am allowing the user to search for the name of the case and then return ...
4
votes
4answers
268 views
Choosing value in SQL query vs (Java) code
I need to choose one of three values of an integer using the value of a column on a nullable column of a table.
There are at least two approaches: 1) use SQL to do all the work: test null values, and ...
0
votes
3answers
107 views
High-Level SQL Interoperability
In a server -> client scenario, wouldn't it be simpler and faster to grant a public user access to a Stored Procedure rather than using web services (XML, REST, SOAP, etc) and other interoperable ...
-1
votes
0answers
21 views
Seeing custom vars in Google Analytics [on hold]
I have a website. To track the mail address of my users on Google Analytics I include the following script:
_gaq.push(['_setCustomVar',
1, // Slot #1
'email', ...
-1
votes
0answers
44 views
Subtracting dates in PHP error? [closed]
I am getting a date from my MySQL database and using strtotime to convert it into UNIX_TIMESTAMP, and comparing it to the current date which I receive from PHP's time(). However, I'm getting really ...
0
votes
1answer
37 views
How to combine Google Analytics with Relational Database
I have a website with quite a lot of registered users, they are stored in a PostgreSQL database. I also running Google Analytics on the website to track the users. Is there a way to individually ...
0
votes
0answers
7 views
Implicit conversion between integral data types and strings in Transact-SQL [migrated]
While dealing with a bug, I've noticed that SQL Server 2000 performs implicit conversion between integral data types and strings, even without a warning. Thus, the following query:
SELECT ...
1
vote
1answer
273 views
Creating a online database creator
I've been thinking of creating an online database creator (think DabbleDB, Zoho Creator, Intuit Quickbase, etc.).
I've been thinking of a couple solutions:
Have 4 database tables: Tables, Rows, ...
0
votes
4answers
113 views
When to store Date/DateTime?
I'm working on a social network website and I'm not quite sure when I should store the date/datetime. The service includes some of the following events:
Register/Login
Follow
"Like" (images & ...
1
vote
1answer
78 views
Mental schema for SQL queries
While preparing SQL introductory material, I've ended asking myself about the line of thought followed by a developer when writing a query. I believe it could be too valuable from a beginner's point ...
-2
votes
1answer
70 views
Finding next free IP in a network
I have an IP network and want to automatically find a free IP address to provision a new server. Due to frequent server additions/removals the used IPs might be quite fragmented over the whole address ...
2
votes
0answers
84 views
Match buyers and sellers based on date ranges and quantity of shares
NOTE: This is in reference to the question I asked on Stack Overflow but was told to post this here
I'm building a trading application that matches buyers/sellers that own subscription. Subscriptions ...
0
votes
0answers
9 views
Dynamic query in SQL SERVER 2005 [migrated]
I have a sql query which uses a inner join with table t1 which has two fields as ID and FID, in the SP there are two variables @ID and @FID, Inner join as
Inner Join t1 on t1.ID= @ID and t1.FID = ...
