Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,551 through 38,565 (of 59,102 total)

RE: Using " IN " inside " WHERE " clause

only4mithunc (5/9/2010)
If it is hard coded, I'm thinking as below.
SELECT *
FROM InvoiceDetails
WHERE InvoiceNo IN ('1248','1063','963','1524')
ORDER BY CASE InvoiceNo
WHEN '1248' THEN 1
WHEN '1063' THEN 2
WHEN...
--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)

May 9, 2010 at 9:20 am

#1164707
RE: CTE performance

Heh... Pity. I've got a million node solution for the MLM folks that absolutely rocks. Same goes for the creation of a million node "Nested Set" for "ad...
--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)

May 9, 2010 at 9:09 am

#1164704
RE: Adding row and column totals to a dynamic pivot table

Chris Lindley (5/8/2010)
Ok, I understand your code. But it's not as simple as that. I can't just go creating a tally table in the DB as I don't own 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)

May 8, 2010 at 8:34 pm

#1164655
RE: Views

satishthota (5/8/2010)
Can you please give me examples on
a) Non-Updateable Views
b) Updateable Views
Ummm... since I think this is a test question or maybe an interview question, I really need you to...
--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)

May 8, 2010 at 8:16 pm

#1164653
RE: to import datatable from one database to another database

rajath 82072 (5/7/2010)
I am using ms acess.
I believe you'll have much better luck getting an answer if you ask that same question on the Access forum.
--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)

May 8, 2010 at 8:13 pm

#1164652
RE: Daily,Weekly,Monthly Report using TSQL

Agile (5/8/2010)
Thank you very much! It's 100% solved my problem. I tried to figure it out by myself by using union all but I'm not succesful. Your code was perfect....
--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)

May 8, 2010 at 8:08 pm

#1164651
RE: Using " IN " inside " WHERE " clause

c_kavya_shri (5/8/2010)
Hello,
I have a Data Table 'InvoiceDetails' which contains Invoice and its Details.
Below is my Query,
SELECT *
FROM InvoiceDetails
WHERE InvoiceNo...
--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)

May 8, 2010 at 8:02 pm

#1164650
RE: Using " IN " inside " WHERE " clause

lmu92 (5/8/2010)
You would nee to provide an ORDER BY clause based on a column that will hold any order criteria.
Since SQL Server does not perform a row-by-row processing, 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)

May 8, 2010 at 8:00 pm

#1164649
RE: Dynamic Query/sproc

alex abenitez (5/5/2010)
The Dynamic part is for the creation of the fields.
Heh... we know that, Alex. How will it be used? I ask because that's a large key...
--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)

May 8, 2010 at 7:58 pm

#1164648
RE: Views

satishthota (5/8/2010)
What is the difference between Non-Updateable Views and Updateable Views in SQL server?
Please Give me with examples?
Actually, this is covered in Books Online far better than any of us...
--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)

May 8, 2010 at 7:45 pm

#1164645
RE: Exploring SQL requests sent

SQL Profiler can do some of that... especially if there's a known user login that the app is using.
--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)

May 8, 2010 at 7:44 pm

#1164644
RE: DBCC SHRINK FILE

Steve Jones - Editor (5/7/2010)
You don't want to do this often, for reasons George mentioned. However if you do shrink data flies, leave enough space to run a reindex 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)

May 8, 2010 at 7:42 pm

#1164643
RE: I am not a Schema

There are two reasons why I don't like and will avoid the use of schemas if at all possible...
1. "All the eggs in one basket". More specifically, all...
--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)

May 8, 2010 at 7:39 pm

#1164642
RE: CTE performance

kazim.raza (5/8/2010)
In other words I am going to pivot it on Level but select name of the entity.
Hmmmm.... "pivot it on Level but select name of entity". Is 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)

May 8, 2010 at 7:27 pm

#1164639
RE: Are the posted questions getting worse?

Trey Staker (5/4/2010)
Steve Jones - Editor (5/4/2010)
Paul White NZ (5/4/2010)
Awesome - a KB article on how to post questions to an online forum:
http://support.microsoft.com/kb/555375
That's great. If only there were some way...
--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)

May 8, 2010 at 7:10 pm

#1164638

Viewing 15 posts - 38,551 through 38,565 (of 59,102 total)