Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,706 through 18,720 (of 59,072 total)

RE: Another Recursive Hierarchy bit of help needed...

Jeff Moden (1/6/2016)
simon_s (1/6/2016)
Hi Jeff
could you elaborate please ? what sort of thing am I looking for ?
thanks simon
It's a loop in the hierarchical chain. For example...
Q...
--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 6, 2016 at 9:24 am

#1849909
RE: Another Recursive Hierarchy bit of help needed...

simon_s (1/6/2016)
Hi Jeff
could you elaborate please ? what sort of thing am I looking for ?
thanks simon
It's a loop in the hierarchical chain. For example...
Q Y W...
--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 6, 2016 at 7:46 am

#1849846
RE: Header and Detail Data

bpowers (1/5/2016)
We received verification that the data can be submitted with all the Header data then the Detail data, as such:
Header 06721
Header 05482
Header 04263
Detail 06721
Detail 05482
Detail 05482
Detail 04263
Etc...
Not sure if...
--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:39 pm

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

It's difficult for me to understand why anyone is even entertaining the idea of a universal query, never mind doing it with XML that still needs to be parsed.
--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:14 pm

#1849730
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

Viewing 15 posts - 18,706 through 18,720 (of 59,072 total)