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 TouchToneTommy 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: vbrunner
  • Content: Threads
  • Order by date
  1. vbrunner

    return X number of rows from a query regardless of Where match

    Hi I would like to return X number of rows from a query and sequentially number one of the fields regardless of matching the Where clause. ie: I would like this to return 10 records (with the field Nbr numbered sequentially) even if no data matches &quot;Price <= 10&quot;: Select Nbr, Type...
  2. vbrunner

    how do I return a fixed number of rows in a query -reagrdless of nulls

    Hi I would like top return X number of rows from a query and sequentially number one of the fields regardless of matching the Where clause. ie: I would like this to return 10 records (with the field Nbr numbered sequentially) even if no data matches &quot;Price <= 10&quot;: Select Nbr, Type...
  3. vbrunner

    Can't find API call to get file 'Version Other Information'

    I am able to get most of the file information I require; however, I can't seem to find documentation of how to retrieve file 'Version Other Information'. (see Version tab of file properties - Other version information is listed in lower half of window)
  4. vbrunner

    unable to reference user login in stored proc

    I have a stored proc that accesses another SQL database thus: &quot; + @sDatabase + &quot;.dbo.tablenamehere. This works fine for most cases but when I try to use this with a join from an empty table, SQL requires that I provide the database name. I need to work around this because the stored...
  5. vbrunner

    SQL2000 returns null where SQL7 returns empty string

    I am testing a SQL7 to SQL2000 migration and have come across something that I can't find the source of. I have a view in SQL7 that returns an empty string if a field in the source table is Null. The same view in SQL2000 returns Null in the same circumstance.

Part and Inventory Search

Back
Top