Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,576 through 40,590 (of 59,072 total)

RE: Compare documents in folder to items in a table

I agree... the problem with that is (IIRC) that xp_getfiledetails is no longer available in SQL Server 2008 (although xp_DirTree is) so any upgrade plans would make some pretty loud...
--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)

December 19, 2009 at 10:41 am

#1094466
RE: How to access a current row particular column value

Provided that "value" and "some value" are different in your example, this is easy...
DECLARE @Col1 somedatatype
UPDATE yourtable
SET @Col1 = Col1 = value,
...
--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)

December 19, 2009 at 10:16 am

#1094463
RE: Looking for some fundamental help automating a query

Heh... I notice you have a "name splitter" in the code. Let me ask, what are you going to do with a name like Dr. Robert Douglas van Guttenburg...
--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)

December 19, 2009 at 10:12 am

#1094462
RE: trimming trailing spaces and zeros from a string

First of all, I have to remind everyone that SQL Server isn't a word processor and storing formatted text numbers is very contrary to what SQL Server should be used...
--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)

December 19, 2009 at 10:03 am

#1094461
RE: trimming trailing spaces and zeros from a string

guarddata (5/19/2003)
Wish I could remember the one that produced this a while ago. I can't take credit here.
If you have
DECLARE @numStr
SET @numStr = '345.2300'
then
SELECT @numStr = REPLACE( RTRIM( REPLACE(...
--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)

December 19, 2009 at 9:03 am

#1094457
RE: Is it possible to create nonclustered index on columns with space and ignore the space so that it does not do a table scan?

Never mind... wrong rev...
--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)

December 19, 2009 at 8:54 am

#1094453
RE: Table - More Rows or More Columns?

First of all, if the table will really have 3,000 columns, then the choice of having such a wide table simply vanishes because SQL Server can only have something like...
--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)

December 19, 2009 at 8:34 am

#1094448
RE: Running SQL Server 2008 on a Netbook...

Heh... I just bought an HP "GS" series with a 17.1" screen and a full size keyboard that has a real live separate numeric keybad. Netbook would kill me...
--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)

December 18, 2009 at 8:04 pm

#1094401
RE: Compare documents in folder to items in a table

Step 1 to a high speed T-SQL solution that does NOT require xp_CmdShell... try the following command and see if you understand the output....
EXEC Master.dbo.xp_Dirtree 'C:\',1,1
--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)

December 18, 2009 at 7:49 pm

#1094399
RE: Need a SQL to select the last 60 days from current date

purushotham.k9 (12/17/2009)
yes..60 days of data on day wise and i am using SQL server 2005
Please see the following... it'll do what you want. You will have to spend 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)

December 18, 2009 at 7:43 pm

#1094398
RE: Fixed Length text Output carriage return

Lookup STUFF in Books Online... that should do it for you. And, no... not being a smart alec here... there is an SQL Function called "STUFF".
--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)

December 18, 2009 at 7:39 pm

#1094397
RE: Closing out 2009 early?

Same as Jason, here. Working both weeks with a couple of days off in the later.
--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)

December 18, 2009 at 7:38 pm

#1094396
RE: What's in your CLR?

Sorry for my apparent absence, but I didn't want to put any kind of a slant on the possible responses.
I have to admit a great amount of surprise 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)

December 18, 2009 at 7:09 pm

#1094394
RE: Change 0 to a null in a query

Actually, thank you. Lot's of people just want to be spoonfed instead of taking the time to spend a bit of time with BOL. It's a pleasure 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)

December 18, 2009 at 6:25 pm

#1094392
RE: Problem with comaparing exact date in WHERE part of query....

Jack Corbett (12/18/2009)
I can't even get the value, '2009-12-17 10:45:52.5900000', to CAST to datetime, I get this error:
Msg 241, Level 16, State 1, Line 12
Conversion failed when converting date...
--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)

December 18, 2009 at 4:46 pm

#1094373

Viewing 15 posts - 40,576 through 40,590 (of 59,072 total)