WayneS

Forum Replies Created

Viewing 15 posts - 406 through 420 (of 5,588 total)

RE: Store long values to be used in "IN" statement in separate table?

kwashington (7/14/2015)
I have several reports that are looking for a code within a certain set of codes or ranges. The specific list of codes to be including is...
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

July 14, 2015 at 9:11 am

#1812358
RE: Help with query logic

cory.bullard76 (7/14/2015)
I'm writing a query and in this query I want it to pull patients that must have one specific insurance, but list any insurance they have....not just the one...
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

July 14, 2015 at 9:08 am

#1812355
RE: Are the posted questions getting worse?

Jeff Moden (7/14/2015)
Lynn Pettis (7/13/2015)
OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running...
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

July 14, 2015 at 9:03 am

#1812350
RE: Are the posted questions getting worse?

Lynn Pettis (7/14/2015)
I know that an OP posted a question with the following error:
Cannot create a row of size 8071 which is greater than the allowable maximum row size 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

July 14, 2015 at 9:02 am

#1812349
RE: Syntax Error IS NULL

Welsh Corgi (7/13/2015)
I can copy and paste but not the whole line when I try and scroll.
Could you please place the code outside of the CQL Code Tag?
Thanks.:-)
It might be...
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

July 14, 2015 at 8:51 am

#1812342
RE: Are the posted questions getting worse?

Brandie Tarvin (7/14/2015)
Steve Jones - SSC Editor (7/13/2015)
Brandie Tarvin (7/11/2015)
Kind of irked this morning. Found out this morning that the SQL Saturday call for speakers in Orlando closed after only...
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

July 14, 2015 at 8:48 am

#1812341
RE: "Reuse" parameters in SQL query

mattsynco (7/12/2015)
Im writing a query and I have to use "?" as parameters. "?" will represent two things. StartDate parameter and an EndDate parameter. I know they go in order...
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

July 13, 2015 at 8:24 am

#1811996
RE: Syntax Error IS NULL

Welsh Corgi (7/13/2015)
What is wrong with the following Statement?
update #tmpTotals set StateCount = (Select ISNULL Sum(DayCount),0) from #tmpTotals t where Loss_state = #tmpTotals.Loss_State )
You're missing the "(" after ISNULL
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

July 13, 2015 at 8:05 am

#1811984
RE: Are the posted questions getting worse?

GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!
Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Awesome Gail. Congratulations.
What's your next 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

July 13, 2015 at 5:15 am

#1811916
RE: Get Prior Max of Quantity

What version of SQL does this need to work for? (You're posting in a SQL 2005 forum... is this correct?)
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

July 10, 2015 at 4:30 pm

#1811783
RE: Help with Forming SUb queries

It looks like you aliased this to be "p". Change "PR" to "p" in the above script. (I was basing this solely off of what you had said)
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

July 10, 2015 at 3:50 pm

#1811777
RE: Help with Forming SUb queries

shezi (7/10/2015)
I have hard coded a DAte (6/22/2015 12:00:00 AM) inside DateDiff to get the last friday date. I want to put a Pr.DATE instead. This I think needs...
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

July 10, 2015 at 3:15 pm

#1811769
RE: Cast timestamp to string

ctaylor 79909 (7/10/2015)
PROBLEM DESCRIPTION:
I have a problem where I use a batch file to call a MS SQL Script to write query results to a text file that uses...
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

July 10, 2015 at 3:10 pm

#1811767
RE: tab character in query results

How are you getting the results from SQL into Notepad?
If you are doing a copy/paste from SSMS, and your SSMS results are set to go to a grid, then there...
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

July 9, 2015 at 8:05 am

#1811323
RE: Query Performance tuning for cursor

Junglee_George (7/9/2015)
Ok..I agree with Wayne. Please help me in get rid of the cursor by alternate code.
I am new to this set based approach, removing the cursor.
Well, you're going to...
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

July 9, 2015 at 7:52 am

#1811316

Viewing 15 posts - 406 through 420 (of 5,588 total)