Forum Replies Created
Viewing 15 posts - 16,081 through 16,095 (of 59,067 total)
-
RE: Update had to be done in two steps, Why?
Edvard Korsbæk (12/8/2016)
Originally I had this query:Original value for starttime is 1800001 (Clarion time figures based upon 1/100 of a sec since 00:00 +1)
Update dbo.timeaccountmovement set
DATO = Getdate() ...
--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) -
RE: Parsing paired relationships.
richard.gardner 6009 (12/9/2016)
Hmmm... OK, I can do this but only with some really expensive RBAR table operations, the script I've written takes 10 minutes to run (longer with cursors) and...--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) -
RE: Random number generation based on condition
squvi.87 (12/14/2016)
Need to generate random number based on ID3 column. Have mentioned each rows logic in remarks. Note: This is a sample data I need to apply on big set...
--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) -
RE: SQl Queries getting timed out.
To be honest, you shouldn't have to do this with a system provider. They should have online diagnostics that check for this type of thing several times an hour....
--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) -
RE: Help with XML Splitter De-entitization, please.
Very cool feedback, Eirikur. Thank you for taking the time to post those resources.
Shifting gears, I wish there were something I could do to help push you into writing...
--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) -
RE: The Toolchain for the Job?
It's funny that you brought this up in an article just now, especially the part about ETL.
Even as early as SQL Server 6.5, I built things in SQL Server that...
--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) -
RE: Help with XML Splitter De-entitization, please.
Eirikur Eiriksson (12/18/2016)
Hi Jeff,in this case you will have to use CDATA (Character Data) elements in the construction of the XML.
😎
You just can't believe all the examples I've been through...
--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) -
RE: Creating a small banking datawarehouse
momentueel (12/16/2016)
Hi all,Let me first introduce myself. I'm new to the site. My reason to join is that I have just started a BI job and am learning about how...
--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) -
RE: Creating a small banking datawarehouse
momentueel (12/16/2016)
Haha thanks for asking 😀 It's a traineeship. The focus of the company was to find trainees from business studies that can be schooled to become BI consultants. I'm...--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) -
RE: Creating a small banking datawarehouse
momentueel (12/16/2016)
Hi all,Let me first introduce myself. I'm new to the site. My reason to join is that I have just started a BI job and am learning about how...
--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) -
RE: When Your Primary Key is Not the Clustered Index
m.sams (12/16/2016)
Hi, We have tables that have primary keys that are not the clustered index. The primary key still gets used in some joins, but there is always 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) -
RE: Let the optimizer do it's thing -- wrong
Lynn Pettis (12/14/2016)
May help show the powers that be that ORMs don't always know what's best.Precisely. If you can't prove it with code, you can't prove it.
--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) -
RE: Table copy
paul.s.vidal (12/16/2016)
hI all,how can i copy a table with an specific amount a data.
example:
myTable has 5 millions rows.
I will create myNewTable as a copy of myTable but with only...
--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) -
RE: A Fun Distraction
Ok... I have no life or maybe I just play a different set of relaxing games. 😀
I look forward to having some "down time" so that I can...
--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) -
RE: Stored Procedure for Approval
SQL-Learner (12/16/2016)
Hi,I have a table
CREATE TABLE [dbo].[Table](
[EmployeeID] [int] NOT NULL,
PartnerID] [int] NOT NULL,
[Approved] [bit] NULL,
[ApprovedBy] [nvarchar](255) NULL)
Insert into dbo.Table values (10111, 20111 , 0 ,Null)
Now I need to write...
--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)
Viewing 15 posts - 16,081 through 16,095 (of 59,067 total)