Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,726 through 10,740 (of 59,102 total)

RE: Concatenate Strings in a COLUMN using comma delimiter, I need some nice code.

mw_sql_developer - Friday, November 2, 2018 9:52 AM
Folks.. No need to reply... All set, I just modified the code a bit ,...
--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)

November 4, 2018 at 4:53 pm

#2012353
RE: OPENROWSET - issue with spaces in the file name

frederico_fonseca - Sunday, November 4, 2018 4:26 PM
Cant try it at the moment but in any case a word of advise.
ACE driver...
--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)

November 4, 2018 at 4:34 pm

#2012352
RE: TSQL query suddenly taking hours to run

Wolfmeister - Sunday, November 4, 2018 2:44 PM
Thanks for the replies guys, much appreciated.
I've tried adding the suggested index, so I'll...
--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)

November 4, 2018 at 4:06 pm

#2012350
RE: OPENROWSET - issue with spaces in the file name

mr-967650 - Sunday, November 4, 2018 1:04 PM
Jeff Moden - Sunday, November 4, 2018 11:45 AM
--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)

November 4, 2018 at 3:59 pm

#2012349
RE: OPENROWSET - issue with spaces in the file name

I've not been able to make it fail with the following code, which I've just tested on my box.

SELECT *
FROM OPENROWSET
(
--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)

November 4, 2018 at 11:45 am

#2012344
RE: Explaining Our Professions to Our Parents

stan.kappiris - Saturday, November 3, 2018 6:35 PM
Iâ€™ve been playing with computers a long time. But when somebody asks me what I...
--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)

November 4, 2018 at 10:51 am

#2012343
RE: synonyms vs views when using a linked server

JSB_89 - Sunday, November 4, 2018 8:32 AM
Thanx Jeff will check with the SAN team, but going back to my original question...
--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)

November 4, 2018 at 9:13 am

#2012342
RE: DT_BYTE to DT_DBDATE

If it appears as a single string, then the following will do the trick for you, depending on your need..

--===== This is just simplified test...
--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)

November 4, 2018 at 8:20 am

#2012340
RE: DT_BYTE to DT_DBDATE

jklenk86 - Saturday, November 3, 2018 8:49 PM
So I did further digging. I have never seen this data type before. the MySQL...
--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)

November 4, 2018 at 7:56 am

#2012339
RE: 4-4-5 Calendar Functions, Part 1

dkangel - Saturday, November 3, 2018 8:44 PM
Jeff Moden - Monday, September 28, 2009 8:05 PM
--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)

November 4, 2018 at 7:48 am

#2012337
RE: view generator

Flashx - Saturday, November 3, 2018 3:53 PM
Jeff Moden - Saturday, November 3, 2018 12:04 PM
--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)

November 4, 2018 at 7:40 am

#2012335
RE: TSQL query suddenly taking hours to run

p.s. You didn't make the mistake of shrinking your database files, did 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)

November 4, 2018 at 7:35 am

#2012334
RE: synonyms vs views when using a linked server

JSB_89 - Saturday, November 3, 2018 6:42 PM
Jeff Moden - Saturday, November 3, 2018 12:12 PM
--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)

November 4, 2018 at 7:21 am

#2012333
RE: TSQL query suddenly taking hours to run

Before you try anything, you said this problem started recently. The first thing you should do is make sure your statistics are up do date.
This is also an...
--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)

November 3, 2018 at 12:22 pm

#2012314
RE: synonyms vs views when using a linked server

JSB_89 - Friday, November 2, 2018 4:24 PM
The company is driven by business so whatever the business needs we need to...
--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)

November 3, 2018 at 12:12 pm

#2012313

Viewing 15 posts - 10,726 through 10,740 (of 59,102 total)