Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,451 through 12,465 (of 59,095 total)

RE: Change Data format

jcelko212 32090 - Monday, April 30, 2018 10:37 AM
Eirikur Eiriksson - Thursday, April 26, 2018 12:55 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)

April 30, 2018 at 11:54 am

#1988677
RE: Group by month and year

jcelko212 32090 - Monday, April 30, 2018 10:46 AM
You don't seem to understand that dates are not kept in strings in SQL....
--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)

April 30, 2018 at 11:43 am

#1988672
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Monday, April 30, 2018 1:27 AM
Jeff Moden - Sunday, April 29, 2018 1:06 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)

April 30, 2018 at 8:25 am

#1988642
RE: Is Azure a good decision for a major production application deployment?

Arjun Sivadasan - Sunday, April 29, 2018 10:58 PM
Why no love Jeff? 🙂
Azure SQL Managed Instance, apparently, lets you "lift...
--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)

April 30, 2018 at 12:40 am

#1988600
RE: Is Azure a good decision for a major production application deployment?

Eric M Russell - Wednesday, January 18, 2017 9:16 AM
Yes, SQL Azure's contained database model will take some getting used to, but...
--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)

April 29, 2018 at 10:50 pm

#1988598
RE: Are the posted questions getting worse?

Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't...
--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)

April 29, 2018 at 1:06 pm

#1988592
RE: Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

btio_3000 - Sunday, April 29, 2018 12:04 PM
Jeff Moden - Sunday, April 29, 2018 11:15 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)

April 29, 2018 at 1:03 pm

#1988591
RE: Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

btio_3000 - Sunday, April 29, 2018 11:05 AM
Eirikur Eiriksson - Sunday, April 29, 2018 2:10 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)

April 29, 2018 at 11:15 am

#1988589
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Sunday, April 29, 2018 10:23 AM
Jeff Moden - Sunday, April 29, 2018 9:48 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)

April 29, 2018 at 11:07 am

#1988588
RE: How to convert PDF data to database table in SQL server

keddula - Sunday, April 29, 2018 8:59 AM
Eirikur Eiriksson - Sunday, April 29, 2018 8:39 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)

April 29, 2018 at 9:50 am

#1988584
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Sunday, April 29, 2018 9:42 AM
Sorry Jeff, couldn't help it 😀
😎
Heh.... someone on that end just...
--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)

April 29, 2018 at 9:48 am

#1988583
RE: How to convert PDF data to database table in SQL server

keddula - Saturday, April 28, 2018 12:47 AM
Hi,
Can any one suggest on conveting PDF file data to SQL table in SQL server.
Thanks.
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)

April 29, 2018 at 7:29 am

#1988573
RE: The Last Service Pack

Rod at work - Friday, April 27, 2018 10:38 AM
This change in how Microsoft is pushing out updates, using CU's instead of...
--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)

April 28, 2018 at 2:34 pm

#1988563
RE: Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

btio_3000 - Saturday, April 28, 2018 9:52 AM
Thanks for replying,
Not sure I understand...
like I said both [date2] in dbo.[myTable] and [date1]...
--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)

April 28, 2018 at 2:07 pm

#1988562
RE: CTE Recursive Hierarchy Order

kiran 4243 - Saturday, April 28, 2018 1:59 AM
Hi,
Please refer to the attached image for your kind perusal.
For example the product 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)

April 28, 2018 at 1:53 pm

#1988561

Viewing 15 posts - 12,451 through 12,465 (of 59,095 total)