Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,981 through 49,995 (of 59,099 total)

RE: output into CSV format

Then, you need to look into SSIS and calling the SSIS job from the stored procedure.
You can also take a look at the following, but it will mean that 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)

June 17, 2008 at 7:20 am

#829759
RE: Export to CSV Issue

Just open it in Notepad...
--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)

June 17, 2008 at 7:06 am

#829738
RE: How To Omit Saturday & Sunday While Using DateDiff Function

Single forumula, if you want... Also, check out some of the other folks formula's in the discussions that followed. If you do ultimately want holidays to be excluded,...
--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)

June 17, 2008 at 6:46 am

#829717
RE: Tips for practicing SQL at home

If you can afford it, being out of work and all... buy a copy of SQL Server Developer's Edition. Should cost right around $60 USD. It's a full...
--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)

June 17, 2008 at 6:41 am

#829712
RE: Question regarding an interview method- need feedback

Loner (2/27/2007)
First it means they do not trust my resume
I NEVER trust a resume... I had one guy that said he was a 9 out of 10 in both Oracle...
--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)

June 17, 2008 at 12:40 am

#829617
RE: export fixed-length flat file

barb.wendling (6/16/2008)
No, formatting fixed length fields needs to be done by a using format file or by the table structure. The BCP command is inserted into a scheduled job as...
--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)

June 17, 2008 at 12:26 am

#829615
RE: Is it possible?

rbarryyoung (6/16/2008)
Ugh. How many times a week can we get the "String concatenation" question? We need some FAQ or permanent link that we can just send people to.
Heh......
--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)

June 17, 2008 at 12:21 am

#829613
RE: Is it possible?

boyfriend-alex (6/16/2008)
Thank you very much.
It works well.
By the way can i ask one thing more?
In this query....
for xml path('')
What is it for ? What do i have to...
--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)

June 17, 2008 at 12:20 am

#829612
RE: Error converting data type varchar to numeric.

rbarryyoung (6/16/2008)
Select * from Table2
Where IsNumeric(JoinColumn) = 0
Maybe... or maybe not... 😉
DECLARE @Varchar VARCHAR(10)
DECLARE @Numeric NUMERIC
SET @Varchar = '$1.00'
SET @Numeric ...
--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)

June 17, 2008 at 12:07 am

#829611
RE: How to SPLIT the Comma Seperate Values(CSV) in Sql Server 2005

Master the basics, then go for the gold...
http://www.sqlservercentral.com/articles/TSQL/62867/
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

June 16, 2008 at 11:58 pm

#829607
RE: Do You Want to Be Right?

Thanks for the leg up, Lynn.:)
--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)

June 16, 2008 at 11:53 pm

#829606
RE: Do You Want to Be Right?

Heh... Ya know... some of these posts just reminded me of something... I shouldn't get upset about folks writing code to solve the "Time to Market" problem... I make more...
--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)

June 16, 2008 at 11:37 pm

#829598
RE: Non-Sequential Insertion of Data from Temp Table or Arraylist Structure From Within Nested Loop - Inserting Values into Related Tables with Identity Key, CLR or CTE Needed

Tech_Newbie (6/16/2008)
Lets say You have 100 seperate lists of a range of 25-50 people each. For the purpose of inputting the data, you compile all people into one list, organized...
--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)

June 16, 2008 at 10:34 pm

#829591
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Thanks, Navket... I appreciate the feedback.
If you really want to see something that replaces the loop or a cursor, take a look at the following...
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
--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)

June 16, 2008 at 10:04 pm

#829590
RE: Parse delimited data in column to multiple columns

Stephanie Giovannini (6/16/2008)
Outstanding job, Stephanie! 🙂
--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)

June 16, 2008 at 9:58 pm

#829588

Viewing 15 posts - 49,981 through 49,995 (of 59,099 total)