sql

identity column in Sql server

Hi, Why does Sql server doesn't allow more than one IDENTITY column in a table?? Any specific reasons. ...

INNER and LEFT OUTER join help

Say I have 3 tables. TableA, TableB, TableC I need to operate the recordset that is available after a INNER JOIN. Set 1 -> TableA INNER JOIN TableB Set 2 -> TableC INNER JOIN TableB I need the Set 1 irrespective of if Set 2 is empty or not (LEFT OUTER JOIN) comes to mind. So essentially, I am trying to write a query and have come th...

Modeling atomic facts in a relational database

I want to record what various sources have to say about a historical figure. i.e. The website Wikipedia says that Susan B. Anthony was born February 15, 1820 and her favorite color was blue The book Century of Struggle says that Susan B. Anthony was born on February 12, 1820 and her favorite color was red The book History of Woman's S...

Removing existing profile providers

Hello, Q1 Book suggests that before we register new SqlProfileProvider, we should remove any existing profile providers using <clear> element. But: A) why must we use <clear> instead of <remove>? B) I assume that root web.config or machine.config don’t register (by default) any profile provider, and thus using <clear> element is no...

When is sqlite's manifest typing useful?

sqlite uses something that the authors call "Manifest Typing", which basically means that sqlite is dynamically typed: You can store a varchar value in a "int" column if you want to. This is an interesting design decision, but whenever I've used sqlite, I've used it like a standard RDMS and treated the types as if they were static. Inde...

How can I retrieve the values from a generic audit table reconstituted as a rowset with meaningful column names in SQL?

Hi gang, So I've got this audit table, looks like this: USE [DatabaseName] GO /****** Object: Table [ERAUser].[Audit] Script Date: 05/20/2009 17:07:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [ERAUser].[Audit]( [AuditID] [int] IDENTITY(1,1) NOT NULL, [Type] [char](1) COLLA...

Returning multiple rows per row (in Zend Framework)

I have a MySQL database containing these tables: sessions -------- sessionid (INT) [courseid (INT)] [locationid (INT)] [comment (TEXT)] dates ----- dateid (INT) sessionid (INT) date (DATE) courses ------- ... locations --------- ... Each session has a unique sessionid, and each date has a unique dateid. But dates don't necessarily...

SQL Server 2005 - If condition with union

Hello, I have a SP that has the following algorithm. IF <SomeCondition> BEGIN SELECT * FROM TABLE1 END ELSE BEGIN SELECT * FROM TABLE2 END --Union the above with the query below UNION SELECT * FROM TABLE3 The recordset returned is EXACTLY the same. I need to do a UNION of that resultset and another query. Is there a way to do ...

Oracle form builder not getting values from server

Hey all, I am logged into a sql server. when i insert values via SQL*Plus server, they are not registered by Form builder, but when i insert them using form builder, they do appear when i search for them on SQL*Plus... what is going on and how do i get form builder to register the values entered in SQL*Plus?? ...

Can we have more than one identity column in a table?

Can we Specify 2 identity column in a table.If no why ? if yes why ...

Uniqueness based on largest value where not all cells are the same

Let's say that I have the following result table from my SQL select: DocumentId CreationDate InstanceId ABC 10th Jan 0c60f4e2-02fc-4244-9ec5-4d259ea5774d ABC 11th Jan 2168ab5d-d6ca-4db3-90f0-b621d72108b8 BCA 4th Jan cb7cdf24-b50f-4bd9-b2b5-d58a14793dd...

SQL to select the middle third of all values in a column in PostgreSQL

Suppose I have a column of heights -- how can I select all and only those height values that are neither in the top 30% of values nor the bottom 30% of values. UPDATE: I'd like the answer for PostgreSQL (or, failing that, MySQL -- I'm using Rails). ...

KPI definition asking for advice

Hello everyone, I am looking for some reference/samples about how to define good KPI for education industry. I want to define KPI from school/department management perspective to measure various school performance, students/faculty/others. Any advice, referneces or documents are appreciated -- more appreciated if with the context of SQ...

How to update a datawarehouse after migrating to sql2005 from sql2000

Hi Guys, I apologise for asking basic questions but I'm new to Analysis Services and dimensional data. My current situation is, I have a sql server2000 database with a warehouse which was built by a previous developer. The warehouse and the transactional DB are on the same physical server. The warehouse is filled nightly by stored proce...

Stackoverflow Related questions algorithm

The related questions that appear after entering the title, and those that are in the right side bar when viewing a question seem to suggest very apt questions. Stackoverflow only does a SQL search for it and uses no special algorithms, said Spolsky in a talk. What algorithms exist to give good answers in such a case. How do U do datab...

Calculate the Sum of duration in sql query

Hello all, I have a table which has two columns start time and end time. I am able to calculate the time duration for each row but I also want to get the total duration. how to do this. Thanks ...

Is there any known issues with using linked servers between 64bit sqlserver2005 and 32bit sql2000

I seem to have problem getting linked servers working to query between database/servers running sql2000 32bit and 64bit sql2005. Is this a known bug? If so, is there a workaround, or fix? ...

EWS - import email into sql database

I've been trying to import the body from emails into a field in a SQL 2005 database but it keeps losing the formatting (carriage returns, tabs, etc) Anyway of getting around this? ...

SQL Server 2005 and temporary table scope

I've read around the subject of temporary tables and scope and all the answers i've seen don't seem to talk about one of my concerns. I understand that a local temporary table's scope is only valid withing the lifetime of a stored procedure or child stored procedures. However what is the situation with regard to concurency. i.e. if i ha...

oracle subselect with dynamic table and column

I would like to run the following SQL select: SELECT ID, NUMERATOR, (SELECT m.COLUMNNAME FROM m.TABLENAME p WHERE p.numerator = m.numerator ) VALUE, TABLENAME, COLUMNNAME FROM MainTable m; at the current state it doesn't run at all, naturally, because oracle doesn't recognize the m.TABLENAME at all. Is it possible t...