0
I have a table with
User_ID, Resource_ID, Location_ID, INstance_ID
1,1,1,1
1,1,2,2
1,1,2,3
2,2,3,4
2,3,3,5
2,3,5,6
3,1,2,7
3,1,7,8
4,4,1,9
4,4,2,10
5,5,1,11
1,1,3,14
4,4,1,15
1,1,10,18
1,1,1,19
5,6,1,12
6,7,3,13
6,7,1,17
I need a list of instance_IDs where
For a specific User...
I am running SQL search in MS Access 2003 with a column named COLUMN_a that I want the value to perform LOGARITHM function. I couldb't get it work. The code that I am using is:
SQL="SELECT ID, ... , (10*LOG(COLUMN_a)), ... FROM everything"
Much appreciated for the help.
Kong
Does anyone know definitively whether SQL Server 2012 handles so-called "optional parameters" in stored procedures better than previous versions of SQL Server? For instance, a query like (but a little more complicated than) this:
select my.*
from cms.MeasureYear my
where (
...
I'm currently working with Ebean for database abstraction. My test database is Postgresql 9.3
I turned on logging for the SQL queries to test some code behavior.
So, assume 2 tables, OneToMany relation. In the code, this will have fields on the objects to represent it.
So for instance, class A...
How to write a SQL Expression to match the data of a dimention between the same table.
regards
dake
What happens when you do this?
DECLARE @REAL_DATES TABLE
(
CompletionDate VARCHAR(46)
);
INSERT INTO
@REAL_DATES
SELECT CompletionDate
FROM dbo.Entity;
SELECT
CAST(RD.CompletionDate AS datetime) AS casts_fine
FROM @REAL_DATES RD;
What I was getting at on twitter was ...
Stack Overflow's 6th moderator election has come to a close, the votes have been tallied, and the 3 new moderators are:
They'll be joining the existing crew shortly — please thank them for volunteering, and share your assistance and advice with them as they learn the ropes!
For details on ...
