Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,716 through 11,730 (of 59,099 total)

RE: Cursor Or Not

kd11 - Thursday, July 26, 2018 6:45 AM
That will work for a small sample test data but there are over three thousands...
--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)

July 26, 2018 at 6:49 am

#1999074
RE: Automate daily table backup

sgmunson - Thursday, July 26, 2018 6:33 AM
Jonathan AC Roberts - Wednesday, July 25, 2018 5:33 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)

July 26, 2018 at 6:43 am

#1999069
RE: grouping by *

jeffshelix - Wednesday, July 25, 2018 2:00 PM
I have this code:
select
D.*
,H.[Customs_Recon_Entry_Num] as RH_Recon_entry
,max(cast([Recon_File_Date] as Date)) as Recon_File_Date
from
[NAFTAFORD].[STEP1_DUTYIMPACT_MAX3] D
LEft Join
[ADHOC].[ATS_RL] L
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)

July 26, 2018 at 5:11 am

#1999052
RE: How to find if a column of a resultset has a content?

BOR15K - Monday, July 23, 2018 2:46 AM
There is a report I print, which includes a list of people, e.g. students, with...
--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)

July 26, 2018 at 5:09 am

#1999050
RE: Automate daily table backup

Diyas - Wednesday, July 25, 2018 4:12 PM
Hi,
i have task is assigned to take the table backup daily wise.
below is the format
tablename_yymmdd
please...
--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)

July 26, 2018 at 5:03 am

#1999049
RE: Islands And Gaps - I'm Stuck...Again

I completely missed that this was posted on a 2012 forum. LAG is definitely the way to go for this. Thanks, Eirikur.
--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)

July 26, 2018 at 4:58 am

#1999048
RE: Islands And Gaps - I'm Stuck...Again

Dang. I've run into this problem before and resolved it but I've misplaced my notes on how I fixed it and so doing this totally from memory, which might not...
--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)

July 25, 2018 at 9:21 pm

#1999024
RE: Display select items in horizontal way

adonetok - Tuesday, July 24, 2018 11:58 AM
Select * from table will display items in vertical way in studio.
How to make 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)

July 25, 2018 at 6:56 pm

#1999021
RE: How much database normalization is enough?

RonKyle - Wednesday, July 25, 2018 6:45 AM
every street has a name that is repeated, every town has... You get 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)

July 25, 2018 at 6:28 pm

#1999019
RE: Today's Random Word!

Revenant - Tuesday, July 24, 2018 12:26 PM
HappyGeek - Tuesday, July 24, 2018 11:19 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)

July 24, 2018 at 8:45 pm

#1998906
RE: float error in t-sql scalar function

Sergiy - Tuesday, July 24, 2018 9:46 AM
Andy,Decimal math is integer math.The same thing.Decimal number is an quantity of decimal shares.Exact number...
--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)

July 24, 2018 at 8:18 pm

#1998905
RE: dm_db_index_physical_stats - LIMITED or DETAILED

Grant Fritchey - Tuesday, July 24, 2018 10:10 AM
The issue is, getting the exact detailed information isn't going to radically change 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)

July 24, 2018 at 8:10 pm

#1998904
RE: How to convert INTEGER to TIME

gvoshol 73146 - Tuesday, July 24, 2018 6:04 AM
dalviprasad31 - Monday, July 23, 2018 6:33 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)

July 24, 2018 at 12:46 pm

#1998873
RE: float error in t-sql scalar function

andycadley - Tuesday, July 24, 2018 9:07 AM
Jeff Moden - Tuesday, July 24, 2018 8:58 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)

July 24, 2018 at 9:17 am

#1998810
RE: float error in t-sql scalar function

andycadley - Tuesday, July 24, 2018 8:53 AM
SQL does take advantage of math coprocessors, that's what float/real are for. The fixed precision...
--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)

July 24, 2018 at 8:58 am

#1998804

Viewing 15 posts - 11,716 through 11,730 (of 59,099 total)