Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,736 through 18,750 (of 59,098 total)

RE: Running xp_cmdshell under non system admin

Ed Wagner (1/5/2016)
newbie2 (1/4/2016)
Hi Jeff, I'm having the same xp_cmdshell issues. By any chance can you post your script?
Thanks
Check out http://www.sqlservercentral.com/Forums/Topic1160922-1550-7.aspx. Jeff posted his presentation he did at 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)

January 5, 2016 at 8:01 pm

#1849727
RE: Averages over 28 days instead of a month

Raastarr (1/4/2016)
Thanks for all of the responses.
I've gone with the first solution from Eirikur as [font="Arial Black"]it did exactly what was required [/font]:-).
Careful now... Does it? With some serious...
--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 5, 2016 at 5:58 pm

#1849722
RE: Averages over 28 days instead of a month

DonlSimpson (1/5/2016)
Hugo Kornelis (1/3/2016)
As an alternative to the already mentioned ideas, how about adding a Calendar table to your database?
A Calendar table is a table that holds all days for...
--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 5, 2016 at 5:08 pm

#1849719
RE: Crosstab query NOT using pivot

Tallboy (1/5/2016)
Hi,
Just ran Jeff's code! Worked Brilliantly...Genius....Thank you so much!
But I haven't a clue how it works!
There so many words like XML ,'<<QDate1>>' wot do they do???
What is debug...
--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 5, 2016 at 6:14 am

#1849495
RE: Store "Dynamic" results from a stored procedure into a table

Lowell (1/4/2016)
Can you modify the procedure, since you cannot use openquery?
sounds like a one procedure to rule them all situation, not the best way to do things.
I would modify 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)

January 4, 2016 at 10:44 pm

#1849449
RE: Crosstab query NOT using pivot

Eirikur Eiriksson (1/4/2016)
Jeff Moden (1/4/2016)
Eirikur Eiriksson (1/4/2016)
Further on Jeff's correction, the ClientID in the sample data is different from the one hard coded in the procedure, change these two things...
--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 4, 2016 at 10:40 pm

#1849448
RE: Crosstab query NOT using pivot

Eirikur Eiriksson (1/4/2016)
Further on Jeff's correction, the ClientID in the sample data is different from the one hard coded in the procedure, change these two things and you will get...
--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 4, 2016 at 9:55 pm

#1849446
RE: Crosstab query NOT using pivot

This will do the trick for the example table given. As usual, details are in the comments. I will say that you didn't need the Temp Tables at...
--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 4, 2016 at 9:44 pm

#1849443
RE: Crosstab query NOT using pivot

Spelling error got you. Check the spelling on all occurrences of "AppTime" and change them to "ApptTime", which is what is actually in the table.
If we do that on...
--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 4, 2016 at 7:05 pm

#1849429
RE: Header and Detail SSIS

Duplicate post. Please post answers at the post already in progress.
http://www.sqlservercentral.com/Forums/Topic1749535-3077-1.aspx
--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 4, 2016 at 6:42 pm

#1849425
RE: table

matak (1/4/2016)
This could also be for a user defined type.
You would need to check the definition of the type to see what it is referencing.
That would be my guess, 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)

January 4, 2016 at 6:29 pm

#1849424
RE: Dynamic Query issue

Heh... I'll bet credits to Navy beans that the [SPLIT] function has either a WHILE Loop or some nasty XML in it with odds-on favorite being the WHILE Loop.
--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 4, 2016 at 6:24 pm

#1849423
RE: Header and Detail Data

bpowers (1/4/2016)
We have a Header table and a Detail Line table, which join on the Primary Key . However, we are trying to return the results set in the following...
--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 4, 2016 at 6:15 pm

#1849421
RE: It's the end of the year

Lynn Pettis (1/4/2016)
Good question. Just one minor thing, I'd use the following the end of the calendar year:
SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0));
With the understanding...
--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 4, 2016 at 3:24 pm

#1849389
RE: Merry Christmas

annjunk (12/27/2015)
Thanks. One more quick question, is there a document any where with the colors used and the order when adding polygons, or does everyone just play with it...
--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 3, 2016 at 8:12 pm

#1849127

Viewing 15 posts - 18,736 through 18,750 (of 59,098 total)