Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,571 through 51,585 (of 59,098 total)

RE: sp_OACreate and sp_OAMethed Heelllllpppp Please

A better question would be... what is it that you're actually trying to do using OLE Automation?
--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 23, 2008 at 2:42 pm

#792894
RE: daily sales should be zero and not absent

I agree with Matt and Barry... a permanent date table would be much faster than any other method. Lot's more convenient, too, because all the dates are always available....
--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 23, 2008 at 2:27 pm

#792893
RE: daily sales should be zero and not absent

ace (3/22/2008)
Also, since I only need a month's worth of data at a time I'm willing to risk lesser performance in order to not have to administer another table.
I appreciate...
--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 23, 2008 at 2:01 pm

#792888
RE: Anyone knows "developer" version of sql 2005 ?

Thanks... lots of folks don't know when I'm joking or not...
On the serious side, the really neat thing about the Developer's edition is that every developer can have it 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)

March 22, 2008 at 12:07 pm

#792828
RE: Migrating from Dev to Prod

If you're gonna use a compare tool to promote from Dev to Prod, you might as well just give the developers full access to Prod... unless you do a code...
--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 22, 2008 at 11:08 am

#792826
RE: Complicated Query - SQL Gurus Help please

If you would take the data you originally posted and put it and a simple table definition into the form that Lynn asked you to, that would be great 😉
--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 22, 2008 at 10:20 am

#792821
RE: space check

ksullivan (3/22/2008)
There is no need to include upper() in the where clause. TSQL is not case sensitive.
Not quite true... the default is to setup SQL Server so that it...
--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 22, 2008 at 10:14 am

#792820
RE: How to make Sql server Performance faster?

With the information provided, all I can say is did you remember to hit the "Run SQL Faster"? 😀
Seriously, though... we need a bit more information. First, 30,000 rows...
--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 22, 2008 at 9:36 am

#792817
RE: Bulk insert from excel 2003 failed

Yan Gao (1/9/2008)
Jeff Moden (1/4/2008)
How did it help? What was the problem?
I had the file open. Once I closed it, it imported fine...:)
Heh... I had the same problem...
--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 21, 2008 at 5:54 pm

#792755
RE: Vardecimal

Ah... I see... No big difference there... Use IF on SQL Server... just like you can in Oracle in this "case" 😀
It sounds like you're worried a bit about...
--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 21, 2008 at 9:46 am

#792556
RE: SELECT WITH NOLOCKS

Regardless of what the cause of the deadlock is, I guarantee it's going to be code that has a BEGIN TRAN/COMMIT in it... unless someone went nuts using that everywhere,...
--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 21, 2008 at 9:41 am

#792551
RE: Help plz.. Global Identity

Utsab Chattopadhyay (3/20/2008)
Thanks a lot. But per my understanding, this approach will give number as GUID (B85E62C3-DC56-40C0-852A-49F759AC68FB). Is it possible to get a number (Like identity returns) instead?
Many thanks in...
--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 21, 2008 at 9:36 am

#792546
RE: Having my primary key field autoincrement when new details are added

Sure... understood... but you want to create an auto-increment column, as well as creating a table. That's not the same between RDBMS's... for example, Oracle doesn't even allow 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)

March 21, 2008 at 9:18 am

#792525
RE: union help please

Thanks for the feedback, Selena... I've made the same mistake many a 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 21, 2008 at 9:00 am

#792512
RE: Human Power

"The difficult can be done immediately, the impossible takes a little longer." — Army Corp. of Engineers
--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 20, 2008 at 9:21 pm

#792333

Viewing 15 posts - 51,571 through 51,585 (of 59,098 total)