Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,236 through 20,250 (of 59,072 total)

RE: Same database with two different machines at different times

Heh... I can't wait until something corrupts and he needs to do a restore. 😉 Since it's his money, you know that'll be your fault. 😛
--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)

June 23, 2015 at 9:21 pm

#1807618
RE: Remove a value from a union

Alvin Ramard (6/23/2015)
Meatloaf (6/23/2015)
Hi,
I have created a phone list and am using a union to be able to display letter category. However, what I would like to do is...
--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)

June 23, 2015 at 9:14 pm

#1807617
RE: Remove a value from a union

Meatloaf (6/23/2015)
Any help is appreciated.
Yep. I agree. Please see the link titled "How to post code problems" in my signature line below. 😉
--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)

June 23, 2015 at 9:13 pm

#1807616
RE: Evaluating Rows to identify >=3 months of consecutive dates and exclude first and last month

Thanks for taking a shot at posting readily consumable data. Unfortunately, you're missing the INSERT and the test data is actually in a different order than the table. ...
--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)

June 23, 2015 at 8:39 pm

#1807615
RE: Big Data Engineers

Heh... there is no such thing as "Big Data". There's only 2 categories of data insofar as size... 1) that which you can handle and 2) that which you...
--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)

June 23, 2015 at 7:21 pm

#1807607
RE: server automatically reboots after windows updates

karend211 34657 (6/23/2015)
Hi there,
The database server is rebooting at various times automatically after a windows update. Our admin people are telling me this is ok and that sql is...
--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)

June 23, 2015 at 7:04 pm

#1807605
RE: Compare field to results from another table

For starters, there is likely no need for the OUTER join if you're using WHERE NOT IN.
--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)

June 23, 2015 at 6:42 pm

#1807600
RE: Partition an existing SQL Server Table

Welsh Corgi (6/23/2015)
Jeff Moden (6/23/2015)
Yep... Saw that. You'd be better off partitioning by year.
He wants to partition 15 years into the First Partition and the current year in another...
--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)

June 23, 2015 at 6:36 pm

#1807598
RE: Is is possible to Dynamic join on EXECUTE table column

In that case, something like your original query could work if the EXEC were encapsulated in OPENROWSET or maybe even the less priv hungry OPENDATASOURCE. The OPENDATASOURCE method might...
--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)

June 23, 2015 at 4:27 pm

#1807592
RE: Skill Supply and Demand

TomThomson (6/23/2015)
If that had happened on a large scale we would still be using hierarchic and network databases not relational.
Heh... it did happen on a large scale and we...
--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)

June 23, 2015 at 3:28 pm

#1807583
RE: How to put data from sql SERVER to notepad using t-sql

Steve Jones - SSC Editor (6/23/2015)
bcp isn't in the path on the server. The server service account (or xp_cmdshell proxy) is calling bcp, but can't find it.
Get the path 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)

June 23, 2015 at 3:14 pm

#1807577
RE: Is is possible to Dynamic join on EXECUTE table column

Sean Lange (6/23/2015)
pjn (6/23/2015)
seriously? any need for that?
I asked a question, I accepted it, its fine, I wanted to know it something could be done (as in initial question), 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)

June 23, 2015 at 3:06 pm

#1807573
RE: Are the posted questions getting worse?

I think he's just experimenting and hasn't told anyone.
--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)

June 23, 2015 at 12:00 pm

#1807511
RE: Is is possible to Dynamic join on EXECUTE table column

Sean Lange (6/23/2015)
pjn (6/23/2015)
Not sure? if this is ever going to be possible, but I'm trying to do a dynamic join on EXECUTE, but the execution string has to come...
--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)

June 23, 2015 at 11:59 am

#1807510
RE: Hidden RBAR: Counting with Recursive CTE's

j-1064772 (6/23/2015)
[font="Comic Sans MS"]Ah but that was a MIXTURE, not pure water. Even CO₂ dissolved in water is a mixture.
And for an amazing development, check out NITINOL - a shape...
--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)

June 23, 2015 at 11:56 am

#1807509

Viewing 15 posts - 20,236 through 20,250 (of 59,072 total)