Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,846 through 19,860 (of 59,098 total)

RE: SQL Turn Row data to Column

Jayanth_Kurup (8/19/2015)
http://stackoverflow.com/questions/20057655/multiple-rows-in-one-column-sql-server
Have you seen this ?
That's concatenation rather than creating separate columns for common items.
--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 19, 2015 at 8:58 pm

#1821238
RE: Can't use >= with setInt

serviceaellis (8/19/2015)
Currently working with
DECLARE @yr AS int;
SET @yr = 2015;
which is used in
WHERE (YEAR(EndDate) = @yr)
...
--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 19, 2015 at 8:56 pm

#1821237
RE: adventure works sample database from microsoft

If you're serious about learning SQL Server, stop farting around with the free stuff and by the Developer's Edition for about $60USD. People bitch about the price but 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 19, 2015 at 8:29 pm

#1821232
RE: Looping through XML data and replace words with table values using SQL

Luis Cazares (8/19/2015)
Use the REPLACE() function.
Heh... and here I thought I was the only one that did such a thing. KISS works wonders! 😛
--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 19, 2015 at 8:06 pm

#1821231
RE: Looping through XML data and replace words with table values using SQL

bhanutejan (8/19/2015)
Expecting help immediately.
Thanks in Advance
Send money for immediate help. This is a free forum, not a paid site. 😉
--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 19, 2015 at 9:23 am

#1821104
RE: Where IN @txtVariable (where txtVariable is a CSV list)

Probably the best way here, taking the appropriate precautions against SQL Injection, would be a lick of dynamic SQL.
--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 19, 2015 at 9:17 am

#1821099
RE: Database in use

Jacob Wilkins (8/19/2015)
I prefer to avoid all that silliness and set DBs offline with rollback immediate prior to restoring on top of them. I'm quite confident no one else is...
--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 19, 2015 at 9:14 am

#1821098
RE: Read a file from FTP directly

karthik82.vk (8/19/2015)
Hi
Thanks for the reply.
SO i need to download it from ftp and then only i have to read it right.
Correct. That's when "Excel Hell" takes over....
--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 19, 2015 at 9:05 am

#1821094
RE: Changing roles

Revenant (8/18/2015)
Jeff Moden (8/18/2015)
Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that is...
--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 19, 2015 at 7:25 am

#1821039
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/18/2015)
Well I fly to Louisville Thur, so I'm just hoping my updateFlightSystemaphobia is just a phobia this week.
Take a computer with bad software on it...
--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 18, 2015 at 5:01 pm

#1820917
RE: SQL server login succeed many times in log

Lowell (8/18/2015)
also, think about any items you might have installed, whether running in the background or as a service, that are running under your credentials, maybe something like RedGate lighthouse...
--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 18, 2015 at 9:54 am

#1820804
RE: Changing roles

Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that is publicly available.
Heh... yeah......
--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 18, 2015 at 9:51 am

#1820803
RE: Delete XML data

PJ_SQL (8/18/2015)
I have a table which has XML data, so it takes lot of time to delete it.
Here's the condition:
Archive all data older than 2 months and delete it.
What would...
--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 18, 2015 at 8:12 am

#1820757
RE: The Tally Table

Iwas Bornready (8/18/2015)
Though I have used a tally table a few times, it really is rare for me. I've heard so many people say how great they are so need...
--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 18, 2015 at 8:08 am

#1820751
RE: The Tally Table

Eric M Russell (8/18/2015)
Jeff Moden (8/18/2015)
Alan.B (8/17/2015)
Jeff Moden (8/14/2015)
Alan.B (8/14/2015)
BobAtDBS (8/14/2015)
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we 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 18, 2015 at 8:02 am

#1820746

Viewing 15 posts - 19,846 through 19,860 (of 59,098 total)