You could use one view to join the data together but you would need three transform steps in the package. Each one would take data from the view and insert...

I dont think it can be enforced with a constraint - it seem more like business logic. You could try maintaining Tabl 3 through a trigger and poulate T2ID from...

You could write three views at the source end that combined the 5 down to 3 and then select from the views. 

Hi - check identifiers - overview in BOL. Basically

1 to 128 chars. Start with a letter or underscore. I think you can start with # or @ but it...

Try doing a PRINT @sSQL and then try to execute the output.

Hi - there was a recent post on this site that might help you. The post is about TempDB but it relates to any DB. The problem seems to be...

Hi David, this is an old trick used by developers when they ran out of transaction log space.I would never use this command on a production server, it breaks the...

If you use dd-MMM-yyyy you can use this irrespective of the date format. EG. 15-MAR-2006. And it can be read correctly by anyone.

I can cut it down by one view which should improve performance.

CREATE VIEW vwStartAndEnd

AS

SELECT

 t1.i,

 CASE

  WHEN t2.i IS NOT NULL THEN 'Start' 

  WHEN t3.i IS NOT NULL THEN 'End' 

  ELSE 'Error'

 END...

This should get you there but I'm sure there is a more elegant way. Watch out if you have lots of data - I think the the 2 * 3...

That will just give you syntax errors - double up the single quote.

Hi try where col1 = 'abc''def'

Two single quotes, the first quote 'escapes' the the second quote effectively saying the quote is part of the string and not the termination...

There is a nrticle here http://support.microsoft.com/kb/295114/EN-US/

it relates to SQL 7 DB's upgraded to 2000.

Hi Robert,

My approach would be to datetime stamp everything on load (this can be handy anyway) and then bcp out to a text file and archive on DVD.

David Poole...

I tried the code from Micheal and got  'Invaluid SQL Statement; Expected 'DELETE','INSERT',....'

Getting rid of the drop gave me 'Syntax error in CREATE TABLE statement' (I suppose because the table...