Search results for query: *

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

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

Thanks, but I get this error: Server: Msg 536, Level 16, State 4, Line 1 Invalid length parameter passed to the substring function.

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.

THANKS SO MUCH FOR YOUR HELP! YOU'RE AWESOME!

I have different names for the differnt log files. Will this work for the different names? Where do I change the directory of where the log files reside?

Thanks for your quick response. How would I apply this to SQL's Enterprise Manager or Query Analyzer? I'm using Enterprise Manager to do the DTS import. Thanks.

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!

THANK YOU. THIS WORKED...EXACTLY WHAT I NEEDED. select SUBSTRING(LTrim(RTrim(IP)), charindex('.', LTrim(RTrim(IP)))+1, len(LTrim(RTrim(IP))) - charindex('.', LTrim(RTrim(IP))) - charindex('.', reverse(LTrim(RTrim(IP))))) FROM tblIPs

Thanks, I'm trying to use: assume tablename = tblIPs assume columname = IP select SUBSTRING(IP, charindex('.', IP)+1, len(IP) - charindex('.', IP) - charindex('.', reverse(IP))) FROM tblIPs BUT it leaves an extra . at the end of the ip address. How can I structure the select statement to...

Thanks sunila7. That worked, except for 1 thing. Since I'm asking for 6 spaces for IP address, for those with only 5 leaves a . at the end for the 6th space. For example, 1.12.123.12 = 12.123 4.4.567.12 = 4.567. How can I eliminate the last period at the end with this syntax -- Update...

thanks again for your help.

I'd like to select part of a field in table1 and then insert it into another field in the same table1. for example: IN table 1, I have IP address: 129.34.2.32 in field1 I'd like to select part of this ip address 34.2 in field1 and insert that into field 2 of the same table. So, field 1 should...

Hi, Is it possible to update a field/column from a select statement? I want to use the results of my select statement to update a field. Thanks.

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!

When I try to create this formula, I get the error: The result of selection formula must be a boolean. I'm using Crystal 8.5. Thanks.

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

Great, Thanks so much!

hi again, where would I enter this MID function?

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.