Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,046 through 54,060 (of 59,072 total)

RE: Bulk Insert

Even with that, it's still gonna blow up... the skipped rows have to have the same format as those that aren't. It's a fault in both Bulk Insert and...
--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)

November 19, 2007 at 5:12 pm

#752489
RE: Rearrange Identity values

Matt Miller (11/19/2007)
Jeff Moden (11/19/2007)
Maybe that works in 2k5... just not in 2k... yeup, I know... it's a 2k5 forum...
Server: Msg 8102, Level 16, State 1, Line 4
Cannot update identity...
--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)

November 19, 2007 at 5:09 pm

#752488
RE: Using INSERT between dates?

Cool... glad to see someone else using a Tally table...
--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)

November 19, 2007 at 5:04 pm

#752487
RE: SEED-y problem

If you just TRUNCATE the tables, no reseeding is necessary... IDENTITY columns will start over.
--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)

November 19, 2007 at 4:59 pm

#752486
RE: Formula in SQL query

If income and expense are integers, it won't work unless you force a conversion as in the following...
select income, expense, ((income-expense)/income)*100.0 as percentageexpense from sales
--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)

November 19, 2007 at 12:02 pm

#752426
RE: How do I create a report with a checkbox/combobox/ etc

Mr. Impatient has triple cross-posted...
http://www.sqlservercentral.com/Forums/Topic423754-147-1.aspx
http://www.sqlservercentral.com/Forums/Topic423766-150-1.aspx
http://www.sqlservercentral.com/Forums/Topic423758-1063-1.aspx
--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)

November 19, 2007 at 11:59 am

#752425
RE: How do I create a report with a checkbox/combobox/ etc

Mr. Impatient has triple cross-posted...
http://www.sqlservercentral.com/Forums/Topic423754-147-1.aspx
http://www.sqlservercentral.com/Forums/Topic423766-150-1.aspx
http://www.sqlservercentral.com/Forums/Topic423758-1063-1.aspx
--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)

November 19, 2007 at 11:50 am

#752423
RE: How do I create a report with a checkbox/combobox/button etc

Mr. Impatient has triple cross-posted...
http://www.sqlservercentral.com/Forums/Topic423754-147-1.aspx
http://www.sqlservercentral.com/Forums/Topic423766-150-1.aspx
http://www.sqlservercentral.com/Forums/Topic423758-1063-1.aspx
--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)

November 19, 2007 at 11:50 am

#752422
RE: Rearrange Identity values

Maybe that works in 2k5... just not in 2k... yeup, I know... it's a 2k5 forum...
Server: Msg 8102, Level 16, State 1, Line 4
Cannot update identity column 'ID'.
--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)

November 19, 2007 at 6:02 am

#752227
RE: Cartesian product!

That certainly looks like an inner join... but, it's not... behind the scenes, you end up with the same thing as a cross-join because of the criteria you've specified.
It will,...
--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)

November 19, 2007 at 5:47 am

#752224
RE: Problems with GetUTCDate

Yes, there is a work around...
Create a view that looks like this...
CREATE VIEW dbo.vGetUTC AS
SELECT GetUTCDate() AS UTCDate
Then "call" the view from the function instead of calling GetUTCDate().
--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)

November 19, 2007 at 5:38 am

#752221
RE: Urgent! - How to extract number from a string

Hi,
You can try the following query :
select case isnumeric(YourFieldName) when 1 then YourFieldName else 0 end.
Avaneesh,
Try this and see why you shouldn't use ISNUMERIC as an "IsAllDigits" function...
SELECT ISNUMERIC('1e3')
...
--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)

November 19, 2007 at 5:33 am

#752216
RE: Running Number Generation

Matjaz Justin (11/19/2007)
Maybe something like this:
select (select count(*) from sysobjects c where c.id < a.id) + 1
from sysobjects a
order by id
lp, Matjaz
Ummm... be careful... that's a classic "Triangular Join" and...
--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)

November 19, 2007 at 5:21 am

#752209
RE: **************DD/MM/YY to MM/DD/YY************

Converting a VARCHAR date to a VARCHAR date get's you nothing... you must first convert to DATETIME.
Also, storing dates as VARCHAR in a table to start with is a form...
--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)

November 18, 2007 at 6:25 pm

#752125
RE: Best Guideline or Strategy when dealing with records

I guess my real question is can SQL Server handle 336,000 transactions as my dataset for the year (that is after proper indexing ...)?
Heh... I've got 'little" IVR systems...
--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)

November 18, 2007 at 9:21 am

#752102

Viewing 15 posts - 54,046 through 54,060 (of 59,072 total)