WayneS

Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 5,588 total)

RE: UNPIVOT @ Local Variables

Karthik,
It looks like you're ordering by the value column, and for the first three rows putting in the appropriate variable?
If so, how does this work for you?
DECLARE @Vars TABLE (ID...
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

May 17, 2011 at 9:41 am

#1325896
RE: Are the posted questions getting worse?

I know voting isn't over yet, but does anyone know if PASS has a date by which speakers will know if their submitted sessions have been selected for the Summit?
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

May 16, 2011 at 1:13 pm

#1325410
RE: Are the posted questions getting worse?

Jack Corbett (5/16/2011)
Saw Steve's mention of Denver for next year's US SQLRally, I say US because there is SQLRally Nordic in Sweden in November and I believe Australia is 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

May 16, 2011 at 12:58 pm

#1325400
RE: Are the posted questions getting worse?

jcrawf02 (5/12/2011)
Thanks Gail! No Swype just sucks. That may be a deal-breaker, it won't be better for my wrists to type on that virtual keyboard than use my ergo one.
Have...
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

May 14, 2011 at 6:03 pm

#1324657
RE: Are the posted questions getting worse?

jcrawf02 (5/12/2011)
why do I need an iPad2? suggestions? (32GB wifi version, guy at work selling it)
my list so far:
1 - I can use it for my schoolwork online, reading...
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

May 14, 2011 at 5:58 pm

#1324656
RE: Are the posted questions getting worse?

I have to say that I thoroughly enjoyed SQL Rally. I thought that a couple of the sessions were not up to par; however the others that I saw were...
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

May 13, 2011 at 11:05 pm

#1324604
RE: Are the posted questions getting worse?

Brandie Tarvin (5/13/2011)
Alvin Ramard (5/13/2011)
Had to laugh when Grant mentioned DBCC TimeWarp in a presentation. 😀
Oh, you have to share. In what context did he mention it?
Oh, just in needing...
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

May 13, 2011 at 6:34 am

#1324240
RE: Pass a table variable to a stored procedure

TT-131210 (5/11/2011)
No, I am not sure how to do that but I have seen that syntax but I was not sure how that worked. Also, the stored...
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

May 11, 2011 at 11:25 am

#1323274
RE: Pivot or?

tictoc (5/11/2011)
Thank You for the links and the schooling 🙂 Makes more sense now!
I try and not to be some copy pasta gangsta and learn what each item step...
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

May 11, 2011 at 11:21 am

#1323271
RE: Identity Crisis: Attack of the Clone

Good question - thanks!
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

May 11, 2011 at 9:43 am

#1323167
RE: Identity Crisis: Attack of the Clone

Tom.Thomson (5/11/2011)
Nice question.
One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if some of...
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

May 11, 2011 at 9:41 am

#1323161
RE: Pivot or?

tictoc (5/11/2011)
It's eating through 300,000 rows like corn now 🙂
BUT
I need to understand more on
DECLARE @Colslist VARCHAR(MAX)
DECLARE @Cols TABLE (Head VARCHAR(MAX))
INSERT @Cols (Head)...
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

May 11, 2011 at 9:34 am

#1323149
RE: Get the First letter of each word within a string and returned a concatenated string

Jeff Moden (5/11/2011)
Also, the delimiter isn't actually a space character, in this case. Rather it's the second character of a space followed by either a letter or a digit....
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

May 11, 2011 at 9:26 am

#1323131
RE: deadlock issue

Praxo (5/11/2011)
I am trying to understand following deadlock graph. I spent some time on my own and google-ing and eventulally came to this forum.
Here is what it has captured.
There are...
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

May 11, 2011 at 9:11 am

#1323118
RE: Are the posted questions getting worse?

Jeff Moden (5/10/2011)
Shameless beg... I REALLY like teaching and, even though I have to pay for everything myself, I'd love the opportunity to present at this year's PASS. :w00t:
I'm with...
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

May 10, 2011 at 3:32 pm

#1322664

Viewing 15 posts - 1,366 through 1,380 (of 5,588 total)