Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: daveroam
  • Content: Threads
  • Order by date
  1. daveroam

    A cpouple of OUTER JOINs, but want only one row from each

    Hi, I have this query SELECT c2.id_number AS Cusip, c1.id_number AS Isin, c3.id_number AS Sedol, c4.id_number AS Cusip144a, c5.id_number AS Isin144a, ISNULL(fii.party_short_name, fii.party_long_name) AS DESCRIPTION, bintostr(a.asset_id) AS ASSET_ID FROM govcorp..asset a LEFT JOIN...
  2. daveroam

    SQL Server 2005 ruins SQL Server 2000 ?

    Hi, On the weekend I installed SQL Server 2005 trial edition on my Db machine. Then I read somewhere that I should not open my existing SQL Server 2000 databases using it as it would irretrievably 'upgrade' them. I think usual M$ force upgrade trickery. There was no warning during the SQL...

Part and Inventory Search

Back
Top