Take a look at the INFORMATION_SCHEMA views in BOL - you'll get the constraints from there.  But the actual CREATE script - not available from a system view as far...

Yes, use Query Analyser.  Open the Object Browser and browse to the table you wish to script.  Right click it and select 'Script object to new window as / Create'...

The error messages, in this case, are accurate and I presume that you understand why they are appearing.  I have no experience of Sybase, so I cannot comment on why...

Try this for SP level:

SELECT SERVERPROPERTY ('productlevel')

One of the simplest ways is to change your data to a consistent format, eg:

1.00, 1.01, 1.02, ..., 1.10

would work.

But if that doesn't suit, you need to write some...

You are correct ... SQL Server treats nulls as special and you will often find that comparison operators (= <> etc) do not return rows where one of the items...

So your first query is to return a list of valid clients - and then you need to join that with 'table'.

To select valid clients:

select distinct t.client from table t...

Hey, you guys are ganging up on me ... it was late, I was tired & just trying to help

Anyway, my solution requires...

Would it be simpler to do this in two stages - using two resultsets (one for each 'type' of records)?

select 'in table1 not table2' Type, t1.id from table1 t1 where t1.id not in (select t2.id from table2 t2)

union

select 'in table2 not table1' Type, t3.id from table2 t3 where t3.id...

select a1. caseid, a1.datetransferred, a1.newowner

from AuditTrail a1 join

(select a2.caseid, max(a2.datetransferred) DateXfrd

from AuditTrail a2

group by a2.caseid) a2

on a1.caseid = a2.caseid and a1.datetransferred = a2. DateXfrd

Should do it (untested).  Don't see why...

Thank you everyone - sensible advice as usual - will pass on and discuss with my colleague.

Phil

Rather than using this

Set @NewKey=(SELECT MAX(SRid) FROM FG_ID)

Use this

Set @NewKey= scope_identity()

Check out this excellent article for more info on this:

http://www.sqlservercentral.com/columnists/awarren/checkyoursqlserveridentity.asp

Regards

No problem helping - post away!

Maybe I missed what you are trying to do.  The code I provided changes a character string from DDMMYYYY format into a format that can...

Sounds like your diagnosis is correct - you need to be comparing dates with dates.  Can you change the design on the SQL Server side?  Either change the datatype of...