Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,181 through 27,195 (of 59,101 total)

RE: How to call a batch file to execute from an SP

Michael L John (3/20/2013)
1. Take the call to xp_cmdshell out of the SP.
2. In the SP, test for the condition that would trigger the call to the batch file.
...
--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 20, 2013 at 5:57 pm

#1599193
RE: Add variable number of rows into a table based on the values in another table (without cursors/while loops)

Lynn Pettis (3/20/2013)
Sean Lange (3/20/2013)
Sure this isn't too hard using a tally table.
insert #y
select #x.DocID, t.N
from #x
join tally t on t.N <= #x.pages
select * from #y
You can read...
--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 20, 2013 at 1:24 pm

#1599103
RE: Primary key or not to primary key, that is the question

Eugene Elutin (3/19/2013)
But, when you have NIC installed, it makes it unsecured, as it's based on the MAC address of NIC and can be predicted.
Just to be clear for...
--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 20, 2013 at 8:43 am

#1598942
RE: how to count unique id entry?

You'll also get coded responses if you take the small bit of time to provide your data in a readily consumable form instead of a graphic. Read the article...
--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 20, 2013 at 6:38 am

#1598868
RE: best optimized query for the requirement

Shanmuga Raj (3/20/2013)
Thanks.. its working !
can you let me know why you have used
HAVING COUNT(*) = 4
That's to make it so that only those product_ids that have 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)

March 20, 2013 at 6:34 am

#1598867
RE: best optimized query for the requirement

foxxo (3/20/2013)
SELECT DISTINCT product_id FROM fact_sales WHERE (agent_id=1 AND product_code in (1)) OR (agent_id=2 AND product_code in (3)) OR (agent_id=3 AND product_code in (2))
OR (agent_id=4 AND product_code in (1))
AND & OR operators
http://www.w3schools.com/sql/sql_and_or.asp
I'm...
--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 20, 2013 at 6:21 am

#1598856
RE: SP Help

SqlServerLover (3/20/2013)
Sorry guys.. please do not reply now.. It sounds funny but there was a reason for posting this..
NP. Tell us the reason.
--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 20, 2013 at 12:41 am

#1598735
RE: How to get month number like Jan -01, Feb-02 ... Instead of Jan-1, Feb-2

Or maybe a little "silent truncation" (one of my favorite tools) is in order.
SELECT CONVERT(CHAR(2),GETDATE(),1)
--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 20, 2013 at 12:25 am

#1598731
RE: SP Help

SqlServerLover (3/19/2013)
Can anyone help me to write programs for attached problems? 😀
Wow... seriously? Since it's a test, at least try. :Whistling:
--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 20, 2013 at 12:18 am

#1598728
RE: Need help to read text file

idyana (3/19/2013)
Hi,
My text file as attachment ~ AG-Persekutuan-Bln-09-2012.txt
How to read this file as follows,
1. Taxpayer data starting in the second row
2. The 1st TaxPayer read as follows,
WHOA! Hold 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)

March 20, 2013 at 12:11 am

#1598727
RE: Data not inserting

Sean Lange (3/19/2013)
Why not just look at the excellent code that Chris M posted earlier in one of the dozen or so threads on the same topic.
http://www.sqlservercentral.com/Forums/Topic1432131-391-1.aspx#bm1432134
Why not, indeed. ...
--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 19, 2013 at 6:44 pm

#1598691
RE: a query like factorial

schleep (3/19/2013)
Yikes. Thanks for pointing that out Jeff.
I've only (reluctantly) used it with very small sets, mostly in pre-2K5 code.
I'll be checking my code now...
You bet and thanks for 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)

March 19, 2013 at 6:06 pm

#1598681
RE: Data not inserting

Sean Lange (3/19/2013)
Jeff we have seen this same loop in several threads in the last day or two. Chris posted a great solution on one of them that got rid...
--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 19, 2013 at 9:44 am

#1598509
RE: Best Approach to Archieve DB

runal_jagtap (3/19/2013)
Thanks Jeff 🙂
Currently me planning to go with SSIS Package Automation...
Well see how i succedd.. incase any query i will come here again.. stating
65 views & 0 replies :w00t:...
--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 19, 2013 at 9:40 am

#1598506
RE: Best Approach to Archieve DB

One very effective approach would be to "partition" the table but that's only if you have the Enterprise Edition and, IIRC, if you don't mind the "archive" being in 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)

March 19, 2013 at 7:56 am

#1598436

Viewing 15 posts - 27,181 through 27,195 (of 59,101 total)