Ed Wagner

Forum Replies Created

Viewing 15 posts - 3,991 through 4,005 (of 9,399 total)

RE: Find and Remove Duplicate Records SQL Server

Luis Cazares (2/1/2016)
The problem is that you're missing an important option that SQL Server offers: The possibility to modify data through CTEs and views as long as they follow certain...

February 2, 2016 at 1:20 pm

#1856100
RE: Today's Random Word!

DonlSimpson (2/2/2016)
whereisSQL? (2/2/2016)
Ed Wagner (2/2/2016)
Luis Cazares (2/2/2016)
Ed Wagner (2/2/2016)
Grumpy DBA (2/2/2016)
djj (2/2/2016)
Ed Wagner (2/2/2016)
BWFC (2/2/2016)
Ed Wagner (2/2/2016)
Grumpy DBA (2/2/2016)
Ed Wagner (2/2/2016)
HappyGeek (2/1/2016)
Ironside
Constitution
HMS Guerriere
Battle
Abbey
Road
Hog
Razorback
Racegun
Race pod
Aniken
Jedi
Yoda
Palpatine

February 2, 2016 at 1:14 pm

#1856099
RE: Today's Random Word!

Luis Cazares (2/2/2016)
Ed Wagner (2/2/2016)
Grumpy DBA (2/2/2016)
djj (2/2/2016)
Ed Wagner (2/2/2016)
BWFC (2/2/2016)
Ed Wagner (2/2/2016)
Grumpy DBA (2/2/2016)
Ed Wagner (2/2/2016)
HappyGeek (2/1/2016)
Ironside
Constitution
HMS Guerriere
Battle
Abbey
Road
Hog
Razorback
Racegun
Race pod
Aniken

February 2, 2016 at 9:19 am

#1856022
RE: What is the True Version of Code?

roger.plowman (2/2/2016)
Better to exclude bad data than corrupt production.
+ 1 million

February 2, 2016 at 7:16 am

#1855970
RE: Today's Random Word!

Grumpy DBA (2/2/2016)
djj (2/2/2016)
Ed Wagner (2/2/2016)
BWFC (2/2/2016)
Ed Wagner (2/2/2016)
Grumpy DBA (2/2/2016)
Ed Wagner (2/2/2016)
HappyGeek (2/1/2016)
Ironside
Constitution
HMS Guerriere
Battle
Abbey
Road
Hog
Razorback
Racegun

February 2, 2016 at 7:14 am

#1855969
RE: Today's Random Word!

BWFC (2/2/2016)
Ed Wagner (2/2/2016)
Grumpy DBA (2/2/2016)
Ed Wagner (2/2/2016)
HappyGeek (2/1/2016)
Ironside
Constitution
HMS Guerriere
Battle
Abbey
Road

February 2, 2016 at 6:18 am

#1855953
RE: Today's Random Word!

Grumpy DBA (2/2/2016)
Ed Wagner (2/2/2016)
HappyGeek (2/1/2016)
Ironside
Constitution
HMS Guerriere
Battle

February 2, 2016 at 5:43 am

#1855947
RE: Today's Random Word!

HappyGeek (2/1/2016)
Ironside
Constitution

February 2, 2016 at 5:03 am

#1855941
RE: Coalesce and empty strings to replace NULL - need help

Hugo Kornelis (2/1/2016)
In these two cases the impact is only performance. However there are other cases where the implicit conversions can impact the usability of an index, or even change...

February 1, 2016 at 7:05 pm

#1855891
RE: What is the True Version of Code?

Orlando Colamatteo (2/1/2016)
mister.magoo (2/1/2016)
Before making changes to SQL objects, I'm in the habit of updating my dev VCS from production, then checking for any changes that may have "slipped" in...

February 1, 2016 at 6:56 pm

#1855890
RE: Pulling multiple record values as a single value

The FOR XML approach is a good one for creating a delimited list. Wayne Sheffield has an article that explains it at http://www.sqlservercentral.com/articles/comma+separated+list/71700/.
If you're looking at converting it into...

February 1, 2016 at 6:44 pm

#1855888
RE: Need help related to index

Yes, the bottom line is that we don't know the usage of the table. Sqlinterest, you have a number of us interested in your situation. Would you care...

February 1, 2016 at 6:38 pm

#1855886
RE: Servername along with SP

Steve Jones - SSC Editor (2/1/2016)
I don't think you can do this in a single statement. I might be wrong, but I suspect you could drop the results into a...

February 1, 2016 at 3:01 pm

#1855852
RE: Today's Random Word!

SQLRNNR (2/1/2016)
Ray K (2/1/2016)
Ed Wagner (2/1/2016)
Grumpy DBA (2/1/2016)
Ed Wagner (1/29/2016)
DonlSimpson (1/29/2016)
Grumpy DBA (1/29/2016)
Ed Wagner (1/29/2016)
Revenant (1/28/2016)
Ed Wagner (1/28/2016)
Coq au Vin
Yummy...
[My own experience]
Awesome (Mine too :-D)
Blanquette de veau
Stracotto
Ragu Bolognese (Never...

February 1, 2016 at 2:56 pm

#1855850
RE: How to get salarycode,salaryname in 2 seperate columns (list) ,based on salarycode using sql query

J Livingston SQL (2/1/2016)
did these responses answer your question?
http://stackoverflow.com/questions/35123166/how-to-list-code-in-2-separate-columns-using-a-sql-query
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6a69966-e2f1-4ddf-9772-d05ea5e9c9f0/how-to-get-salarycode-in-seperate-columns-using-sql-query?forum=transactsql
All these questions on different forums and no clear definition of how to build the output. Posting how to derive the...

February 1, 2016 at 2:56 pm

#1855849

Viewing 15 posts - 3,991 through 4,005 (of 9,399 total)