Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,466 through 42,480 (of 59,102 total)

RE: Huge amount of data

satishbhargav4u (8/7/2009)
Where is this data coming from:-a website(amfiindia.com)
What format is it in:-this is in text format
What do you want to do with this data once you have it:- some analysis...
--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 7:45 pm

#1036355
RE: How can we make index on UDF/ Is there is away to replace table scan on UDF's

John Paul (8/7/2009)
How can we make index on UDF/ Is there is away to replace table scan on UDF's
As per the article ,
UDF as Computed Column
By Dinesh Priyankara,...
--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 7:00 pm

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

Bob Hovious (8/7/2009)
(Walks in and hoses Jeff down with high pressure ice water hose, just prior to meltdown.)
😉
BWAA-HAA!!! Man, I probably shouldn't be posting... let's see... I'm trying 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)

August 7, 2009 at 6:52 pm

#1036346
RE: date function

What are the datatypes for the columns involved and would you post some sample data, please? There's no way to help on this one without that information.
For future posts,...
--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:46 pm

#1036345
RE: Regarding CTE IN sql server 2005

thummalalavanya (8/7/2009)
Hi Friends,
I want to use Cte in my sql server 2005.What is Cte .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)

August 7, 2009 at 6:42 pm

#1036343
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

Viewing 15 posts - 42,466 through 42,480 (of 59,102 total)