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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.