Search results for query: *

I am trying to loop through all records in a coloumn and determine if a record has a file extension or not. If it does I want to run select statement A if it doesn't then select statement B. But I can't seem to make it work in my cursor. I've never used a cursor before and I assume my syntax...

Thank you both so much. It works like a dream!!!

URI is the coloumn that I want to select so the value for it always changes depending on the record. An example of a record would be /wep/employee/Benefits.htm. What I would like to end up with is just Benefits. With the first substring I gave above I would get /wep/employee/Benefits. The...

I have two substring queries that both work on their own but I can't seem to get the syntax right when I try and put them together into one query. The first one is to remove the extension from a string SUBSTRING(URI, 1, CHARINDEX('.',(URI))) The second one is to return only the title of the...

I have created a stored procedure that will retrieve the number of hits on each page of a website by month. The column in the database that contains the page title contains almost the full web address for each page minus the root ex. /sample/archive/archive1.htm. My second problem is that each...

I have created a stored procedure that will retrieve the number of hits on each page of a website by month. The column in the database that contains the page title contains almost the full web address for each page minus the root ex. /sample/archive/archive1.htm. My second problem is that each...