WayneS

Forum Replies Created

Viewing 15 posts - 421 through 435 (of 5,588 total)

RE: Are the posted questions getting worse?

Good going Lynn.
You Lynn are a genius!
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 8, 2015 at 2:31 pm

#1811135
RE: Are the posted questions getting worse?

Alvin Ramard (7/8/2015)
Sanity? Oh Sanity? Where are you hiding?
I've had it. Enough is enough! When are people gonna stop hiring people that don't have a clue about they're hired...
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 8, 2015 at 1:28 pm

#1811120
RE: How to merge two rows into one (conditions or Pivot)

shezi (7/8/2015)
Merge two rows into one (conditions or Pivot?)
I have Temptable showing as
Columns:EmpName, Code, Balance
Rows1: EmpA, X, 12
Rows2:...
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 8, 2015 at 1:25 pm

#1811118
RE: Call for a database backup for a database on another (linked) server

Jeffery Williams (7/8/2015)
Well Close my no cigar. I am trying to parameter the destination server name and I can not get that to execute.
Here is what I am playing 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

July 8, 2015 at 11:55 am

#1811087
RE: Pivot help to exclude matching field

jcobb 20350 (7/8/2015)
Luis Cazares (7/8/2015)
I'm not sure which of the 2 HAVING clauses you need so I'm including both so you can test.
I also changed the pivot approach to a...
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 8, 2015 at 11:37 am

#1811074
RE: Help Converting query -- Do I need a cursor?

You've left a lot of work for us to do to help you out. Please read the link in my signature, and then help us help you by providing:
1. 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

July 8, 2015 at 10:54 am

#1811055
RE: Split postal code range into single row

kraaitje (7/8/2015)
Situation:
The table looks like this:
SELECT OrganisationCode, PostcalCodeStart, PostalCodeEnd
FROM dbo.DimOrganisation
Gee, that looks more like a query to me, and not a table.
A table would look more like:
CREATE TABLE #DimOrganisation (
...
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 8, 2015 at 10:11 am

#1811037
RE: Best way to drop indexes in SQL2014

Nope, that is indeed how to remove them.
You might want to consider renaming them, and letting them sit there for a period of time (say, 3-6 months), to ensure that...
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 8, 2015 at 10:00 am

#1811032
RE: Convert Varchar to Int

Lynn Pettis (7/8/2015)
Minnu (7/8/2015)
Numeric values in the first query should be converted to INTEGER.
You can't mix character data and integer data in the same column.
What are you trying to accomplish?...
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 8, 2015 at 9:53 am

#1811028
RE: Are the posted questions getting worse?

I've lost track... who has the crystal ball?
http://www.sqlservercentral.com/Forums/Topic1701092-391-1.aspx
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 8, 2015 at 9:46 am

#1811022
RE: Query Performance tuning for cursor

Sean Lange (7/8/2015)
Junglee_George (7/8/2015)
Instead of removing cursor, please help to me to modify the existing code within.
I think you are missing the point. The reason the performance of this 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 8, 2015 at 9:43 am

#1811021
RE: Can't figure out how to get MIN/MAX dates per grouping

Comments in the code.
-- need to create a data "island" of the times in each department.
-- to do this, you need a sequential number for each employee,
-- a sequential...
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 8, 2015 at 9:31 am

#1811011
RE: Convert Varchar to Int

Minnu (7/8/2015)
Hi,
first query result :
1
2
11
20
32
68
100
124
246
256
second query result
A1
A10
A11
AB1
AB10
B1
B2
B21
B31
want to generate the complete output in single select statement.
How about a simple modification to Lynn's code?
select Data from #TestData where Data not like...
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 8, 2015 at 9:15 am

#1811003
RE: What are the differences in data types are there between SQL 2005 and SQL 2008 R2?

SQL Server 2008 did add several new data types (see this link) (date, time, datetime2, hierarchyid, geometry, geography) . However, nothing in the existing data types was changed that would...
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 8, 2015 at 9:05 am

#1810995
RE: Are the posted questions getting worse?

GilaMonster (7/2/2015)
Informal survey before I make a fool of myself in an article (again)
Do you get the feeling that IT people, especially ones at the top-end of the field, 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

July 2, 2015 at 4:19 pm

#1810088

Viewing 15 posts - 421 through 435 (of 5,588 total)