I need to write an SQL Select statement where the result needs to return aggregate values grouped by a range of values. Easier to explain in an example:
Table UnitsPerHour :
Hour Unit...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23303383.html
Zones:
MS SQL ServerDate Answered: 04/07/2008 Rating: 9.7 Views: 21
Sql Server 2000
First, I have no control over the decision to allow overlapping time. I'm "dealing" with the issue. :)
I created a View that has a union of two tables. Table A has billable ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23359385.html
Zones:
MS SQL ServerDate Answered: 05/08/2008 Rating: 9.4 Views: 0
My sql script which reconstructs a portion of a database does the following, which no doubt you're familiar with:
IF OBJECT_ID('dbo.web_paths', 'U') IS NOT NULL
DROP TABLE web_paths;
CREAT...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23413174.html
I have following data in a table
project_id --- customer_id --- product_line ---- Product ---- Quantity ---- Value ---- Div
---------------------------------------------------------------------...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2349...
I have a table with a numerical field that is the number of days since 1/1/1900. I need to produce a date in place of the numerical information. Can anyone tell me how to accomplish this?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23544342.html
Zones:
MS SQL ServerDate Answered: 07/22/2008 Rating: 9.9 Views: 0
Hi All,
This one has got me stumped.
For sake of argument lets say I have two tables test_table_1 and test_table_2 with the following columns:
test_table_1 : tt1ID (PK), tt0ID (FK)
test_table_2...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23699371.html
I am going through some design changes in my database. Basically, I have written this SELECT statement that gets the data I want. It puts a newly created "PositionID" with an employee based off o...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23719397.html
Zones:
SQL Syntax,
...Date Answered: 09/10/2008 Rating: 9.1 Views: 0
Hi,
I have a stored procedure that does not return the same records that when I run the query in the query analyzer.
The query in query analyzer give me back the good recordings. The stored p...
http://www.experts-exchange.com/Database/MySQL/Q_23741249.html
I have 2 tables:
Courses
course_id course_tile location
1 into to cs LA
2 intro to html Boston
3 intro to ajax SF
StudentRegistrati...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2379...
I have two questions.
(1.) Besides needing to satisfy the first normal form, is the second normal applicable only to enitities/tables that have compound primary keys? Or can it be applicable to a ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23838543.html
