RE: converting name..
I"ve used the following, but DAVNovak's idea is pretty cool SELECT LEFT(Firstname, 1) + " " LEFT(Middle, 1) + " " Lastname
2003-06-28
select
2003-06-25
RE: Problem Inserting with Multiple Joins
But if ran the select without the insert which table would I select from? All 4 Site, Tier, Ip_Address & Lan? They are all populated except the Router table which is empty. We're trying to write SP's to handle inserts into the Router table.
2003-06-11
RE: What makes a good developer?
Hello Crispin, quote: A guy started working here who had never heard of google. He asked was it good. To demo it, I searched on "How do I wipe my @55" being serious. What does 'How do I wipe my @55' mean. Is it something X-rated? Cheers, Frank
2003-06-11
RE: What makes a good developer?
How about knowing how/where to look for a solution? I am pretty sure you will find an answer to 'What's the meaning of life' on Google Discussions...
2003-06-11
RE: FOR XML EXPLICIT syntax error
I have seen this problem before. The ORDER BY clause refrences actual columns or expressions built form such columns. In your regular SELECT statment you used expressions of actual columns in the ORDER by clause , while you used derived names in the FOR XML statement. Since all the columns columns use in the SQL […]
2003-06-06
RE: Server slow down after stopping replication
One thing we found was that the disk that the data files are on is extremely fragmented (data area - > 90%, free space - 5%) Can this cause the problems with accessing the #tables? We didnt' notice any slow down accessing regular table, only #tables.
2003-06-06
RE: SQL Server Service Pack 3
I had this problem and I fixed it by making the user account that runs the SQL service a member of the administrator group. I was trying to run the service with less than full rights on a test box.
2003-06-04
RE: SQL Server Mag User Study
Hi Crispin, quote: Just completed it. Not sure what I got myself into. Maybe now I will be getting emails asking if I am lonely... Short survery and useless if you ask me. I already receive those mails asking if I wanna be friend to ???. Short surveys I like best. I only did this […]
2003-06-04
1 reads
RE: copy DTS jobs between servers
Here is an easier procedure I found in technet: Step 5: How to Move DTS Packages Step 5 is optional. If DTS packages are stored on the source server in the SQL Server or the repository, you can move them if you want. To move DTS packages between servers: Save the DTS package on the […]
2003-06-03
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers