Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,121 through 45,135 (of 59,101 total)

RE: Advise for complete Beginners

Also, keep in mind that there are different "dialects" of SQL. "Basic" SQL is called "ANSI SQL" and is supposed to be standard. The real fact 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)

February 16, 2009 at 8:47 pm

#944928
RE: Advise for complete Beginners

louisevb (2/16/2009)
Could someone PLEASE provide me with advice as to where to start? I have decided to change my career from accounting to Database Developer (BIG change . . BIG...
--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)

February 16, 2009 at 8:43 pm

#944927
RE: In way over my head

I believe that Andrew pretty much has it. The only shortcoming would be turning it into a matrix. You only need a Cross-Tab for that...
--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)

February 16, 2009 at 8:31 pm

#944926
RE: SQL or Oracle

Max (2/16/2009)
Not yet... but that helps some. 😛
--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)

February 16, 2009 at 5:38 pm

#944913
RE: Are the posted questions getting worse?

Alvin Ramard (2/16/2009)
Michael, did he end up on MythBusters?
😀
Heh... I would think more like "MouseBusters". 😉
--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)

February 16, 2009 at 4:33 pm

#944903
RE: Passing a Table to A Stored Procedure

As a possible alternative...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

February 16, 2009 at 4:21 pm

#944901
RE: How to avoid Cursors?

kishoregowtam (2/16/2009)
Hi,
I have requirement where I stores all quesries which need to be executed are stored in a table.
Name of Table: Table1
Column Name: Query--- Varchar(MAX)
Query contains values...
--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)

February 16, 2009 at 4:18 pm

#944900
RE: How to avoid Cursors?

Ramesh (2/16/2009)
Or you can do something like...
DECLARE @strSQL VARCHAR(MAX)
SELECT @strSQL = COALESCE( @strSQL + '; ', '' ) + Query FROM Table1
PRINT @strSQL
--EXECUTE( @strSQL )
Well done.
--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)

February 16, 2009 at 4:17 pm

#944897
RE: Help Me !!!

If you can't speak English, it'll be difficult to refer you to a site that caters to non-English speaking folks. If you want to try...
http://www.w3schools.com/sql/default.asp
There are, of course, others......
--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)

February 16, 2009 at 4:07 pm

#944893
RE: Problem With IsNumeric()

Bruce W Cassidy (2/16/2009)
Jeff Moden (2/16/2009)
Bruce W Cassidy (2/16/2009)
In another thread, Jeff [font="Arial Black"]Modan [/font]reminded me that numbers of the form '1d3' and '1e3' are legitimate.
Heh... and Bruce W [font="Arial...
--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)

February 16, 2009 at 3:48 pm

#944889
RE: Problem With IsNumeric()

For more on the supposed problems with ISNUMERIC, please visit the following thread...
http://www.sqlservercentral.com/Forums/Topic243646-8-1.aspx#BM245050
--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)

February 16, 2009 at 3:46 pm

#944888
RE: Problem With IsNumeric()

Bruce W Cassidy (2/16/2009)
In another thread, Jeff [font="Arial Black"]Modan [/font]reminded me that numbers of the form '1d3' and '1e3' are legitimate.
Heh... and Bruce W [font="Arial Black"]Cassody [/font]used the information very...
--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)

February 16, 2009 at 3:36 pm

#944881
RE: Help, my database is corrupt. Now what?

Awesome article, Gail. Wish I had it when MSDB went sour on one of my Dev servers especially since my predecessors saw no need to backup a Dev Server....
--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)

February 16, 2009 at 3:29 pm

#944877
RE: SQL or Oracle

gints.plivna (2/16/2009)
Jeff Moden (2/16/2009)
Roy Ernest (2/16/2009)
Calm down people ... Calm down...:D It is a Monday afternoon...:D Not the best day to have arguments.... 😉
It's a GREAT day for arguments! ...
--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)

February 16, 2009 at 2:17 pm

#944854
RE: SQL or Oracle

Roy Ernest (2/16/2009)
Calm down people ... Calm down...:D It is a Monday afternoon...:D Not the best day to have arguments.... 😉
It's a GREAT day for arguments! 😛 Too...
--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)

February 16, 2009 at 2:04 pm

#944847

Viewing 15 posts - 45,121 through 45,135 (of 59,101 total)