Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,076 through 24,090 (of 59,102 total)

RE: List Files In Directory Using SQL

Heh... no worries. I just love working with xp_CmdShell and wanted to make sure that people knew spaces in a name isn't an obstacle.
Thanks for the feedback..
--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)

March 25, 2014 at 6:12 am

#1699821
RE: select with single quotes

Eirikur Eiriksson (3/25/2014)
sqlserver12345 (3/25/2014)
ascii value for comma
this time the answer is 44 😎
Heh.... I caught the reference. Too funny! 😛
--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)

March 25, 2014 at 6:06 am

#1699819
RE: select with single quotes

If the content of the column is less than 128 characters, the you could also do the following...
SELECT QUOTENAME(Column1,'''') AS quotedColumn1
FROM TableA;
--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)

March 24, 2014 at 10:51 pm

#1699726
RE: List Files In Directory Using SQL

I know... old thread. 😉
Just want to correct that last post. xp_CmdShell support names with spaces in them just like DOS does... you have to put double-quotes around 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)

March 24, 2014 at 10:04 pm

#1699720
RE: need query unpivot in sql servr

Step 1 would be to make it easy for someone to give you a working, tested, coded solution. Please see the first link under "Helpful Links" in my signature...
--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)

March 24, 2014 at 8:40 pm

#1699717
RE: Converting sequential time records into IN and OUT times

pssudarshan (3/24/2014)
Hi,
We have a Time & Attendance application that stores the time punched by each employee in a sequential format. There is no indication as to whether the time...
--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)

March 24, 2014 at 8:25 pm

#1699716
RE: Auditor Rant

Grant Fritchey (3/24/2014)
We're going to need you to come in this weekend to work on those TPS reports, mmmkay?
So long as I can keep the red SwingLine stapler...
--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)

March 24, 2014 at 8:12 pm

#1699714
RE: Ordering items by hierarchy without RBAR

Sure... you could do a 4 way self join but that's hardcoding levels.
Recursion isn't so bad here. It will do things by level, not by row.
--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)

March 24, 2014 at 2:32 pm

#1699679
RE: missing .mdf and .ldf database file after hard drive crash

hwp (3/24/2014)
Sorry, a total noob here.
If the data is valuable, then I suggest you stop all efforts and get a local pro in there to help you. 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)

March 24, 2014 at 2:30 pm

#1699677
RE: Auditor Rant

David O (3/24/2014)
Does anyone else every have day's when they feel like there the audit team's secretary (I could you another word but it is a family show)?
Run 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)

March 24, 2014 at 2:25 pm

#1699675
RE: Getting My List of Databases as an array?

Ooooooo, be careful. I've been through this especially wth the diskspace problems that you mention.
If you delete a backup before you have a new one and the backup job...
--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)

March 24, 2014 at 2:19 pm

#1699673
RE: Show data toEnd User Un-Interrupted.

TomThomson (2/11/2014)
happycat59 (2/10/2014)
Rather than dropping/renaming tables, how about using the ALTER TABLE...SWITCH command. It will not leave you with any period when the table doesn't exist (SQL manages 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)

March 24, 2014 at 11:47 am

#1699642
RE: Getting My List of Databases as an array?

I have to sk... why are you using PoSH instad of just T-SQL for this? It's an easy task in T-SQL.
--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)

March 24, 2014 at 11:37 am

#1699639
RE: what is SSD?

Koen Verbeeck (3/24/2014)
atulyan.aries (3/23/2014)
Hi,
can anyone please tell me what is meant by ssd and how sql uses this. Also can temp db be moved to ssd
Yes, tempdb can be moved...
--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)

March 24, 2014 at 7:13 am

#1699514
RE: Fast inserting\reading\deleting of millions of records

So do you still need the DISTINCT?
--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)

March 24, 2014 at 7:01 am

#1699511

Viewing 15 posts - 24,076 through 24,090 (of 59,102 total)