Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,541 through 24,555 (of 59,102 total)

RE: Adding to SQL Server

Let me preface this rant by saying that you've hit a real "sweet spot" for me. I'll also say that I wouldn't trade in SQL Server for any 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)

February 1, 2014 at 12:59 pm

#1685304
RE: How to Remove login limit in Windows server 2012 SP1

If you're actually talking about remote logins via "Remote Desktop", I believe your out of luck.
Why not just set it up as a normal server on the domain...
--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)

February 1, 2014 at 11:50 am

#1685298
RE: Help finding an old post

sqldriver (1/30/2014)
Hi,
A while back I recall reading a post on here where a user needed to update a column with values until there was a new value, then update with...
--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)

February 1, 2014 at 11:46 am

#1685296
RE: Create a Dimention - BI

L' Eomot Inversé (1/31/2014)
All sensible people are prohibited from participating in BI topics.
BWAAA-HAAA!!! Too funny, Tom. The ways I've seen some C-Levels use BI, I'm convinced 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)

February 1, 2014 at 8:44 am

#1685289
RE: using a user defined function in a view - need help

You're too kind, Ed. :blush: Thanks for the kudo.
--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)

February 1, 2014 at 8:12 am

#1685288
RE: using a user defined function in a view - need help

The function needs to be in the FROM clause of the overall query for the view in a CROSS JOIN or as a CROSS APPLY.
You should also pick a function...
--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 31, 2014 at 9:25 pm

#1685275
RE: Subtotal when vendorcode changed.

jdr.suporte (1/31/2014)
Try
;with
T as (
SELECT VendorCode, 1 as Seq, UnitPrice, Qty, (UnitPrice * Qty) as Total
from Sales
union
SELECT VendorCode, 2, sum(UnitPrice), sum(Qty), sum(UnitPrice * Qty)
from Sales
...
--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 31, 2014 at 9:10 pm

#1685274
RE: auto-increment across multiple tables

squeekz01 (1/31/2014)
Haha thanks mate. That helped a lot.
P.S. I am a finance recruitment officer by day... I seem to structure all of my questions as though I am interviewing...
--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 31, 2014 at 9:07 pm

#1685273
RE: Create a Dimention - BI

Steve Jones - SSC Editor (1/31/2014)
Jeff,
You are prohibited from participating in this subject area.
😀
--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 31, 2014 at 9:01 pm

#1685272
RE: converting Year and Month varchar to date

Luis Cazares (1/31/2014)
You can add a derived column on the table with a formula as used below:
WITH SampleData([Year], [Month], Productname ) AS(
SELECT '2013', '11', 'ACB' UNION ALL
SELECT '2013', ...
--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 31, 2014 at 3:34 pm

#1685238
RE: auto-increment across multiple tables

Sounds like an interview question. Lookup "Sequences" in Books Online.
--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 31, 2014 at 3:31 pm

#1685236
RE: Sorting large volume of data

Apologies for not offering help here but I do have a couple of questions... Why do you need to have 4.8 Billion rows sorted in a single file? 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)

January 31, 2014 at 3:30 pm

#1685235
RE: Subtotal when vendorcode changed.

kishorefeb28 (1/31/2014)
Hi Experts,
i need to write a stored procedure for a table with below columns
for instance the table had 5 columns like
VendorCode | UnitPrice |...
--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 31, 2014 at 3:02 pm

#1685227
RE: Complicated query with sample data

stmu009 (1/31/2014)
Actually CTEs tend to be better for performance.
Better for performance than 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)

January 31, 2014 at 2:57 pm

#1685224
RE: Create a Dimention - BI

"Create a [font="Arial Black"]Dimention [/font]- BI"
Heh... since I am dimented, just stand close and watch the "Dementions" spin off spontaneously. 😀
--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 31, 2014 at 11:46 am

#1685168

Viewing 15 posts - 24,541 through 24,555 (of 59,102 total)