Search results for query: *

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

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

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

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

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!

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

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

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

Nope, 'fraid not. Thanks anyway

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

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

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

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

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

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

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?

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

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

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

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