WayneS

Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 5,588 total)

RE: Color coding

Hugo Kornelis (10/15/2010)
Carlo Romagnano (10/15/2010)
I answered TRUE, but reading and re-reading both question and answer, I do not understand why it's false. Please Hugo, help us to understand.
:laugh: I seem...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 8:38 am

#1237601
RE: Color coding

cfradenburg (10/15/2010)
William Vach (10/15/2010)
...you must connect through the registered servers tree. If you connect through the File|Connect Objects explorer method, the color of the status bar will be the...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 8:18 am

#1237586
RE: Color coding

William Vach (10/15/2010)
Assuming that this was not a trick question, I believe that the correct answer is 'it depends'. You can set the status bar for the query window...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 8:16 am

#1237582
RE: Create Range form integers (Numbers)

You're welcome. Come on back if you have any more questions!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 8:04 am

#1237571
RE: Silly PRINT question

steveb. (10/15/2010)
you can use them in debugging , but surely you would remove them before putting them in to production ?
Actually, I create all stored procedures like this:
CREATE...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 7:38 am

#1237540
RE: Given @ID select all associated IDs in a history table

LutzM (10/15/2010)
@Wayne: It seems like my answer goes into the "just for exercise" box then...
I put a post-it on my screen: ALWAYS CHECK THE FORUM BEFORE TRYING TO ANSWER!
Thanx 😉
I...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 7:31 am

#1237530
RE: I need to return multiple rows into one single string

DECLARE @cus TABLE (col1 int, col2 varchar(50));
INSERT INTO @cus
SELECT 1, 'John' UNION ALL
SELECT 2, 'Bob';
SELECT stuff((SELECT ',' + convert(varchar(10), col1) + ',' + col2
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 7:26 am

#1237519
RE: Cumulative sum for multiple sequences

jkeys-972541 (10/15/2010)
Thanks Wayne,
Works a treat - Although you have explained it, I don't really understand what is going on with your script - I'm sure I could apply this elsewhere....
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 7:21 am

#1237511
RE: update sql script

One of the tables that you're performing an INNER JOIN with is a 1->Many relationship; thus you are getting values for each row from the table with the Many relationship.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 15, 2010 at 7:16 am

#1237508
RE: Color coding

To get this to always work, there are TWO places to set it:
1. On a registered server, select the "Connection Properties" tab, and set the color.
2. On the Object Explorer,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 9:13 pm

#1237282
RE: Just How Does SQL Server Define A Unique Index

JC-3113 (10/14/2010)
Hi Folks
Can some one tell me the correct syntax for changing the COLLATION to SQL_Latin1_General_Cp1_CS_AS for a column called Name in a table called DTREE
Thanks
Jim
ALTER TABLE DTREE ALTER...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 8:30 pm

#1237279
RE: Concatenating String Values in Transact-SQL

You're welcome... but does it do what you need?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 8:25 pm

#1237278
RE: Process Admin

This link should help you out.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 8:23 pm

#1237277
RE: Are the posted questions getting worse?

Jack Corbett (10/14/2010)
GilaMonster (10/14/2010)
CirquedeSQLeil (10/14/2010)
That's quality entertainment
Yup.
Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at highway...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 8:19 pm

#1237276
RE: Data Modeling with Visio -- is it worth it?

I've used Sybase's PowerDesigner before, it's pretty good.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 8:16 pm

#1237274

Viewing 15 posts - 2,836 through 2,850 (of 5,588 total)