Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,411 through 34,425 (of 59,099 total)

RE: proc can return table?

Grant Fritchey (3/31/2011)
Michael Valentine Jones (3/31/2011)
Grant Fritchey (3/31/2011)
You can use a table valued parameter as an output parameter. But what are you trying to do?
I believe that is only 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 31, 2011 at 7:00 pm

#1306271
RE: rows into columns

SQL_NuB (3/31/2011)
I got it working
I did this:
select * from
(select id,
max(case when value like 'make' then shortdescription else '' end) as carMake,
max(case when value like 'model' then shortdescription else ''...
--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 31, 2011 at 6:45 pm

#1306269
RE: Database Architect..Need help

Arman Khan (3/31/2011)
There are no such a document... Just they told me the way application will work..
So write one! You can't "correct" a blank piece of paper. It's...
--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 31, 2011 at 4:51 pm

#1306249
RE: What columns should be chosen when partitioning a table?

Shaiju pointed to a good link for this. And, no, a TIMESTAMP datatype shouldn't be used for partitioning (I'm not even sure you can).
--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 31, 2011 at 4:38 pm

#1306247
RE: Are the posted questions getting worse?

WayneS (3/31/2011)
Jeff Moden (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not...
--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 31, 2011 at 4:19 pm

#1306242
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/31/2011)
Stefan Krzywicki (3/31/2011)
WayneS (3/31/2011)
WayneS (3/31/2011)
CirquedeSQLeil (3/31/2011)
@Wayne - did I miss something? What's up with the SQLRally logo in your sig?
It's the "I'm attending" logo, not the "I'm speaking"...
--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 31, 2011 at 4:10 pm

#1306239
RE: Are the posted questions getting worse?

Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Craig Farrell (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
Oh,...
--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 31, 2011 at 4:02 pm

#1306236
RE: Stored Proceudure: one parameter variable for multiple entries

Oh, be careful, now. That looks like a prime candidate for SQL Injection. A better way would be to split the incoming parameter.
--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 31, 2011 at 2:44 pm

#1306211
RE: Importing text file with numeric fields

Use BULK INSERT with a pipe delimiter to target MONEY datatype columns in a staging table. Then, transfer the data from the staging table to the final table.
As a...
--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 31, 2011 at 2:41 pm

#1306208
RE: proc can return table?

repent_kog_is_near (3/31/2011)
can proc return back table of data (like function)- can you provide a small example?
If you pre-create the target table you can use INSERT/EXEC. You can also use...
--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 31, 2011 at 2:39 pm

#1306206
RE: rows into columns

Much better. Do you think you could squeeze out more than a single row of data, though? 😉
--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 31, 2011 at 2:14 pm

#1306194
RE: Recursive query for a Bill of Materials table

Hi Dave,
You really don't want to use the "expanding hierarchy" example in BOL. There's a fairly easy way to replace the CTE using SQL Server 2000 technology.
Is there any...
--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 31, 2011 at 2:11 pm

#1306192
RE: Arrays in SQL...or a better way of doing this?

kp81 (3/31/2011)
Hi Guys,
I've got a situation whereby I have a CSV variable passed to a stored procedure, however that CSV string also contains pipe (|) delimited values to denote individual...
--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 31, 2011 at 8:28 am

#1306008
RE: Arrays in SQL...or a better way of doing this?

ColdCoffee (3/31/2011)
You can do it with a WHILE...
Alright... who are you and what have you done with the real ColdCoffee?:-P
--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 31, 2011 at 8:25 am

#1306002
RE: rows into columns

SQL_NuB (3/31/2011)
I can't show the table schema and what I have shown is what most of my data looks like.
it contains 5 colums and they are all nvarchar fields, so...
--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 31, 2011 at 8:18 am

#1305999

Viewing 15 posts - 34,411 through 34,425 (of 59,099 total)