Search results for query: *

Hi All, I'm looking for a way to find and replace a block of text across multiple files. The files are .cfg files written with an XML style code. Each file is in a different folder for which I could identify easily. The subset of code that I'd want to replace, at least initially, may be...

Msg 102, Level 15, State 1, Line 4 Incorrect syntax near 'OrgIPS'.

The tables are pretty small; only about 2500 records total (with the goal of getting it to 10,000) in a complete joined view... So we're talking hundreds of records (maybe low thousands) but not 100's of 1000's or millions! I don't know the first thing about making stored procedures so I guess...

This looks like it 'could' work but it is giving me an error for the 'OrgIPS' for some reason... Other suggestions?

Denny, UNION ALL is a good tip; but, wondering how that works as it seems to be different than a JOIN in it's functionality. I have 3 tables with the following: Table ORGANIZATIONS OrgID OrgName Table ORGIPS OrgID IP_LOW IP_HIGH Table ORGURLS OrgID OrgURL As the tables all have different...

As I have the one table, I ran this code and it parsed but returned no results; which may be a good thing; however, I did enter 1 row that should show up as a range between another range... select IP_LOW, count(IP_LOW) from OrgIPS OrgIPS where OrgIPS.IP_LOW between OrgIPS.IP_LOW and...

Hi All, I have a database that has 3 columns in it (that matter for this discussion). IP_LOW - the low number of an IP Range owned by a company IP_HIGH - the high number of an IP Range owned by a company IP_EXPRESSION - the regular expression of the entire range I would like to company...

Thanks; I did add a few indexes after figuring out that I had to set up the view with 'schemabinding' (whatever that means) and hacked away at some clustered unique indexes; not really sure if I did it right as I'm a hack, but the time sped up a bit... Any other suggestions, tutorials, etc...

Hi, I've been experimenting with tables and searches and their corresponding times for searches. Orginally, I had a table with about 2500 results in it; when seaching for things, I was getting results in 20 milliseconds (according to the SQL Profiler). I've since taken that data and broken...

Thanks for the input; when in SQL 2005 and trying to do this visually, I get the following error code: CREATE UNIQUE INDEX terminated because a duplicate key was found for object name 'dbo.SampleData' and index name 'IX_IPLow'. The duplicate key value is (<NULL>). The statement has been...

Hi All, I'm just starting to get in to SQL 2005 and have learned alot. I have a database that has just a few thousand records in it but I'd like to eliminate the possibility of having a duplicate entry of one of the fields WHILE ALLOWING Null values. I read on constraints and it said that you...

Thanks; the code I copied was not 'as actual'. You are right; they are not suppose to be the same (and they aren't) on both sides of the If statement. The second one should read... ELSE select top 1 * from sampledata where dbo.find_regular_expression('%VALUE%', url_expression,0) = 1 The...

Hi, I'm trying to do a query on a database that will find me the owner of an IP address I've stored. I have IP addresses and hostnames; and the corresponding Regular Expressions. My query is taking about 7 seconds per lookup and I have hundreds of lookups; any tips to speed this up would be...

Another problem I'm having is with the layout of the XML data; it seems to be in one long line and not in new lines for every row of data... Thanks.

Hi, I have to export a variety of data from SQL for use within another program. I want to export my data to XML format so that it can simply be picked up and used by the other program. I have figured out how to export some basic queries (more complex ones to come) but need to know how to...

I'm using this above function to compare an IP to a table of regular expressions; there are 2200 records in the table and each comparison seems to take between 12 and 17 seconds; a bit long in my view. Any suggestions on what I can do to speed this up? I don't know CLR as someone...

Sorry for my ignorance; I'm not much a programmer. Is that a couple lines of code that I would add to the UDF/Procedure? Just would like to output the log to a .txt file... Thanks.

thendrickson, I have to compare an IP address (not in DBase) to all regular expressions that are in DBase. I don't believe that any kind of 'simple' select statement will do therefore need something a little more complexe. Suggestions? Thanks.

Thanks SQLDenis, Sounds like some great ideas; if only I understood them! I'm not much a programmer so don't know anything about SQLCLR's. For that matter, I also wasn't aware that the DLL's would be created and deleted on the fly... All in all, any other suggestions, links to pages, or...

Fair enough; here is what I have... SELECT top 1 URL_Expression, IP_Expression, Name, Category, SubCategory1 FROM TABLENAME WHERE (dbo.find_regular_expression('64.26.154.225', URL_Expression, 0) = 1 or dbo.find_regular_expression('64.26.154.225', IP_Expression, 0) = 1) As a sample where the...