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 wOOdy-Soft 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: teksecrets
  • Content: Threads
  • Order by date
  1. teksecrets

    create sql database to store documents

    Hi, I've been tasked with creating a SQL database to store a bunch of documents. We will be using a website to access these documents. How would I go about creating the tables structure and what settings will I need to use to create an index or a searchable table. Any help would be...
  2. teksecrets

    Total Records for each User & accessed a certain URL.

    Hello! I'm in the process of analyzing some log files and need help trying to figure out how to create my SELECT statement to show how many records each user has in the table and whether they've accessed a certain URL/file. My current Select Statement is: SELECT username, office, date, COUNT...
  3. teksecrets

    SELECT PART OF AN EMAIL ADDRESS

    HI, What is the syntax in SQL to select part of an email address? example: testing@abcd.com How would I create a SQL select statement to only select "testing" and not abcd.com. Any help would be appreciated. Thanks.
  4. teksecrets

    Using DTS to import multiple log files

    Hi, I'd like to know how to use Data Transformation Service to import multiple log files. I'm able to import 1 file successfully. When I use DTS, it give me a browse option to select a single file, is it possible to select mulitiple files? Any help would be appreciated. Thanks!
  5. teksecrets

    Selecting part of IP address

    Hi, I have a table with an IP address field and I'd like to create a select statement to only call the 2nd and 3rd Oct. For example: IP address: 128.23.32.1 I'd like to select only 23.32., how would I structure my Select statement? I have many many IP addresses in this table. Thanks!
  6. teksecrets

    Insert Into SQL

    Hi, How would I go about inserting a number to a new field/column in my table. I have a column named Number which I'd like to add 10 to all records. It's about 1000 records which I need to add 10 to the Number column. For example, Number column is empty now. I'd like to add 10 to that entire...
  7. teksecrets

    searching in crystal

    HI, I'd like to search for the following data in my Crystal report. My data field shows: bos/username. How would I go about searching to show only username. I'd like to eliminate bos/. Any help would be appreciated. Thanks.
  8. teksecrets

    SQL - combine results of 2 fields to 1.

    Hi, I'm trying to create a select statement to combine the results of 2 fields into 1. For example, I have 2 fields: First Name, Last Name. I'd like to combine so my results to show First Name Last Name in the same field. Field 1 Field 2 Jane Smart Results: Jane Smart. How should the...
  9. teksecrets

    Select part of a record/field - trim??

    Hi, I'm trying to Select part of a field in SQL. In my record set I have all records starting with SF/username. I'd like to create a Select statement to display on the username, not SF/. What would my syntax be? Instead of SF/username. I'd like to show username. Any help would be...

Part and Inventory Search

Back
Top