Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,266 through 20,280 (of 59,072 total)

RE: detach db

charipg (6/21/2015)
my script is working.
Thanks.
Can you post the script that's actually working for you please? Thanks.
--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)

June 22, 2015 at 5:37 pm

#1807225
RE: Are the posted questions getting worse?

Eirikur Eiriksson (6/22/2015)
ChrisM@Work (6/22/2015)
Alvin Ramard (6/22/2015)
GilaMonster (6/22/2015)
It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've...
--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)

June 22, 2015 at 12:53 pm

#1807161
RE: Audit administrative logins

Yowch. £6000 is almost $10,000USD. That's just crazy.
--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)

June 22, 2015 at 12:49 pm

#1807158
RE: How to subtract dates from previous date on same patient?

NineIron (6/22/2015)
Jeff, Any thoughts on excluding weekends when subtracting the two dates?
Absolutely but I don't like to post until after I've tested my code and I won't be able 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)

June 22, 2015 at 12:42 pm

#1807156
RE: Partition an existing SQL Server Table

Welsh Corgi (6/22/2015)
DBA From The Cold (6/22/2015)
You'd need to create the required partition schemes/functions and then rebuild your tables' clustered index onto the partition scheme.
Depending on how your table 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)

June 22, 2015 at 12:06 pm

#1807140
RE: How to subtract dates from previous date on same patient?

NineIron (6/22/2015)
Thanx. This will work out fine.
Possibly not. There is absolutely nothing in your data that will prevent a missing sequence number due to a rollback or other cause.
--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)

June 22, 2015 at 12:03 pm

#1807138
RE: Are the posted questions getting worse?

Ed Wagner (6/22/2015)
Lynn Pettis (6/19/2015)
Sean Lange (6/19/2015)
ChrisM@Work (6/19/2015)
Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx
I'm with Alvin on this...
--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)

June 22, 2015 at 7:26 am

#1807027
RE: Another Rows to Columns question

Luis Cazares (6/16/2015)
Just remember that there's no order inside a table. There's an order inside a flat file, but there's no certainty that SQL Server will load it in 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)

June 21, 2015 at 5:23 pm

#1806922
RE: Another Rows to Columns question

Douglas Osborne-229812 (6/17/2015)
Luis,
That was exactly what I needed. Once I completed the second SQL - I was good to go. I guess when I had tried that technique myself I...
--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)

June 21, 2015 at 5:18 pm

#1806921
RE: No of Months between two dates in YYYYMM format

sqlinterset (6/15/2015)
I am looking to calculate no of months between two dates which are in YYYYMM format.
Like no of months between 201505 and 201305
I know the question has been answered...
--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)

June 21, 2015 at 5:13 pm

#1806920
RE: Trying to use T-SQL to calculate elapsed time

For those that are interested and why I hate what they've done to the newer date and time datatypes (namely making "Direct Date Math" impossible), the maximum number of milliseconds...
--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)

June 21, 2015 at 4:44 pm

#1806919
RE: Trying to use T-SQL to calculate elapsed time

Luis' code will work mighty fine, in most cases. However, if it comes across a span of time that's just a little too big to be handled at 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)

June 21, 2015 at 4:18 pm

#1806918
RE: Error using "Update" and "Set" commands

Hi Sandy,
Here's how I would write the UPDATE statement if it were me.
UPDATE ws
SET ws.wrks_submitted = 'Y'
FROM dbo.employee e
JOIN...
--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)

June 21, 2015 at 3:46 pm

#1806917
RE: Repair Corrupt Access Database File

I know the original post here is quite old but it still bears saying...
REMEMBER... all these wonderful tools may help you recover the bulk of the data and successful load...
--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)

June 21, 2015 at 10:18 am

#1806905
RE: Writing to Excel After Skipping Rows

Editing EXCEL spreadsheets via SSIS or any other method is so wrong for so many reasons. One of the worst reasons is that if someone has the spreadsheet open,...
--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)

June 21, 2015 at 10:14 am

#1806904

Viewing 15 posts - 20,266 through 20,280 (of 59,072 total)