Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,101 through 17,115 (of 59,101 total)

RE: query to update a table with XML value

fafful (8/10/2016)
I have 2 tables:
Table_A (InsuranceNo, JobNo,Processed) values('Anton1',NULL),('Jason1', NULL),('Citirus2',NULL)
Table_B (InsuranceNo, XmlResponse)
values ('Anton1','<Boot><Jobs><Job_entered jobno="2122" logged_info="Job number 2122">2122</Job_entered></Jobs></Boot>'),
('Citirus2','<Boot><ErrorDetails> a problem occured with data </ErrorDetails></Boot>')
Question:
I want to update Table_A Jobno column with the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 10, 2016 at 8:24 am

#1894796
RE: How do I transpose rows to columns?

For more information and a better understanding of the method that Orlando is using, please see the following article.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 10, 2016 at 8:11 am

#1894792
RE: power script to find backup status in sql server

naren.ece2012 (8/10/2016)
Hi All,
I need a power-shell script to obtain the following information Name of the database , LastBackupDate of the database and this information should be sent via an email...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 10, 2016 at 8:06 am

#1894788
RE: Need to load date from datepart from a table to a file

Ed Wagner (8/10/2016)
The CONVERT function supports the format you want to use. Just apply it to a column instead.
SELECT CONVERT(Varchar(10), GETDATE(), 110);
Do T-SQL functions actually work inn SSIS, Ed?...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 10, 2016 at 7:57 am

#1894783
RE: I need number of transaction / read / write handled by prod SQL server per second.

p.s. All of the character based columns in the return from this system view are NCHAR(128). Most of the values returned are quite a bit less. If...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 10, 2016 at 7:55 am

#1894781
RE: I need number of transaction / read / write handled by prod SQL server per second.

I don't use SQL Server code (T-SQL) for such a thing. Instead, I use Performance Monitor, which can both save the data in a nice, importable CSV and can...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 10, 2016 at 7:49 am

#1894776
RE: Sorting the document map

eobiki10 (8/10/2016)
Hi All,
Anyway to sort how items appear in document map. The items are already sorted in Table but when they appear in document map, the sorting disappears.
Thanks
Emma
I'm not sure...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 10, 2016 at 7:23 am

#1894770
RE: SELECT INTO vs INSERT INTO on Columnstore

Joseph M. Steinbrunner (8/8/2016)
Irish Flyer (6/9/2015)
Your article is incomplete without adding that a SELECT INTO is considered a DDL statement and completely locks both source and target tables for the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 9, 2016 at 2:57 pm

#1894661
RE: Count the occurrence of word in a Resume Table

BWAAA-HAAA!!!! Even the machine must sense it's the wrong thing to do. 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 9, 2016 at 2:48 pm

#1894658
RE: Finding related records within the same table

The Dixie Flatline (8/8/2016)
Hey Jeff, are you going to use your Hierarchies on Steroids approach? 🙂
That's what I was thinking. Gotta look at what's been posted a bit...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 8, 2016 at 8:10 pm

#1894451
RE: Finding related records within the same table

drew.allen (8/8/2016)
Here are the two queries that I was alluding to.
Thanks for taking the time to post that, Drew. I appreciate it very much.
Lynn Pettis (8/8/2016)
I came up with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 8, 2016 at 8:03 pm

#1894450
RE: Quickest way to move jobs

william.scott 34593 (8/8/2016)
Thanks Jeff, do you have a similarly easy way to get the SSIS Jobs scripted out?
Thanks In Advance
bill
Only if the jobs are executed by SQL Server Agent, in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 8, 2016 at 7:59 pm

#1894449
RE: Count the occurrence of word in a Resume Table

shambhavi13 (8/8/2016)
You are absolutely right... but the idea here is just to tag the candidate with skills like JAVA(6), C++(5) .. where 6, 5 is the number of keyword occurrence.
That's...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 8, 2016 at 7:44 pm

#1894448
RE: t-sql 2012 use a trigger

Lowell (8/7/2016)
TheSQLGuru (8/7/2016)
If you do this with a trigger, you MUST make it asynchronous!! I would either put the necessary information into a simple queue-style table or use SQL Server...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 7, 2016 at 4:24 pm

#1894255
RE: should we use json or xml in sqlserver.

The Dixie Flatline (8/7/2016)
Sorry for the drama guys. Totally my fault.
I vaguely remember a similar debate about this many years ago. The purpose of these...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 7, 2016 at 4:22 pm

#1894254

Viewing 15 posts - 17,101 through 17,115 (of 59,101 total)