Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,586 through 21,600 (of 59,072 total)

RE: How to calculate cumulative numbers

Henk Schreij (2/6/2015)
Eirikur and Sean, thank you.
I have SqlServer 2012 on my developper machine, but the production machine is 2005 :crying:.
Now I gona try to fit my query...
--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)

February 7, 2015 at 8:40 pm

#1776237
RE: How to calculate cumulative numbers

Eirikur Eiriksson (2/6/2015)
Further on Sean's answer, here is the "hard way" (don't worry, the server does the work:-D) of doing a running total on SQL Server 2008 and earlier
😎
USE tempdb;
GO
IF...
--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)

February 7, 2015 at 8:39 pm

#1776236
RE: Powershell parameters

Heh... for me, the correct answer isn't available, which is "Don't worry about it because if it's to do something in SQL, then it's likely that you're using the wrong...
--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)

February 6, 2015 at 6:52 am

#1776037
RE: Long Running Update statement

jdbrown239 (2/5/2015)
Hi
I am running an update against a table with over 100,000,000 rows which takes forever. Is there a better way to write a query like this?
UPDATE [dbo].[Test_Table]
SET [Column_34] =(
CASE
WHEN...
--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)

February 5, 2015 at 9:21 pm

#1775943
RE: Looking for suggestions

Jim Youmans-439383 (2/4/2015)
I have a full time day job but am very interested in branching out with some side work but not sure how best to look for 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)

February 5, 2015 at 9:34 am

#1775755
RE: Get Date Of Tuesday of Past x Years From Now

ScottPletcher (2/5/2015)
Jeff Moden (2/4/2015)
RamSteve (2/4/2015)
The Solution is as below
That's one solution but it relies on @@DATEFIRST which is subject to change based on selected language and other things. ...
--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)

February 5, 2015 at 9:26 am

#1775751
RE: Barcode 128 generator (using scalar function)

mister.magoo (2/5/2015)
Hi Jeff,
I have one also that handles A, B and C
http://www.sqlservercentral.com/Forums/FindPost1470956.aspx
Absolutely awesome! I could be wrong but it doesn't look like it would handle the "SHIFT", "CODE", 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)

February 5, 2015 at 8:35 am

#1775727
RE: Barcode 128 generator (using scalar function)

a_ud (2/17/2011)
I'm looking for a barcode generating Function that uses the standard Code128. Apparently no function that fixes this has been posted before in the forum.
The way the barcode functions...
--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)

February 4, 2015 at 11:44 pm

#1775575
RE: Barcode 128 generator (using scalar function)

Ewan Hampson (4/8/2013)
The way the barcode functions work is always the same: you pass a string with the source code ('bananas') and you get the coded barcode string ( ÑbananasÈÓ,...
--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)

February 4, 2015 at 9:46 pm

#1775560
RE: Barcode 128 generator (using scalar function)

a_ud (6/26/2014)
The VBA code attached to my 1st message works and it's not that difficult to translate to other languages.
If that were true, you wouldn't be asking for help, now...
--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)

February 4, 2015 at 9:40 pm

#1775559
RE: BCP not copying

BCP cannot import .XLS (Excel spreadsheet) files... period. If you're trying to import a spreadsheet to SQL Server via T-SQL, you need to use the "ACE" drivers and either...
--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)

February 4, 2015 at 8:30 pm

#1775548
RE: Get Date Of Tuesday of Past x Years From Now

RamSteve (2/4/2015)
The Solution is as below
SELECT CONVERT(VARCHAR,DATEADD(yy, -@x, DATEADD(D, -((@@DATEFIRST + DATEPART(DW, DATEADD(yy,-@x ,GETDATE()) ) -3) % 7), GETDATE())) ,23)
That's one solution but it relies on @@DATEFIRST which 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)

February 4, 2015 at 6:37 pm

#1775528
RE: Question related to indexes?

New Born DBA (2/4/2015)
This particular SQL Statement runs around 200,000 times a day, goes through millions of logical reads and when I look at the execution plan, it shows 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)

February 4, 2015 at 3:52 pm

#1775503
RE: Are the posted questions getting worse?

Sean Lange (2/4/2015)
Sioban Krzywicki (2/4/2015)
Sean Lange (2/4/2015)
Sioban Krzywicki (2/4/2015)
Grant Fritchey (2/4/2015)
Eirikur Eiriksson (2/4/2015)
Sioban Krzywicki (2/4/2015)
Grant Fritchey (2/4/2015)
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what...
--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)

February 4, 2015 at 3:47 pm

#1775502
RE: Question related to indexes?

New Born DBA (2/4/2015)
Lowell (2/4/2015)
to satisfy that specific query, i think an index on the four columns involved int he WHERE clause is needed, and INCLUDE all the columns 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)

February 4, 2015 at 10:48 am

#1775420

Viewing 15 posts - 21,586 through 21,600 (of 59,072 total)