Jeff Moden

Forum Replies Created

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

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
RE: Are the posted questions getting worse?

tosscrosby (5/5/2010)
Hey, we all work for the same company!
Man, I wish other folks would finally get THAT message. You anywhere near Detroit or Ann Arbor 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)

May 8, 2010 at 7:07 pm

#1164637
RE: SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file

For us, it was a virus checker and someone forgot to exclude MDF, LDF, and NDF files. It brought us to a crawl. Diskkeeper, on the other hand,...
--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:04 pm

#1164636
RE: Are the posted questions getting worse?

Grant Fritchey (5/6/2010)
Steve Jones - Editor (5/6/2010)
Top Ten Posters in this thread (out of 15,100 or so)
Lynn Pettis ...
--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 6:53 pm

#1164635
RE: SQLServer Agent 'sed' job reporting success; but does nothing

johnzabroski (5/5/2010)
I *HATE* Blackboxes.
Heh... I'm right there with you on that one. I've been known to impliment code just to say away from them.
I haven't checked it but 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 6:38 pm

#1164632

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