Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,366 through 19,380 (of 59,098 total)

RE: DELETE syntax - jus checking in..

Kim Crosser (10/26/2015)
Jeff Moden (10/25/2015)
[font="Arial Black"]The reason why I'm so interested in this is because it HAS happened before.[/font] I believe it was post 2000 SP2 but 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)

October 26, 2015 at 6:57 pm

#1835625
RE: The Hot Jobs

xsevensinzx (10/26/2015)
There simply is not enough supply for the demand and while the employer is looking for 5 to 10 years experience...
My problem has been that I've interviewed plenty of...
--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)

October 26, 2015 at 11:07 am

#1835569
RE: Positive or Negative

Kim Crosser (10/25/2015)
It wouldn't be so bad if the "StatusCode" column were a computed column based on the datetime columns, but the developers don't like logic embedded in the database.
Now...
--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)

October 26, 2015 at 10:45 am

#1835559
RE: Positive or Negative

jeff.pendleton (10/26/2015)
...the correct and most efficient use of a flag is for marking exceptions...
I strongly disagree with both of those notions especially since NULLs are a frequent cause of needing...
--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)

October 26, 2015 at 10:40 am

#1835558
RE: Using Dynamic SQL To Order Column Names

That will "only" handle the price and rating combination and only in that order. We're going to need some dynamic SQL here and it needs to be in 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)

October 26, 2015 at 10:36 am

#1835556
RE: A Simple Formula to Calculate the ISO Week Number

robert.sterbal 56890 (10/26/2015)
To the best of my knowledge, I know of no temporal system that considers midnight to be at the end of the day. It always marks 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)

October 26, 2015 at 10:33 am

#1835554
RE: Using value from cloumns to generate a new value for new column

sqlbaby2 (10/26/2015)
Hi
I've data as below
account period01 period02 period03 period04
1111 null ...
--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)

October 26, 2015 at 5:11 am

#1835479
RE: Missing Relationships

Ratheesh.K.Nair (10/25/2015)
Jeff Moden (10/25/2015)
Ratheesh.K.Nair (10/25/2015)
Hi Experts,
We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me...
--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)

October 25, 2015 at 10:30 pm

#1835445
RE: Retrieve String Between Two Delimiters for Multiple Occurences SQL Server

Alan.B (10/21/2015)
My Hacked version of Jeff's splitter splits a string based on a delimiter that is longer than 1. I
Just a suggestion and looking at the data, I wonder why...
--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)

October 25, 2015 at 11:36 am

#1835424
RE: SSIS Import from Excel

TSQL Tryer (10/23/2015)
Appreciate your help with.
As I have the above UNION and the Excel Connection has "First Row has Column Names", so that the first select statement picks up 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)

October 25, 2015 at 11:27 am

#1835423
RE: How to do an OPENROWSET query within a cursor using variables

Blue Rabbit (10/22/2015)
Hi, I am writing a custom query to determine if a legacy table exists or not. From My CMS Server I already have all the instances 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)

October 25, 2015 at 11:17 am

#1835421
RE: Syntax on a join

Welsh Corgi (10/23/2015)
Lynn Pettis (10/23/2015)
Something like this?
SELECT
DATEPART(yyyy,tc.Call_Date) AS ArchiverYear
FROM
dbo.tblCall tc
INNER JOIN PrismDataArchive.dbo.ArchiveDriver AS Arch
...
--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)

October 25, 2015 at 11:12 am

#1835420
RE: Using Dynamic SQL To Order Column Names

Jayanth_Kurup (10/25/2015)
I agree, people use what little they know to create convoluted solutions to simple everyday problem.
I just imagine that somewhere there is a dot net guy on a forum...
--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)

October 25, 2015 at 10:31 am

#1835418
RE: Starting to get tired of all the spam on the forums !!!!

I agree. Since most spam posts are by new users, it would be good to also make the new user signup have an email verification process where they must...
--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)

October 25, 2015 at 9:43 am

#1835414
RE: Using Dynamic SQL To Order Column Names

Jayanth_Kurup (10/25/2015)
Just because you CAN do something in T-SQL, doesn't mean you MUST.
Thanks for the link to the video and your explanation.
As to your comment above, my point is 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)

October 25, 2015 at 9:39 am

#1835412

Viewing 15 posts - 19,366 through 19,380 (of 59,098 total)