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. tpasters

    To MeanGreen

    How would I substitute the '%and%' with a variable like: declare @PWORD varchar(10) set @PWORD='and' select title_id, substring(notes, (PATINDEX('% @PWORD %', notes)-25), (PATINDEX('% @PWORD %', notes)+24)) FROM titles where PATINDEX('% @PWORD %', notes)>0
  2. tpasters

    How do I loop through rows?

    I apologize, I think I was trying to make it harder on myself then I had to, this is great. Thanks
  3. tpasters

    Record Limits

    Real rough... I've never had any issues except maybe with performance. I try to warehouse transactions after given time frame so my transaction table stays under 1,000,000 records. Even at that size I get very little performance hits. My archive table now is split in 2, the larger ones has...
  4. tpasters

    How do I loop through rows?

    No, I must have not been clear enough. select statement 1 finds 10+- rows, I need to iterate through select statment #2 10+- times.
  5. tpasters

    allowbypasskey

    In 2000 and 2002 you have to have programming help loaded else you can't get help for programming issues. AllowBypassKey can onlt be manipulated via vba.
  6. tpasters

    How do I loop through rows?

    Using pubs as an example - Considering the batch below, how would I loop through the 2nd select statement for the number of rows that are selected in the first select statement? Current of course it returns only the last string. The point of this is to return a short string from each of the...
  7. tpasters

    email validation transact sql

    Did you ever get an answer on this? I also need to validate an email addredd with T-SQL
  8. tpasters

    Ability to build adhoc query

    What I do in these cases, where I want the user to create their own queries, is to build a metadata table that includes the statements for the partucular query. You can make it as easy on yourself as you wish, when the user clicks a button, they get a result. Or you can allow them to select...

Part and Inventory Search

Back
Top