Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,561 through 19,575 (of 59,098 total)

RE: Calculating running totals for partitions of data

kdejan87,
Does the table have any kind of column(s) that would indicate the correct order of the transactions?
--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)

September 23, 2015 at 4:40 pm

#1828975
RE: Calculating running totals for partitions of data

kdejan87 (9/23/2015)
View fourth answer and tell me your opinion
[font="Arial Black"]ALL [/font]the answers are incorrect because there is no column that enforces the order of the data in the original data....
--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)

September 23, 2015 at 4:36 pm

#1828974
RE: Moving and restoring the db from latest backup -- Priority

Mitch C. Stein (9/23/2015)
I know SQL 2012 will back up and restore from network drives.
So will everything from 2005 and up. And, 2005 also had the "COPY ONLY" feature......
--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)

September 23, 2015 at 8:20 am

#1828807
RE: Are the posted questions getting worse?

WayneS (9/22/2015)
Holy cow... I've been avoiding that thread, and curiosity got the better of me. Sure with it hadn't.
Everyone needs to just walk away from there. No more posting 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)

September 23, 2015 at 8:16 am

#1828803
RE: Need Help in Recursive Query in SQL using CTE

Now, if we could just get the OP to participate in his own thread... 😉
--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)

September 23, 2015 at 8:04 am

#1828797
RE: save real datatype in sql without converting to exponential

bkshn (9/21/2015)
Hello
I want to save 999999999 as real data in sql.
but it saved 1+E09.
Could you help me how can I save 999999999?
thanks alot
The question here is, do you 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)

September 23, 2015 at 6:54 am

#1828762
RE: DBA - Where in your organization?

We have what I call a DevNetOps team made up of several teams.
[font="Arial Black"]OPS[/font]
Infrastructure, Windows, Email, VMs, Overall Security, Telephone System, UPS, Emergency Diesel, VPN's, DR, Remote DR, backups 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)

September 22, 2015 at 9:50 pm

#1828648
RE: How to Import Data to SQL Server from Access Database using TSQL Script

Here's what I used to read from an ACCESS table using the ACE drivers. This will also read from an ACCESS View or Stored Query... no linked server required....
--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)

September 22, 2015 at 9:10 pm

#1828642
RE: How to Import Data to SQL Server from Access Database using TSQL Script

Ok... once you've downloaded from the URL that I gave in my previous post, you need to following these (below) instructions instead of the ones that are posted on 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)

September 22, 2015 at 8:41 pm

#1828639
RE: How to Import Data to SQL Server from Access Database using TSQL Script

pietlinden (9/22/2015)
Just wondering, where are the 64-bit ACE drivers available? I seem to have the 32-bit ones, and SQL Server is throwing a fit. (I suppose I could do...
--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)

September 22, 2015 at 8:28 pm

#1828637
RE: 1st Time?

serviceaellis (9/22/2015)
Ok, example of how to do that?
Understand that until you posted code, I didn't have table names, column names, nothing... it's important to post the whole problem if 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)

September 22, 2015 at 8:21 pm

#1828636
RE: How to Import Data to SQL Server from Access Database using TSQL Script

pietlinden (9/22/2015)
If you're importing from an .MDB file, use the Jet 4.0, not the ACCDB nightmare. The Jet one actually works.
IIRC, I don't believe that JET will work 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)

September 22, 2015 at 7:47 pm

#1828632
RE: Logic to split Monthly numbers

sharonsql2013 (9/22/2015)
That really helped. Thanks
Do you understand how it works and why?
--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)

September 22, 2015 at 7:44 pm

#1828631
RE: DBA - Where in your organization?

joffwilliams (9/22/2015)
I'm interested in how it is structured in other organizations since there can be some variance from place to place.
Why? And, no... that's not a smart-guy answer 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)

September 22, 2015 at 5:27 pm

#1828619
RE: 1st Time?

Two Views sounds a bit complicated. Just do a COUNT(columnname) OVER (PARTITION BY columnname) in a CTE and SELECT only those items that have a count of 1... no...
--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)

September 22, 2015 at 5:18 pm

#1828618

Viewing 15 posts - 19,561 through 19,575 (of 59,098 total)