Using MS SQL Server

Violation of primary key
Thank you for the pointers. It was indeed the source table that contained the duplicates. As far as using NOT EXISTS vs. the Left Outer Join syntax...isn't this more a matter of style than correctness? In a Left Outer Join the two fields in the destination would be NULL as the source records are not found in the... 31 Mar 2008 19:19

How to Interrogate SQL Server Tables for Specific Values - Here's how to do it in MS Access
On Mar 28, 10:35 pm, Tom van Stiphout <no.spam.tom7...(a)cox.net> wrote: On Fri, 28 Mar 2008 19:52:01 -0700 (PDT), robboll <robb...(a)hotmail.com> wrote: You may want to read up on catalog views such as sys.objects and sys.columns. The creation of XYZ* tables would not be needed. -Tom. ... 31 Mar 2008 20:00

testing if value is null
Hi, How do I write a query where if a column, "value," is NULL I return the phrase "No value entered" but otherwise return the column's value, even if it is the empty string? I'm tried to modify this simple query SELECT value FROM meta_data Thanks, - Dave ... 31 Mar 2008 20:39

delete output into <xml column of audit table>
Currently running Sql Server 2005 Is it possible to issue the delete command and capture the affected rows as xml types that will be stored in an audit table with an xml column? Something along the lines of: delete from source_table output (deleted.* into audit_table (xml_audit_column) for xml auto) whe... 31 Mar 2008 20:39

Help Needed For writting a query (SQl Server 2005).
Please post the query that you wrote. If you have it exactly as I posted it will give you the correct results. See the example below with the sample data you provided: CREATE TABLE Appraisals ( EmpNo INT, EmpName VARCHAR(35), Date_Of_Joining DATETIME, Date_Of_Appraisal DATETIME, PRIMARY KEY (EmpNo, Dat... 31 Mar 2008 20:00

Recursive Queries?
Iain Sharp (iains(a)pciltd.co.uk) writes: I appreciate that this is confusing, you should try it with the quantities and statuses of the relevant orders included. Basically we are modelling the pre-allocation of stock from purchase, through 0-n processing jobs, into sales. We store both purchase and proce... 4 Apr 2008 18:33

CS0246: The type or namespace name 'Namespace' could not be found (are
RoRo (RonaldaLajuan(a)gmail.com) writes: I added a class called Matrix to my App_Code File folder. It runs and compiles fine in the Visual Web Developer but when I try to view the page in my browser I get the following error msg. CS0246: The type or namespace name 'Mapack' could not be found (are you ... 31 Mar 2008 17:56

Internal query processor error
Zvonko Bi�kup (zbiskup(a)gmail.com) writes: I am trying to execute rather complex query, and I got query processor error. I read the Microsoft support page and it said I should install SP4, and I did, but the error is still there. There are probably more than one way to achieve an internal query processor... 31 Mar 2008 17:56

Complex Calculation
>I'm fairly new to SQL server 2005 database. The client wants to use weighted parameters(5) or areas of a project, rated from 1-5 on a scale of 1 being the highest, and the Cost of each project. i.e. Project A Param1=1, Param2=4 , Param3=1, Param4=2, Param5=5 , Cost= $50000 Using the least squares fit... 1 Apr 2008 17:54

CS0246: The type or namespace name 'Namespace' could not be found (are
I added a class called Matrix to my App_Code File folder. It runs and compiles fine in the Visual Web Developer but when I try to view the page in my browser I get the following error msg. CS0246: The type or namespace name 'Mapack' could not be found (are you missing a using directive or an assembly reference?)... 31 Mar 2008 17:56