Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,761 through 32,775 (of 59,099 total)

RE: here the subject of u r problem

sandhya.msbi (8/24/2011)
can u explain how to create a job step by step and uses of it..
Yes, I can... but I'd just be reguritating what's in Books Online (the help system...
--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)

August 24, 2011 at 11:30 am

#1372738
RE: Automatic XML

Thanks, Lutz. I'll put a couple of samples together tonight.
Understood on the XSD schema files but the clients are actually relatively ignorant of XML and SQL. They're 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)

August 24, 2011 at 8:15 am

#1372601
RE: Automatic XML

LutzM (8/24/2011)
Jeff,
here are some additional sources you might want to have a look at:
Peso@SSC -> a similar approach like the one R.P.Rozema suggested and
Jason Follas blog. Jasons approach is 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)

August 24, 2011 at 7:42 am

#1372570
RE: Automatic XML

LutzM (8/24/2011)
Jeff,
here are some additional sources you might want to have a look at:
Peso@SSC -> a similar approach like the one R.P.Rozema suggested and
Jason Follas blog. Jasons approach is 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)

August 24, 2011 at 7:32 am

#1372559
RE: Automatic XML

R.P.Rozema (8/23/2011)
B.t.w. in this post I gave some pointers on how to set up Kerberos delegation to make the openrowset function even more useful by making it read the documents...
--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)

August 24, 2011 at 7:21 am

#1372541
RE: Automatic XML

Thanks for trying, R.P. That gives me a couple of ideas.
--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)

August 23, 2011 at 10:36 pm

#1372342
RE: Count Number of rows added within a certain time period

Greg, you'll get better and quicker responses if you format the data in a "readily consumable" format. See the first link in my signature line below for how 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)

August 23, 2011 at 9:10 pm

#1372331
RE: varbinary(float) to int

henrik staun poulsen (8/23/2011)
What do you think?
I don't know why anyone would think that 0xFFFFF2D7. It's simply a negative integer.
--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)

August 23, 2011 at 4:30 pm

#1372298
RE: Formula in Excel?

Here's a query I wrote a long time ago that makes sp_SpaceUsed look pretty lame...
http://www.sqlservercentral.com/Forums/FindPost730149.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)

August 23, 2011 at 4:24 pm

#1372296
RE: Are the posted questions getting worse?

Stefan Krzywicki (8/23/2011)
Earthquake in CO yesterday and now one in VA that I felt all the way in Boston.
Rumor has it that it was 6.0. We felt it 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)

August 23, 2011 at 4:17 pm

#1372293
RE: Formula in Excel?

sunny.tjk (8/23/2011)
My read permissions won't let me do that.
Why not write a view and submit it to the folks asking you to do the job so they can "promote 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)

August 23, 2011 at 4:14 pm

#1372292
RE: The Talent Crunch

IceDread (8/23/2011)
Hehe, getdate() however reads the clock from windows and if you change that one you are screwed.. that sql server relies on the os operated clock is astonishing 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)

August 23, 2011 at 4:09 pm

#1372290
RE: The Talent Crunch

What's really spooky to me is how little a lot of job applicants know about the basics and how many of them don't know what they don't know. I...
--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)

August 23, 2011 at 2:02 pm

#1372256
RE: View vs Ad-hoc T-SQL

I'm talking about the first line of the SELECT list.
--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)

August 23, 2011 at 1:41 pm

#1372246
RE: View vs Ad-hoc T-SQL

Something's not right here... you should be getting an error about not being able to resolve the Customer_ID column because it lives in both tables and you don't have a...
--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)

August 23, 2011 at 12:25 pm

#1372212

Viewing 15 posts - 32,761 through 32,775 (of 59,099 total)