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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
1st time using a cursor, can you have an IF inside?
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...- JanetH
- Thread
- Replies: 9
- Forum: Microsoft SQL Server: Programming
-
How do I put two Substring statements together into one?
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...- JanetH
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
How do I return only part of a string from a coloumn
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...- JanetH
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
How do I return only part of a string from a column?
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...
