Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,756 through 22,770 (of 59,067 total)

RE: swap tables

This sounds an aweful lot like an interview question.
--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)

September 12, 2014 at 4:29 pm

#1745213
RE: Splitting Strings Based on Patterns

fregatepllada (9/12/2014)
Dwain you do not need CLR to use regex 🙂
There is an old way to call Vbscript library
From t-SQL code 😉
sp_OA???
--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)

September 12, 2014 at 4:11 pm

#1745212
RE: Week Start and End by Month

mark.stewart 12691 (9/12/2014)
Jeff,
Thanks so much for the help! That worked perfectly. I'll dig in and understand dates a little better.
Mark
Very cool. Thanks for the feedback,...
--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)

September 12, 2014 at 1:33 pm

#1745188
RE: Week Start and End by Month

The following should do it (see attached). I made sure that it's a high performance iTVF instead of an mTVF. I also got rid of the resource hungry,...
--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)

September 12, 2014 at 11:00 am

#1745152
RE: Daily CSV import to SQL - How ?

G-Force (9/12/2014)
Hi I am receiving 1 csv file daily. The schema is static and the same for each file. I have created a table with the same schema as 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)

September 12, 2014 at 9:11 am

#1745122
RE: Week Start and End by Month

What are the rules for the partial weeks at the start and the end of each month?
--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)

September 11, 2014 at 11:52 am

#1744890
RE: Need Help for my Query

maroju1 (9/11/2014)
Hi All,
This is Naveen Maroju,I unable to get output and please help me on this query.
Mainly i want groupby Vendorname cloumn for below points.
1) If he select Month then...
--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)

September 11, 2014 at 8:49 am

#1744810
RE: Need help for complex query

And are you actually using SQL Server 2012? I ask because LEAD/LAG wasn't available until then and LEAD/LAG is the supported method for doing this. If not, then...
--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)

September 11, 2014 at 8:42 am

#1744804
RE: Generate Triggers for Newly created tables

vijay.singh 14112 (9/11/2014)
Hi All,
I have many new tables for which i need to write Insert,Update and delete triggers manually. Is there any way to generate triggers script which takes table...
--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)

September 11, 2014 at 8:38 am

#1744801
RE: Practical Uses for Synonyms in SQL Server

waldodj2000 (9/11/2014)
What you think about synonyms vs views?
In a view i do: SELECT * FROM server.db.dbo.table
and then I use SELECT * FROM myVIEW
In a Synonyms i do the same.
what...
--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)

September 11, 2014 at 8:30 am

#1744794
RE: Practical Uses for Synonyms in SQL Server

Nice, short, sweet, and well written article on the subject. Even some of the "old hands" at SQL Server still don't about them or what they'd be used for.
We...
--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)

September 11, 2014 at 8:24 am

#1744789
RE: Practical Uses for Synonyms in SQL Server

martin.fay (9/11/2014)
If only there were synonyms for column names!
There kind of are... create a pass-through view, which is what I used until synonyms came out.
--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)

September 11, 2014 at 7:49 am

#1744767
RE: Are the posted questions getting worse?

Sean Lange (9/10/2014)
TomThomson (9/10/2014)
Yes, generally he does. However he apparently hates agreeing with anyone in a forum even more, because he's been pushing YYYY-MM-00 format for a month 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)

September 10, 2014 at 11:57 am

#1744542
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Solomon Rutzky (9/9/2014)
In the end, isn't this why Microsoft gave us CLR Integration?
Heh... yeah... just like they gave us the ability to write extended stored procedures. 😉 I...
--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)

September 10, 2014 at 1:10 am

#1744329
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

dwain.c (9/7/2014)
Jeff Moden (9/5/2014)
That took me by surprise the first time I worked with Oracle, as well. NULL same as '' not same as ' '.
The other thing that...
--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)

September 10, 2014 at 1:05 am

#1744328

Viewing 15 posts - 22,756 through 22,770 (of 59,067 total)