Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,261 through 31,275 (of 59,101 total)

RE: Only System Administrator can specify WITH

johnitech.itech (2/1/2012)
:w00t:
Hello i suggest you to use Using TRY...CATCH in Transact-SQL to avoid any undesired results
show below link
http://msdn.microsoft.com/en-us/library/ms179296.aspx
:hehe:
That's not likely to help with the privs necessary to write an error...
--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)

February 5, 2012 at 2:54 pm

#1442859
RE: cross tab display

wiseman82 (2/2/2012)
I've never cared much for the new syntax, but you can also use:
Ditto that.
--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)

February 5, 2012 at 2:41 pm

#1442858
RE: Partitioned table very slow after inserting data

goodluck (2/2/2012)
We have clustered index on EOM_INT_Loan_nbr. The table has following 7 partitions in format as below...
All of that is well and good but only if the queries are based...
--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)

February 5, 2012 at 2:38 pm

#1442857
RE: Remove all values in a table expect where specified

johnitech.itech (2/2/2012)
😛
Just to say ,Sumanta Roy say the same answer from my sound ;-);-) Thank you for your reply quick quick quicklyy
What does that actually mean?
--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)

February 5, 2012 at 2:31 pm

#1442855
RE: loops and cursor

svakka (2/3/2012)
Thank you all. Since the output of the result needs to be inserted into another table. The other option would be to do this programmatically with loops , if-then-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)

February 5, 2012 at 2:23 pm

#1442853
RE: complex problem

I have no idea and I think you're doing the right thing by working with DELL on this. Hopefully my response will also serve to "bump" your post back...
--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)

February 5, 2012 at 2:14 pm

#1442852
RE: How to find the difference between the numnbers in an increasing number series

CELKO (2/2/2012)
If you want to get a running total, then use a VIEW with the new windows clause in the SQL Server 2012 release.
Really??? How'z he going to do that...
--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)

February 5, 2012 at 2:03 pm

#1442851
RE: stored procedure header

gugan_ta (2/3/2012)
We have 60 stored procedures without headers. now we need to include below details in all sp. Is there any workaround to include below details in all sp 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)

February 5, 2012 at 1:50 pm

#1442850
RE: Text file to Temp Table

unnati.patel513 (2/3/2012)
Thank you very much..
i got my answer
Ok... so what was the answer? Two way street here. 😉
--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)

February 5, 2012 at 1:44 pm

#1442849
RE: Calculating Year to Date total

chrisvolny (2/3/2012)
What I want is to display the sum(decRebatableVolumeMTH) incrementally; like this. Hopefully, this makes sense.
74611413711820249902252
74611413711820250900252
74831090801767149907867
7483109080176715090186272193
74831090991767149902292
74831090991767150908611588
7483180281767149905635
748318028176715090126188131
If you'd be kind enough to provide a "CREATE TABLE" statment and some 2005 compatible...
--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)

February 5, 2012 at 1:39 pm

#1442847
RE: Query question

ssc_san (2/2/2012)
Got it Sean, Thanks!
Thanks Dave!
Would you post your final solution, please? It may help others in the future. Thanks.
--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)

February 5, 2012 at 1:31 pm

#1442846
RE: rebuilding indexes

johnitech.itech (2/5/2012)
Ok pls show m y below Link pls
ok check this link below
http://www.mssqltips.com/sqlservertip/2361/rebuilding-sql-server-indexes-using-the-online-option/%5B/url%5D
😉
The link doesn't work as is.
--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)

February 5, 2012 at 1:22 pm

#1442845
RE: Load data from excel sheet to table

As a sidebar, I generally don't import directly from Excel spreadsheets because you can't tell when someone might have it open. I usually tell people to do an export...
--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)

February 5, 2012 at 12:55 pm

#1442844
RE: Shrink file

sqlfriends (2/3/2012)
I have a vendor product that has some tables like track each change or history of activity, which make our tables really big, Currently the database data file reserved...
--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)

February 5, 2012 at 12:34 pm

#1442843
RE: Duplicate record delete

This will do as you asked. Are you sure you want to delete items that only have a single instance like your original post seems to indicate where 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)

February 5, 2012 at 12:22 pm

#1442842

Viewing 15 posts - 31,261 through 31,275 (of 59,101 total)