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

  1. charliescott

    Using Variables in Aggregate Functions??

    I'm fairly certain there is a very quick and simple solution to the following issue that I'm having... USE Northwind DECLARE @COLUMN_NAME VARCHAR(50) SELECT @COLUMN_NAME='LastName' --Following result = 8 (Represents the actual length of string 'LastName' SELECT MAX(LEN(@COLUMN_NAME)) FROM...
  2. charliescott

    Pattern Analysis

    Denis - I like this solution too!!! Any suggestions as to making this dynamic and not tied to the specific length of each field?
  3. charliescott

    Pattern Analysis

    gmmastros - thanks for this suggestion, however, i am interested in maintaining case sensitivity in addition to nonalphanumeric characters. code works as is, but i was just wondering if there was another function within sql that i could have utilzed instead of replace. thanks again for your help!
  4. charliescott

    Pattern Analysis

    Vongrunt, that is correct.
  5. charliescott

    Pattern Analysis

    Hello, Just wondering if there was a cleaner way to perform a pattern analysis then using the following code: USE Northwind SELECT CustomerID,PostalCode,Replace(Replace(Replace(Replace(Replace(Replace(Replace (Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace...
  6. charliescott

    SQL 2005 Query Analyzer - Copying over column names to MS Excel

    Thanks guys for your above response. Both are very good suggestions, however, I was looking for a way in which to transfer results (including column headers) of select statements / temp tables via copy/paste out of the grid view and into ms excel for some quick and dirty analysis. Again, both...
  7. charliescott

    SQL 2005 Query Analyzer - Copying over column names to MS Excel

    A huge frustration of mine is copying data from the GridView in SQL Server 2000 Query Analyzer to MS Excel and the fact that the column headers do not seem to come across. I heard a while back that this issue had been resolved in SQL 2005. I just checked this out and much to my dismay, this...

Part and Inventory Search

Back
Top