Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,876 through 25,890 (of 59,099 total)

RE: Build menu with CTE ....

NM.
--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)

September 22, 2013 at 5:22 pm

#1652224
RE: For Each Loop Uploads the Same File Infinitely

Thanks, Vikash.
--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)

September 22, 2013 at 1:12 pm

#1652204
RE: TempDB best practices - Doubt

Double post. No replies here. Please post any answers at the following so we don't split up the answers. Thanks.
http://www.sqlservercentral.com/Forums/Topic1496996-8-1.aspx
--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)

September 22, 2013 at 12:13 pm

#1652201
RE: TempDB best practices - Doubt

LOVER OF SQL (9/22/2013)
someone to volunteer?
Sure. Please see the following links.
https://www.google.com/#q=paul+randal+number+of+tempdb+files
http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/
--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)

September 22, 2013 at 12:01 pm

#1652200
RE: For Each Loop Uploads the Same File Infinitely

Vikash Kumar Singh (9/21/2013)
If you could share your design of SSIS that might be helpful to resolve this. A different approach that you can try is SSIS: How to load...
--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)

September 22, 2013 at 11:50 am

#1652199
RE: How to Write Query for the Below Requirement?

perireddy.arikatla (9/22/2013)
Thanks For your Valuable Reply Sir.
It works when i give tha Party_code in the where clause
i.e
SELECT party_code, sum(inst_amt) as total_insts,
(Select Sum(paid_amt) as total_paid
...
--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)

September 22, 2013 at 11:29 am

#1652198
RE: Repeating update or replace statement for column

azdeji (9/22/2013)
I want to create an update or replace statement which replaces Event_Code column with repeating values instead for example
B100
B102
B103
....
...
all the way to 10 and repeat again to 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)

September 22, 2013 at 11:25 am

#1652197
RE: Build menu with CTE ....

According to the ID and IDRoot of the test data, your desired output seems to be a bit off if you want these menu items to be sorted in order...
--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)

September 22, 2013 at 9:37 am

#1652195
RE: Want to add Text data

niladri.primalink (9/20/2013)
Sorry For using the word 'it'.
Actually the code what SScrazy sent to me is working for me.
That's why I wrote it is working for me.
If I hurt...
--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)

September 21, 2013 at 10:46 am

#1652143
RE: Reduce the size of database

shiwani.plrs (9/20/2013)
hello
The Size of my database has been increased to 10-20 GB, although the RAM of my server is quite good, still it takes lot of time to open...
--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)

September 21, 2013 at 10:17 am

#1652142
RE: Relationship Question

RedBirdOBX (9/19/2013)
I would like the ability to run a SP to clear out all the test tables in preparation for the next test.
I have a frequent need to do...
--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)

September 21, 2013 at 10:15 am

#1652140
RE: Build menu with CTE ....

PiMané (9/21/2013)
The values that 'name' has are just for ordering porpoise, for easier visualization of the results...
'name' actually has Accounting, Sales, Purchases, Human Resources, etc...
If the "Name" column actually contains...
--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)

September 21, 2013 at 10:06 am

#1652138
RE: Granting select to all databases current and future?

lbrady (9/20/2013)
I have a user who needs select permissions to all databases on a server.
From a data security aspect, I'd really want to know why that's necessary. I'd also...
--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)

September 20, 2013 at 10:56 pm

#1652106
RE: Varchar to numeric ???

sqlnaive (9/20/2013)
🙂 No worries Sean. but thanks about the STR functionality. Was playing with it and had fun to know about some things. 🙂
Be a bit leary of the STR()...
--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)

September 20, 2013 at 10:31 pm

#1652105
RE: Are the posted questions getting worse?

CapnHector (9/20/2013)
Jeff Moden (9/20/2013)
hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been...
--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)

September 20, 2013 at 10:06 pm

#1652104

Viewing 15 posts - 25,876 through 25,890 (of 59,099 total)