Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,851 through 35,865 (of 59,099 total)

RE: Converting Quartz.Net time columns to datetime

My apologies. I normally document what I did a lot better but I was in a rush. Here's how I came to those numbers from the excellent description...
--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)

November 29, 2010 at 5:29 pm

#1256550
RE: How do I, in effect, SELECT FROM a stored procedure

Actually, my bad. I didn't read the whole post to see what the data source actually was. I agree that the Information_Schema views are the ticket in 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)

November 29, 2010 at 4:46 pm

#1256548
RE: Are the posted questions getting worse?

WayneS (11/29/2010)
CirquedeSQLeil (11/29/2010)
On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business and make sure we have...
--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)

November 29, 2010 at 4:40 pm

#1256546
RE: How to create procedure from definition of another procedure

I agree with Scott... the OBJECT_DEFINITION function is documented and easy to use for just about everything except a table. Take a look in Books Online for the details.
--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)

November 29, 2010 at 4:35 pm

#1256543
RE: Need help writing the correct SQL

Hi Sergiy,
Glad to "see" you still come around once in a while. 🙂
I understand the basic misgiving there but EXCEPT does only return "distinct" values much like a GROUP BY...
--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)

November 29, 2010 at 4:26 pm

#1256541
RE: Need help building a query.

GSquared (11/29/2010)
Wayne, just because a table has an ordered clustered index, doesn't mean an identity column will honor that order. Usually it will, but you can't guarantee it.
Jeff's solution...
--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)

November 29, 2010 at 4:10 pm

#1256539
RE: Help to write a regular expression

Helical Johan (11/26/2010)
Hi,
I need write a regular expression:
1. Must start in caracter - next to any letter.
2. Must end in caracter - next to any number.
For example:
5D-Canada-Alberta-Calgary-5715-#3#3-9990516-V3-Local-8-0-0
My output is:
Canada-Alberta-Calgary
Thanks.....
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)

November 29, 2010 at 6:37 am

#1256220
RE: How to create procedure from definition of another procedure

roman.goldenberg (11/29/2010)
Thanks...
I do this in production for save back up's before altering procedure
As a side bar, backups of this nature are fine but you may want to look into some...
--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)

November 29, 2010 at 6:35 am

#1256218
RE: exec scope

nadersam (11/29/2010)
Thanks Jeff,
That's exactly what i will start working on in the next period.
Thanks for the feedback, nadersam.
--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)

November 29, 2010 at 6:34 am

#1256217
RE: what is highavailability solutions

p.s. If, as your subtitle to the post implies, this is only for log shipping, I recommend you start reading "Books Online" (the free help system that comes with...
--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)

November 28, 2010 at 10:24 pm

#1256106
RE: what is highavailability solutions

shoukat.shaik (11/28/2010)
how we can perform highavailability solutions
Gosh... people write thousand page books on the subject. I'm sure folks will give you some hints but this is much to large...
--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)

November 28, 2010 at 10:20 pm

#1256104
RE: Close,Deallocate cursor with rollback

Ashwin M N (11/28/2010)
The cursor I have shown above is just an example the actual is more complicated than above.
Complexity changes nothing here. 99.9999% of the time, there 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)

November 28, 2010 at 10:17 pm

#1256102
RE: Need help writing the correct SQL

Sergiy (11/28/2010)
New tools make solutions more complex and less effective.
😉
Here how would it look with "classic" SQL:
SELECT DocNo
FROM #Docs QE
WHERE LStatus = 'QE'
...
--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)

November 28, 2010 at 10:05 pm

#1256098
RE: Need to Delimiter from right to left

sampathsoft (11/22/2010)
Can you change this scenario from right to left .
Thanks
DECLARE @NextString NVARCHAR(40)
DECLARE @Pos INT
DECLARE @NextPos INT
DECLARE @String NVARCHAR(40)
DECLARE @Delimiter NVARCHAR(40)
DECLARE @AddString NVARCHAR(50)
--SET @String ='SQL,TUTORIALS'
SET @String ='1.2.3 '
SET @Delimiter...
--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)

November 28, 2010 at 8:21 pm

#1256087
RE: Need to Delimiter from right to left

Adi Cohn-120898 (11/22/2010)
Not sure that I understood what you want. If I understood you correctly then this is the way to do it:
DECLARE @NextString NVARCHAR(40)
DECLARE @pos INT
DECLARE @NextPos INT
DECLARE...
--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)

November 28, 2010 at 7:48 pm

#1256085

Viewing 15 posts - 35,851 through 35,865 (of 59,099 total)