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 ...
1
vote
1answer
11 views
SQL Query: Group Time into timeslices then group by loginname then count distinct loginnames per timeslice
I have a huge table containing starting times of the operation (starttime) + the user who started it (loginname) + a lot of date which is uninportant for the query i need.
From that i want to group ...
1
vote
1answer
9 views
Preparing a sql statement with odbc_prepare using wildcards
I am trying to protect myself from sql injection attacks using the odbc_prepare() function, then executing with odbc_exectue() but I am having problems doing this with wildcards.
My statement looks ...
1
vote
0answers
33 views
Datetime variable “tics” one hour
I have a strange problem with my code (or rather, someone elses code).
I'm runing debug and trying to figure out why our time shows up wrong.
Anyhow, this is the code that prints the time:
...
-1
votes
0answers
36 views
how to insert following string with character $ and { in sqlplus
I want to insert below string in database, but not able to do so.. please help me out...
str:Thankyou for your ${TOPUP_AMOUNT} in box top-up at ${DATE_TIME}.
Your balance is now ${TOPUP_BALANCE}. ...
0
votes
0answers
14 views
find all objects that belong to a relationship from an Array of NSManagedObjects
I have an array of NSManagedObjects. Lets call it Items. There are two more entities called Group and SubGroup. I have many to one relationship between Items and Group and Items and SubGroup. So an ...
0
votes
0answers
4 views
SQL compact synchronization
I am synchronizing sql server and sqlCE database. once the synchronization is over, I need to delete the Sync Completed records from SqlCE database.(not from server). so that I can keep the db size ...
0
votes
2answers
14 views
unable to access the linq to sql result in mvc4
I am getting result from theee tables usign linq to sql but i am unable to use the values in the view, how i can do that as i am new to mvc
here is my controller code:
public ActionResult Grid()
{
...
0
votes
0answers
20 views
Multiple ASP.NET Membership roles in the same Website
In my MVC3 application I have ASP.NET Membership roles like - Manager, System Admin and Editor
I am using Windows Authentication for the website and I am adding the users in the Network to the ...
0
votes
0answers
8 views
Access 2010 SQL - Show Duplicate Records in Order for eventual Deletion (pure SQL Solution pls)
I have the following table named 'flt'
You can see the duplicates are identifed by 3 columns only (flight, fltno, stad)... I don't care about what is in col1 and col2.. But I should be able to show ...
0
votes
0answers
39 views
return nothing from multiple tables join in mysql - three tables
I wrote the below sql query to get one video that not seen by the current user IP. But I always get no video. This is my code
SELECT ...
0
votes
0answers
24 views
android sql update table row with reserved word name
I have this line:
myDB.execSQL("UPDATE " + TABLE + " SET Storno = 'X' WHERE Date = '" + DATE + "'");
and it's not working...
In LogCat I'm not getting any error.
String TABLE and DATE are 100% ...
android
3
votes
2answers
22 views
Are Columns Not Selected in SQL Views Executed?
I wasn't able to come up with the right keywords to search for the answer for this, so apologies if it was answered already.
Consider the following SQL view:
CREATE VIEW View1 AS
SELECT Column1
...
2
votes
3answers
45 views
LINQ Query C# ASP
In English I'm trying to: "Return a list of People who don't have the TeamID in their List of Teams
I have a many-to-many relationship between a Person table and a Team table so each instance of a ...
1
vote
2answers
22 views
MSSQL not matching phone numbers with spaces
I'm trying to write an SQL query for SQL Express that will look up a phone number from the client's database. The issue I'm having is that some of the numbers in the database have spaces in them, but ...
0
votes
2answers
15 views
How to efficiently retrieve data in one to many relationships
I am running into an issue where I have a need to run a Query which should get some rows from a main table, and have an indicator if the key of the main table exists in a subtable (relation one to ...
