Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,286 through 33,300 (of 59,099 total)

RE: How to generate SQL database scripts into XML file format

NLV (7/15/2011)
Hi,
I want to generate the database scripts into XML format (not data in the tables ..only scripts of a particular database).
I can't help because I don't even know how...
--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)

July 15, 2011 at 7:24 pm

#1353793
RE: Convert string to datetime

sql_novice_2007 (7/15/2011)
I have other time zones as well. But based on your help I was able to convert all the other data.
Thanks.
Very cool. Would you post your solution so...
--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)

July 15, 2011 at 7:22 pm

#1353791
RE: A Little Interviewing Advice

Just to add my 2 cents... There are a huge number of tasks required of a DBA that are made much simpler through the use of an ad-hoc query...
--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)

July 15, 2011 at 7:19 pm

#1353788
RE: probem with declare

jwbart06 (7/15/2011)
As a syntax thing use SET to assign value to the variable
set @_type = (select max(turno) from u_contadores)
Although it does work the way you wrote it is a little...
--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)

July 15, 2011 at 6:34 pm

#1353783
RE: Create View- T-SQL Syntax error

satishchandra (7/15/2011)
Trying to generate a T-SQL script for create view, if it does not exist.
Instead of the traditional approach of "if exists drop and Create", would like create 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)

July 15, 2011 at 6:09 pm

#1353779
RE: order by some records only

CELKO (7/15/2011)
The mess you posted is not a table at all! There is no key and it has duplicate rows so it can never have a key.
Correct. It's 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)

July 15, 2011 at 5:52 pm

#1353776
RE: Preventing Repeated Results in Query

opc.three (7/15/2011)
Very nice job posting usable DDL, DML and what you have tried! Provide your desired output relative to the same test data please and we'll see if we can...
--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)

July 15, 2011 at 4:51 pm

#1353769
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

There's something missing in the code Wayne... and I think it's the reason why it's so comparatively slow. Peter Larsson sent me some code for Running Totals. I'll...
--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)

July 15, 2011 at 3:34 pm

#1353751
RE: INNER JOIN with a String Challenge

Craig Farrell (7/15/2011)
To redeem myself, with the A B only linked requirement, try the following:
SELECT
ms.*,
ma.*
from
#MySample AS ms
JOIN
#MyAddress AS ma
ONLEFT(ms.ID, 9) = RIGHT( ma.AddressCode, 9)
WHERE
LEFT( ma.Addresscode, 6) = '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)

July 15, 2011 at 3:18 pm

#1353734
RE: INNER JOIN with a String Challenge

JohnDBA (7/15/2011)
I have to ask, Craig... REVERSE is fairly expensive performance-wise. Why any REVERSE's to begin with?
Jeff, better suggestions? Thank you!
And, yes... I'll try to get to this on...
--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)

July 15, 2011 at 8:17 am

#1353452
RE: INNER JOIN with a String Challenge

JohnDBA (7/15/2011)
I have to ask, Craig... REVERSE is fairly expensive performance-wise. Why any REVERSE's to begin with?
Jeff, better suggestions? Thank you!
Craig knew what I was talking about and posted...
--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)

July 15, 2011 at 8:14 am

#1353451
RE: need help with the code

Details are in the comments in the code...
--===== Create a test table. This is NOT a part of the solution.
CREATE TABLE TableA
...
--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)

July 15, 2011 at 12:15 am

#1353207
RE: INNER JOIN with a String Challenge

Craig Farrell (7/14/2011)
EDIT: FACEPALM :blush:
Heh... I'm not sure where you live but I'm pretty sure I heard that one way up here in Michigan. 😀
--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)

July 14, 2011 at 11:50 pm

#1353198
RE: Ranges as a component of a primary key

IMHO, Method #2 is definitely the better way go for a lot of the reasons you stated. It's called a "Type 2 Slowly Changing Dimension".
When I do such things,...
--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)

July 14, 2011 at 11:40 pm

#1353194
RE: Ranges as a component of a primary key

bopeavy (7/14/2011)Because I am not complete sure what you want to accomplish here. I would do something more like this statement:
CREATE TABLE Directory(
personID int IDENTITY(1,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)

July 14, 2011 at 11:34 pm

#1353191

Viewing 15 posts - 33,286 through 33,300 (of 59,099 total)