06:00 - 19:0019:00 - 23:00
Given the table
Column | Type
id | integer
latitude | numeric(9,6)
longitude | numeric(9,6)
speed | integer
equipment_id | integer
created_a...
How to select distinct from table including ID column on the result?
Like for example: (this is error query)
SELECT ID,City,Street from (SELECT distinct City, Street from Location)
The table Location
CREATE TABLE Location(
ID int identity not null,
City varchar(max) not null,
Street varchar(...
I have a SQL Server table containing millions of transactions. I need to find the most recent & highest paid amount. The table is as follow:
Id (guid) ServiceId CreatedDate AmountPaid InsurerId IsCanceled
76E9A36F... 19 2013-08-30 12:34:01.580 56.00 ...
0
I have 4 tables built with JOINS and I would like to SELECT DISTINCT rows on the setsTbl.s_id so they always show regardless if there's relational data against them or not!. This is what I have at present which displays the data but doesn't display all of but not the entire distinct row!
SELECT...
Kama Sutra: A Tale of Love is a 1996 Indian film directed by Mira Nair. The film takes its title from the ancient Indian text, the Kama Sutra, but this only serves as a common link between the characters.
During filming in India, the name of the project was not revealed to government officials who would have denied the petition to film in India had it been called "Kama Sutra." Instead, it was called "Maya & Tara." Since government officials made many periodic visits to the set to ensure proper Indian film etiquette, the cast had to improvise fake scenes which avoided the nudity and s...
In SQL-Server 2008, you can add the values this way:
select cast(dt as date) + cast(tm as datetime)
from yourtable
See SQL Fiddle with Demo
I have two tables in SQL server 2008:
Definitions(ID, XML)
Data(DataID, DefinitionID, COL1, COL2, ..)
XML looks like this:
<definition>
<field columnname="COL1" fieldname="FirstName" />
<field columnname="COL2" fieldname="Surname" />
</definition>
What I need is something like this:...
Seriously? I showed you here that you can't use IN (@TVP) but instead must use a different technique, e.g. WHERE EXISTS:
WHERE EXISTS (SELECT 1 FROM @locations WHERE ss1 = Location_tbl.Locid)
You can also say:
WHERE Location_tbl.Locid IN (SELECT ss1 FROM @locations)
Or:
INNER JOIN @locatio...
**
Need Advice on building Real Estate Agency Website
**
I am making a Real Estate Agency Website Template/Application in PHP MySQL and XML.
For this i need to
Draw an ERD (Entity Relationship Diagram)
Create a DB (Database) according to designed ERD
Write a PHP Script..........and then on...06:00 - 19:0019:00 - 23:00
