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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Referring to a Computed column in WHERE clause
Is it possible to do something like this? select (BillPrefix + ' ' + BillNumber) as Bill from Bills where Bill like 'HF 3%' I get an error when I execute this, but I want to be able to do a partial match over both columns. Is this something that could be done with a dynamic view (i.e., in the... -
Optimizing Complex Query
I'm needing some help optimizing a query. The following simplified query returns the results that I need, but the performance is terrible. Here is a simplified view of my data: Table: BillRequests BillRequestID ------------- 1 2 3 4 Table: ActivityHistory...
