Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,991 through 52,005 (of 59,091 total)

RE: HI simple query only

No... I meant the LIKE thingy you wrote... but, I get it now... and, yes, you must've been bored 😛
--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 8, 2008 at 9:08 pm

#787107
RE: The Daily Routine

Nicely done! Podcast is pretty darned cool, 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)

March 8, 2008 at 8:53 pm

#787106
RE: HI simple query only

Do what, Barry? Maybe I'm tired but I don't get what you're solving... please explain.
--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 8, 2008 at 7:51 pm

#787103
RE: How to get Client Records from a database

Mo,
Donn's method will do you just fine. If it needs to somehow be automated, let us know.
--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 8, 2008 at 7:42 pm

#787101
RE: Display all Column information in single cell ? got result, but not able to understand concept

Yep. This is exactly what I meant. It runs once per each returned row from the main query. In my tests I was running FOR XML one...
--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 8, 2008 at 7:37 pm

#787100
RE: Problem: Coverting varchar to Datetime

rbarryyoung (3/8/2008)
FYI, varchar based date/time columns virtually always have bad data in them.
Nary a truer word spoken 😉
--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 8, 2008 at 7:31 pm

#787099
RE: Varchar(max) problem in SQL server 2005

Good article... thanks for posting it. Just about anything by Adam is worth a look-see.
--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 8, 2008 at 7:08 pm

#787098
RE: Display all Column information in single cell ? got result, but not able to understand concept

That's exactly what I was talking about... you asked why I would use something that I knew was slower... I knew that for the application I wanted, it would be...
--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 8, 2008 at 6:46 pm

#787092
RE: Display all Column information in single cell ? got result, but not able to understand concept

One more thing... you left an extra comma at the end of your two outputs 😉
--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 8, 2008 at 5:42 pm

#787085
RE: Display all Column information in single cell ? got result, but not able to understand concept

Almost forgot... here's the output when STATISTICS IO is ON... "Ugly trick" method beats the hell out of the XML method... 😀
[font="Courier New"]================================================================================
"Ugly trick" code...
Table 'TestData'. Scan count 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)

March 8, 2008 at 5:36 pm

#787084
RE: Display all Column information in single cell ? got result, but not able to understand concept

Adam Haines (3/8/2008)
I understad the select method is still a good solution and completely backward compatible. I also understand that you probably will not need a string of this...
--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 8, 2008 at 5:16 pm

#787078
RE: Breaking into IT!

Yes... I was taking about the Developers Edition of SQL Server 2005.
Oracle experience? I've seen a fair number of people go from Oracle to SQL Server only...
--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 8, 2008 at 12:51 pm

#787060
RE: Display all Column information in single cell ? got result, but not able to understand concept

Robert (3/8/2008)
Ugly trick? why?
Custom aggregates are extremely useful feature. While lists can be done with "FOR XML PATH", some thing can't, like when you have to do a binary OR...
--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 8, 2008 at 12:40 pm

#787058
RE: Display all Column information in single cell ? got result, but not able to understand concept

A nicer and faster solution that works on SQL Server 2005 and later is one that Robert has linked to
Which of the many solutions are you refering to? There...
--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 8, 2008 at 11:27 am

#787054
RE: Breaking into IT!

In fact... here's your first homework problem... write the SQL to count from 1 to a million and display each count. Provide three different solutions and discuss the pros...
--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 8, 2008 at 11:19 am

#787053

Viewing 15 posts - 51,991 through 52,005 (of 59,091 total)