Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,436 through 42,450 (of 59,067 total)

RE: Working with Joins

jrw39,
Since you're a newbie, I have to ask... Do you know what "Books Online" is? It's the "help" system that comes with SQL Server. It's one of 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)

August 7, 2009 at 6:26 pm

#1036342
RE: Moving queries from Access 07 to SQL Server 05

jrw39 (8/7/2009)
I apologize,
I have one additional question on the joins
this query is similar to the last I used your example but I'm still getting an error
before
UPDATE [tblShipments] LEFT OUTER ...
--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)

August 7, 2009 at 6:01 pm

#1036339
RE: checksums and unicode data

Adam Gojdas (8/7/2009)
Closer to being perfect is the LUN 10 checksum (sanity check on credit card numbers)... but even that can have a failure.
Just in case anyone else is interested...
--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)

August 7, 2009 at 5:53 pm

#1036336
RE: 'Add' to a character.

p.s. Pork chops to the "designer" of the table that put you in this pickle to begin with. 😛
--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)

August 7, 2009 at 5:50 pm

#1036335
RE: 'Add' to a character.

saivko (8/7/2009)
What is an elegant way to Select +1 to a nchar that will always have alpha characters? while persevering the zero's
The description above explains what I'm thinking:
000021 + 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)

August 7, 2009 at 5:49 pm

#1036334
RE: Pulling Filename from Windows directory into table

tjm (8/7/2009)
Jeff,
Just wanted to thank you again. That procedure has really come in handy in multiple scenarios.
-tjm
That's absolutlely awesome. 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)

August 7, 2009 at 1:09 pm

#1036254
RE: Pulling Filename from Windows directory into table

Michael Valentine Jones (7/22/2009)
This is a farily simple method:
declare @files table (cmdout nvarchar(100) )
insert into @files ( cmdout )
-- Get filenames excluding directories
exec master.dbo.xp_cmdshell 'dir C:\ /b /a:-d'
select cmdout from...
--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)

August 7, 2009 at 1:08 pm

#1036253
RE: Moving Average Column / Commulative Average

VERY well done on the setup but that brings up another question... why do you need help? I've not run the code but it appears that you've already solved...
--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)

August 7, 2009 at 9:05 am

#1036063
RE: date time

Mohan Kumar (8/7/2009)
Use
SELECT CONVERT(VARCHAR,GETDATE(),109) or
SELECT CONVERT(VARCHAR,GETDATE(),100) or
SELECT CONVERT(VARCHAR,GETDATE(),9)
None of those produce what was asked for.
--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)

August 7, 2009 at 8:42 am

#1036048
RE: How to wrap a Recursive CTE in a view?

Jeff Moden (8/7/2009)
No! The recursive CTE method is the wrong method for this! Do you have the link back to the original problem? Recursive CTE's are just...
--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)

August 7, 2009 at 8:41 am

#1036044
RE: How to wrap a Recursive CTE in a view?

No! The recursive CTE method is the wrong method for this! Do you have the link back to the original problem? Recursive CTE's are just too damned...
--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)

August 7, 2009 at 8:39 am

#1036043
RE: Are the posted questions getting worse?

Ok... I need a pry bar or at least a sturdy sword to get the tennis shoe out of my mouth. It was a different guy and not 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)

August 7, 2009 at 6:44 am

#1035943
RE: The query output should be

Ah... my very bad then... you are a different Karthik than the one I'm used to working with. Someone showed me that there are two people with the same...
--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)

August 7, 2009 at 6:42 am

#1035939
RE: How to split the batch wise id in commaseparatedly?

Heh... but I know how this works... 99% of the time, if you don't get your answer up front, the OP becomes a check valve as soon as he gets...
--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)

August 7, 2009 at 6:37 am

#1035935
RE: Copying & Tracking Data

Darned sorry about that, Goldie. I answered too quickly.
You would think that Microsoft would allow you to return data from the "from_table_name" on an insert like they do 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)

August 6, 2009 at 9:52 pm

#1035788

Viewing 15 posts - 42,436 through 42,450 (of 59,067 total)