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 strongm 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: *

  1. katehol

    SQL Server Managemet Studio folder

    I'd already tried doing that actually, and it doesn't work :(
  2. katehol

    SQL Server Managemet Studio folder

    Hope someone can help me with this annoyance... Every time I open MS SQL Server Management Studio it automatically creates a folder in My Documents. However, I have the same folder stored elsewhere, as I don't want it at this level - is there any way I can point it to this other location...
  3. katehol

    Problem with links in pdf converted from powerpoint

    Hello I've created a pdf file from a powerpoint presentation, but for some reason all of the links on one of the slides have been converted to one big link. The second slide in the presentation has 11 links on it - one to the homepage and the other 10 linking to the next 10 slides. However...
  4. katehol

    Clean up postcodes

    Ah yes - sorry, having one of those days today. Don't write SQL much any more these days, as you can tell. Thanks for your help Kate
  5. katehol

    Clean up postcodes

    Thanks - worked a treat. I just made one minor change as seen below: UPDATE Site SET postcode = STUFF(postcode, LEN(postcode)-2, 0, ' ') WHERE postcode NOT LIKE '% ___%' AND (LEN(postcode) = 5 OR LEN(postcode) = 6 OR LEN(postcode) = 7) Thanks!
  6. katehol

    Clean up postcodes

    Hi I am stuck on a query where I need to clean up the postcode data we have been given by a client. Some postcodes are in the proper format (eg AA1 1AA or A1 1AA or AA11 1AA). But some are in the incorrect format (eg AA11AA or A11AA or AA111AA). Does anyone know of a way to update all of the...
  7. katehol

    Microsoft Word toolbars resetting on logoff

    When I log off my customised Word toolbars are resetting themselves, which is rather annoying - does anyone know how to stop this happening? Thanks Kate
  8. katehol

    Top 20 Daily...

    My data is not actually bad. I have only put a made up set of data for you, as I didn't want to post all half a million rows for you. I know what I am expecting from the results, and I'm afraid the query you gave me did not give me the results I should have got. Therefore, I said thanks anyway...
  9. katehol

    Top 20 Daily...

    Nope, 'fraid not. Thanks anyway
  10. katehol

    Top 20 Daily...

    Nah, that still didn't work. Think I'll have to try to come up with a different solution. Thanks anyway
  11. katehol

    Top 20 Daily...

    Yes, I did try your solution and it gave me 198 rows for 2008-05-21, rather than 20 :o) Page Count Date Page1 | 414 | 2008-05-21 Page2 | 123 | 2008-05-21 Page3 | 373 | 2008-05-21 Page4 | 284 | 2008-05-21 Page5 | 414 | 2008-05-21 Page6 | 123 | 2008-05-21 Page7 | 373 | 2008-05-21 Page8 |...
  12. katehol

    Top 20 Daily...

    Sorry - I obviously didn't explain myself clearly in my original question. I have a table like this Page Count Date Page1 | 414 | 2008-05-21 Page6 | 414 | 2008-05-21 Page4 | 414 | 2008-05-21 Page2 | 414 | 2008-05-21 ... Page1 | 414 | 2008-05-22 Page5 | 414 | 2008-05-22 Page3 | 414 | 2008-05-22...
  13. katehol

    Top 20 Daily...

    An easy little query for someone - I appear to be having brain freeze over it (think it's because it's a Friday...) I want to be able to show the daily top 20 pages from a table. If I run the following query, I only get the top 20 from the first date stored in the table - how would I show the...
  14. katehol

    Intranet link from outlook doesn't work

    When I try to add a link in an Outlook email to a page within our Intranet, when you click on the link it does not recognise that the link is a local page, and so does not automatically log the user on and asks for a password. I tested this out by changing the Internet Security Settings to...
  15. katehol

    Change string to title case

    Thanks for the replies. In the end I actually came up with a really simple UPDATE statement. UPDATE Contact SET Contact.contact_forename = UPPER(LEFT(contact_forename,1))+LOWER(RIGHT(contact_forename,(LEN(contact_forename)-1))) FROM Contact WHERE LEN(contact_forename)>0
  16. katehol

    Change string to title case

    I have a table of contact details, some of which are in lower case, some in title case and some in upper case. I want to change all of these to title case (ie lower case with a capital first letter). I can't seem to find a function for this though. Any clues?
  17. katehol

    Remove string before or after a specified character

    Thanks Harley - worked a treat Used this in the end SELECT Left(YourWebAddress, CHARINDEX('/',YourWebAddress) - 1) as WebName, Right(YourWebAddress, Len(YourWebAddress) - (CHARINDEX('/',YourWebAddress) - 1)) as WebPage FROM YourTable
  18. katehol

    Remove string before or after a specified character

    Thanks for that - unfortunately, InStr is not recognised in SQL Server. :(
  19. katehol

    Remove string before or after a specified character

    I need to split up some web addresses that are being stored in my database. I currently have strings in the format of {name}/web/guest/home I want to be able to split this into 2 columns - one for the name and one for the remainder of the web page, so that I can count individual users and...
  20. katehol

    Find data in comma-delimited lists

    I forgot to say... SQLDenis - congratulations on working for so many great companies. So kind of you to let us all know how great you are and that you have never had to take over a database that wasn't perfect in every way. Lucky you...

Part and Inventory Search

Back
Top