Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,736 through 24,750 (of 59,102 total)

RE: Copy logins with their password

Lowell (1/17/2014)
microsoft supplies a proc named sp_help_revlogin here that scripts out sql users with hashed passwords, for importation onto other servers.
you'll need to grab the right version off of 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)

January 18, 2014 at 8:54 am

#1681340
RE: SQL single column rows into multiple columns

Lynn Pettis (1/18/2014)
rabih_karam (1/18/2014)
I think we need more clarification about your case
But i have a solution for you as i understand from your question
Declare a table and then select...
--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)

January 18, 2014 at 8:39 am

#1681337
RE: Embedd Image from databse mail

Lowell (1/17/2014)
actually, using the content id (cid:) is the right way.
by leaving it out, you are just taking advantage of some email clients smart features of filling in missing tags,...
--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)

January 17, 2014 at 9:19 pm

#1681318
RE: Importing .CSV from Symantec Q&A v4.0 (legacy flat dbms)

BR.GRIFFITH (1/16/2014)
Can I do anything differently in T-SQL/Bulk INSERT that will override this error and just leave a field or two blank and import the majority of the flat file...
--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)

January 17, 2014 at 6:52 pm

#1681316
RE: SQL single column rows into multiple columns

Johnny D (1/17/2014)
Hi All,
I have a table with one column with lots of rows. I would like every five rows of data to turn into five columns.
So in example 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)

January 17, 2014 at 6:29 pm

#1681315
RE: Multiple Pivots

singh.kamaldeep (1/16/2014)
Hi SQL Gurus,
I am struck into one major issue.
I have data in my table as follows.
BOM_STATION_NO STD_DT TIME PERIOD_ID TEMP ...
--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)

January 17, 2014 at 4:35 pm

#1681304
RE: We're not craftsmen and craftswomen

David.Poole (1/17/2014)
I always do the best I can do within the constraints I am given. If it is time and resource constraints and I know that these are not...
--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)

January 17, 2014 at 4:22 pm

#1681301
RE: Picking Your Packaging

Hands down, it would be T-SQL for me with calls from there to PoSh and only if needed. T-SQL doesn't seem to change as much as all the other...
--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)

January 17, 2014 at 4:07 pm

#1681299
RE: foreach loop container - BIDS 2010

This appears to be a duplicate thread, which splits up the answers. Please, no more replies on this thread. Please post your answers at the following thread.
http://www.sqlservercentral.com/Forums/Topic1530927-148-1.aspx
--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)

January 17, 2014 at 3:59 pm

#1681296
RE: ProperCase Function

BWAAA-HAAA!!!! Dare I say IT? DARE I? Oh, what the heck...
[font="Arial Black"]"Ahhhhhhh MAGOO! You've done it again." [/font]:-P (Sorry ol' friend... I've been holding it back for...
--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)

January 17, 2014 at 3:52 pm

#1681294
RE: Reclaim free space

Casper101 (1/17/2014)
Yes, it has a clustered and a few non-clustered indexes.
I did rebuild all indexes on this table.
I will apply your script to my DB..hope it works..
Thanks for you help...
--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)

January 17, 2014 at 3:39 pm

#1681291
RE: Concatenating field values in one string

In that case, let's provide a link on the subject.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Please make sure that you dive into the "Join the Discussion" link for a particular performance optimization.
As for the dupes, "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)

January 17, 2014 at 3:28 pm

#1681289
RE: Best way to graph/draw an ETL data flow

PLEASE stop double posting on this site. Many of us monitor all forums on this site and your duplicate posts just split up answers.
No replies here, please. Please...
--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)

January 17, 2014 at 3:21 pm

#1681285
RE: Very SIMPLE query working in Access not working on Sql Server

dquirion78 (1/17/2014)
wow thanks I just tried some test on computed columns... Sql server is so strong 🙂
thanks again
If you can't add PERSISTED Computed Columns to your table for some...
--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)

January 17, 2014 at 3:17 pm

#1681283
RE: Copy logins with their password

SQL_Surfer (1/17/2014)
I need to copy some databases from one server to another. What is the best way to copy logins with their passwords? Each login has access to multiple databases...
--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)

January 17, 2014 at 3:04 pm

#1681277

Viewing 15 posts - 24,736 through 24,750 (of 59,102 total)