Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,351 through 19,365 (of 59,072 total)

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
RE: Missing Relationships

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 understand or any...
--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:18 am

#1835408
RE: DELETE syntax - jus checking in..

celticpiping (10/25/2015)
huh, very interesting..
well, I suppose then, if SQL rules dictate that it could NOT
have deleted everything, then I MUST have selected the top line.
But I think when I'm back...
--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:08 am

#1835405
RE: Using Dynamic SQL To Order Column Names

Jayanth_Kurup (10/25/2015)
Jeff Moden (10/24/2015)
I'll never understand why anyone considers dynamic SQL to not be an elegant solution when it's so bloody effective (and safe) when done correctly.
I once fixed a...
--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 8:58 am

#1835404
RE: Staging Database vs. Staging Schema within the DW

My recommendation is to keep just about anything that even smells like a DW on a totally separate server. Yes, it takes a bit of effort to move 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 8:15 am

#1835402
RE: Positive or Negative

Kim Crosser (10/24/2015)
If this is a simple attribute which is rarely to be used as a key filter in queries, then I prefer the "IsActive" approach.
However, if this "IsActive" column...
--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 24, 2015 at 9:29 pm

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

dmbaker (10/23/2015)
Thanks for the article...5 stars (especially since you didn't say "performant" anywhere) 😀
Thanks for the feedback and the stars. I appreciate it.
I'm curious as to why the slang/lingo...
--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 24, 2015 at 8:42 pm

#1835386
RE: Using Dynamic SQL To Order Column Names

SQLUSERMAN (10/24/2015)
Hi,
Thanks for replying. Suppose the user provides the following data in the web app and clicks the Submit button
@Price = 1350.00
@CustomerRating = 5
@priceWeight = 1
@ratingWeight = 5
Since 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 24, 2015 at 8:33 pm

#1835385
RE: Query to Split the String as rows and columns in SQL

Luis Cazares (10/24/2015)
Jeff Moden (10/24/2015)
Careful now... Do you know what the maximum length of each parameter will be? Me neither. But I can tell you that the maximum...
--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 24, 2015 at 8:24 pm

#1835383
RE: The Hot Jobs

Ah... those aren't "Hot Jobs". Those are just some of the "high paying" jobs. I don't have time to resurrect the links I've recently come across but I've...
--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 24, 2015 at 7:53 pm

#1835382
RE: Execute a SSIS Package with xp_cmdshell

jorge_gomes98 (10/24/2015)
hello,
can you tell me yf this works when you put this code into ASP page and run from remote location?
This is exactly what i need to run a SSIS...
--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 24, 2015 at 7:32 pm

#1835379
RE: Query to Split the String as rows and columns in SQL

ChrisM@Work (10/19/2015)
DECLARE @StartTime DATETIME
DECLARE @Item VARCHAR(20) = ''
SET @StartTime = GETDATE()
SELECT @Item = @Item + ','+d2.Item
FROM dbo.DelimitedSplit8K_LEAD ('Param1=3;param2=4;param4=testval;param6=11',';') d1
CROSS APPLY dbo.DelimitedSplit8K_LEAD (d1.Item, '=') d2
WHERE d2.ItemNumber = 2
ORDER BY...
--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 24, 2015 at 7:13 pm

#1835378

Viewing 15 posts - 19,351 through 19,365 (of 59,072 total)