WayneS

Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 5,588 total)

RE: recursive query

I recommend that you read the first link in my signature, and then post readily-consumable table creation (DDL) and test data (DML) scripts, along with what the expected output from...
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

February 17, 2010 at 9:06 am

#1120175
RE: Need help with Query?

rajagopalanseeth (2/17/2010)
The requirement that i need is that i want to display how many releated_id is present for a particular Prospect_list_id along with the name. I want to acheive 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

February 17, 2010 at 8:20 am

#1120133
RE: Sql Server 2 Node Clustering

Well, there are any number of things that could take multiple nodes down:
Facility wide outage (power, air conditioning).
Router/switch failure.
Concurrent hardware failure on each node.
Patches being automatically pushed to the servers...
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

February 17, 2010 at 8:06 am

#1120114
RE: Converting rows into columns

You might find what you're looking for in these articles:
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns [/url]
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]
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

February 17, 2010 at 7:33 am

#1120081
RE: Are the posted questions getting worse?

Anybody interested in reviewing an article on the ROW_NUMBER() ranking function? It's in a .doc file. PM me if interested.
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

February 16, 2010 at 10:42 pm

#1119843
RE: Are the posted questions getting worse?

Lynn Pettis (2/16/2010)
How about a different rant. Don't you get tired of answers that really don't help?
Such as this one and this one.
Lynn, how in the world do you...
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

February 16, 2010 at 7:51 pm

#1119783
RE: Are the posted questions getting worse?

CirquedeSQLeil (2/16/2010)
... I use one instance of SSIS 2008 to perform various tasks against all of my 2000, 2005 and 2008 databases...
Hey Jason, how about an article about this?
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

February 16, 2010 at 6:37 pm

#1119749
RE: Concatenation Cursor

Just remember that without an order by clause, there is no guaranteed order. The correct answer for this could have been just as easily "Bill, Mark, John".
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

February 16, 2010 at 5:33 am

#1119194
RE: Transpose cloumns into rows and rows into columns

You might want to read these articles:
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/
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

February 15, 2010 at 11:42 am

#1118904
RE: Where to find world data database? Like Currency/ countries

Check out the ISO standards. i.e. http://www.lmgtfy.com/?q=iso+currency
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

February 15, 2010 at 11:37 am

#1118902
RE: Are the posted questions getting worse?

GilaMonster (2/14/2010)
Maybe I should answer corruption questions in Minbari or Vulcan from now on...
http://www.sqlservercentral.com/Forums/Topic865038-146-1.aspx
... or Klingon?
At least he seems to be trying things out in Dev first... IMO, a 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

February 14, 2010 at 9:44 am

#1118589
RE: Are the posted questions getting worse?

Okay, so I'm off The Thread for a few days, and when I get back I find out just how the responses to the last post I made here has...
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

February 14, 2010 at 8:00 am

#1118572
RE: Are the posted questions getting worse?

Lynn Pettis (2/11/2010)
RBarryYoung (2/11/2010)
GilaMonster (2/11/2010)
RBarryYoung (2/10/2010)
1) Goto my blog site and download my presentation "TheTop Ten Reasons You Aren't already using Service Broker", or "Top 10 Fixes for your first...
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

February 12, 2010 at 4:58 am

#1117955
RE: while loop question

select stuff((select ';' + Mobile from [YourUn-namedTable] order by Num FOR XML PATH('')),1,1,'')
If this doesn't get you what you're looking for, please take a look at the first link in...
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

February 11, 2010 at 8:48 pm

#1117875
RE: How to script include columns of index

sihaab (2/11/2010)
How can I script include columns from the index.
We can script Table Name of the Index, Index columns of the Index but how do we script include columns...
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

February 11, 2010 at 11:15 am

#1117671

Viewing 15 posts - 4,771 through 4,785 (of 5,588 total)