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 derfloh 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: *

  1. dbljackson

    Like Condition

    Thanks Chris. Double qoutes worked. '' + @Cust_no + '' dj
  2. dbljackson

    Like Condition

    I would like to pass a parameter to a stored procedure thats used in a like condition of the where clause. Example: Select all customer that start with "A" Declare @Cust_no as char(4) Select * from customer where customer_number like @Cust_no Not having any luck with this. I have...
  3. dbljackson

    SQL 7.0 sp performance

    Thanks Malcolm, I actually have several of these aggregations so that may be the problem.
  4. dbljackson

    Listing DSN's on a machine in VB

    I found this and it seems to do the job. 'Declarations Private Declare Function SQLAllocEnv Lib "odbc32.dll" _ (phenv As Long) As Integer Private Declare Function SQLDataSources Lib "odbc32.dll" _ (ByVal hEnv As Long, ByVal fDirection As Integer, _ ByVal szDSN$, ByVal...
  5. dbljackson

    SQL 7.0 sp performance

    I am using SQL Server 7.0. I have a couple of queries that perform very different from the SQL Analyzer vs. Application GUI. I have a query that accepts four parameters. @date as datetime @Qual_no char(2) @Patt_no char(2) @Sku_no as char(16) select qualcode,pattcode,orderdate,qtyordered,sku...
  6. dbljackson

    Table.Col_Name Parameter in Aggregation

    I'm using SQL Server 7.0 and would like to use a parameter for a table column name in a "SUM" aggregation. Code: Select sum(case when Fweek=@Curweek-8 then (quantity*Dollars) else 0 end) 'Week-8' from .... Can the (Quantity*Dollars) expression be passed as a parameter? I have...
  7. dbljackson

    Rows to Columns

    Thanks Greg. Just what I needed. BTW I'm using SQL Server.
  8. dbljackson

    Rows to Columns

    I have a table that keeps sales by day. I want to return the results in column fashion. Similar to Cross-Tab. Example Select sum(Sales on Mondays), sum(Sales on Tuesdays), ... where date between ( xxxx) and (xxxx) Any suggestions most appreciated. TIA

Part and Inventory Search

Back
Top