Removed

you could do it dynamically, but not sure about the logic issue that Steve brought up.

declare @vs_sql nvarchar(1000)

IF 1 <> 0

BEGIN

set @vs_sql = '

Select ''A'' field1 INTO #myTemp1

select...

if you setup the foreign key to cascade deletes, then you won't need the overhead of a trigger. It will handle multiple deletes and you will never have orphan...

@@Error reports the error from the line directly before it. One of the issues with it is the severity of the error. If it is 16, then you...

You might want to think about reversing the foreign key. In you scenario, you will have to insert the address first and then get the ID to put into...

do you have any table layouts and sample data? What have you tried so far? Is there a reconciled flag in the table? If you provide sample...

Do you have any DDL and sample data for us to use? Also what have you tried so far. See the first link in my signature on how...

I was able to do this using dynamic syntax and a temp table. Here's an example

declare @filname nvarchar(50), @vs_Syntax nvarchar(max)

Create table #vt_Results (XMLPath nvarchar(200))

set @filename = 'c:\File.Config'

set @vs_Syntax =...

set Ansi_Warnings off. Look at this code. The first select returns the correct number, but also the message "Warning: Null value is eliminated by an aggregate or other...

acogswell,

you can download a...

It would be much easier if you provided table scripts and sample data. Can the project be in the table more that twice? If so, how should that...

You said that you were trying to create a unique index on date. In order to do that, you can only have one date. What were you looking...

The reason for the duplicates has to do with the join. It is returning every date and then just finding the previous time. Try this

declare @sp-2...

you can also use the output clause if the data is accessed through stored procedures. It would have to be added to each proc where the data is modified...

Henk,

here's a starting point for you.

-- Create and Populate Regions Table

declare @Regions table (RegionName varchar(30) not null)

insert into @Regions

select 'North America' union all

select 'Latin America' union all

select...