Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,381 through 25,395 (of 59,099 total)

RE: INSERT that automatically increments sub sequences and generates "hierarchical" string, keeping in mind concurrent invocations

Sean Lange (11/19/2013)
Jeff Moden (11/19/2013)
Sean Lange (11/19/2013)
Save yourself months of anguish and use the hierarchyid datatype. This is essentially what you are trying to recreate on your own.
http://technet.microsoft.com/en-us/library/bb677290.aspx
BWAAA-HAAAA!!!! Save yourself...
--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 19, 2013 at 3:14 pm

#1667610
RE: convert CSV file to XML file format based on XSD file using SSIS (SQL Server 2008R2)

miraeg66 (11/13/2013)
thanks alot for the info
Heh... foreign language or not, I hate SPAM! Reported!
--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 19, 2013 at 3:05 pm

#1667606
RE: Are the posted questions getting worse?

Stefan Krzywicki (11/18/2013)
Has anyone heard anything about partitioning in 2014 making drastic performance improvements? I was at a presentation on SQL Server 2014 recently and the presenter, a Microsoft guy,...
--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 19, 2013 at 2:43 pm

#1667599
RE: INSERT that automatically increments sub sequences and generates "hierarchical" string, keeping in mind concurrent invocations

Sean Lange (11/19/2013)
Save yourself months of anguish and use the hierarchyid datatype. This is essentially what you are trying to recreate on your own.
http://technet.microsoft.com/en-us/library/bb677290.aspx
BWAAA-HAAAA!!!! Save yourself continuous anguish and store...
--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 19, 2013 at 1:15 pm

#1667563
RE: how to display totals grand total in t-sql

clayman (11/19/2013)
dastagiri16 (11/19/2013)
hi,
i need the text like "TOTAL" ...rollup wont give it...
Please advice
Use SSRS
BWAAAA-HAAAA!!!! Sure it's easy to get to the moon. All you have to do...
--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 19, 2013 at 1:10 pm

#1667560
RE: replacement of format(0,"percent") in SQL

davoscollective (11/18/2013)
Lowell (3/10/2009)
not built in , no; typically formatting is left for the presentation layer, like vb;
you can do something pretty close:
declare @val decimal (12,6)
set @val = 0.43365
select convert(varchar,convert(decimal(5,2),@val* 100.0))...
--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 18, 2013 at 11:08 pm

#1667303
RE: Selecting rows based on Timestamp column

The TIMESTAMP (or RowVersion) datatype is a VARBINARY. Convert it to an INT or BIGINT.
--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 18, 2013 at 6:02 pm

#1667283
RE: Interview Question

Mani-584606 (11/18/2013)
Can you please let me know what would be the right answer for the following?
1. What should be strategy to minimize the impact on external system which 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 18, 2013 at 5:36 pm

#1667280
RE: Cursor fetch loops endlessly

Peter Schulz-485500 (11/18/2013)
I have a bit of a hard time disconnecting everybody. But I'll try this next.
Disconnecting everyone and everything is the easy part. Just make sure that you...
--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 18, 2013 at 5:23 pm

#1667275
RE: Age

valeryk2000 (11/18/2013)
So far I checked the code several times - and it was ok. Where is a potential error?
Here's one of many places where it fails because of Leap Years...
...
--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 18, 2013 at 1:01 pm

#1667226
RE: Are the posted questions getting worse?

WayneS (11/17/2013)
Speaking of Tally / Numbers tables - does anyone have a tally-table based query that you wish would run even faster? I'm going to be doing a test of...
--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 17, 2013 at 10:36 pm

#1667010
RE: 2 records at a time?

jessica.green2312 (11/15/2013)
Hi everyone,
I'm not even sure how to word this succinctly enough to search for this topic, so I apologize in advance if this is covered elsewhere! It almost feels...
--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 17, 2013 at 10:11 pm

#1667006
RE: Write to text file

Try this for your command...
SET @sCmd = 'echo ' + @importedquery + ' > "C:\inetpub\wwwroot\cleansed\file.txt"'
Also, you should check any such concatenated variables for "DOS Injection" just like you would 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)

November 17, 2013 at 9:55 pm

#1667005
RE: Cursor fetch loops endlessly

Peter Schulz-485500 (11/17/2013)
Jeff - yes I can put the FROM Addresses in the query, but it doesn't
change the behaviour. It also should not.
I'll solve the problem by rewriting. 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)

November 17, 2013 at 9:22 pm

#1667004
RE: query logic question...

roy.tollison (11/16/2013)
i guess i could put the results into a table then use a cursor and process all the rows and use the value in the cf_field(real column name 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 17, 2013 at 5:52 pm

#1666990

Viewing 15 posts - 25,381 through 25,395 (of 59,099 total)