Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,966 through 16,980 (of 59,101 total)

RE: Cast Varchar to Float Resulting In (Scientific) E Notation

waxingsatirical (8/25/2016)
Luis Cazares (6/3/2016)
using float is just lazy programming.
and by 'lazy' you mean??? Not doing unnecessary work?
No. More like not wanting to be bothered with best practice 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)

August 25, 2016 at 7:49 am

#1897467
RE: Cast Varchar to Float Resulting In (Scientific) E Notation

Wryan138 (6/3/2016)
Ron,
If they really must have their floating point columns you might want to try:
Str(ThatFloatField, 5, 2) -- nnn.nn
It will round the result (not truncate).
Wayne
That would slow things down...
--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 25, 2016 at 7:47 am

#1897466
RE: Executing dynamic functions in table select

paulo.margarido (8/24/2016)
i know my first aproach its uggly, and oi wanted to learn something more, and i do
Very cool. The first step is to stop saying things like...
i 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)

August 24, 2016 at 8:49 pm

#1897371
RE: Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement

@greg Larsen,
Your the one that got paid some decent money for posting this series. How about you answer some of the questions for a change!
--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, 2016 at 8:34 pm

#1897369
RE: A simple question

Just to be clear here...
You can't disable the actual Windows Login from SQL Server (well, you can but only if the server has Domain Admin privs and you really know...
--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, 2016 at 8:31 pm

#1897368
RE: Query output not display in HTML format

SQL Galaxy (8/24/2016)
I have received users report in email with respective data in column order in one database.
The following include two different query in different database for fetching data. but...
--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, 2016 at 7:47 pm

#1897365
RE: Insert changed data

p.s. It's also a huge waste of disk space to audit INSERTs. Only audit UPDATES and DELETEs. INSERTs will always be in the original table until they're...
--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, 2016 at 7:25 pm

#1897360
RE: Insert changed data

You need to write a trigger to do 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)

August 24, 2016 at 7:24 pm

#1897359
RE: updating a field with unique 15 digit navarchar

Yes but why are you using NVARCHAR to store "digits"? Also, you've not stated the full datatype for the column. NVARCHAR(???) ? And, what do you want...
--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, 2016 at 7:22 pm

#1897358
RE: Microsoft access database engine cannot open or write file

komal145 (8/24/2016)
It runs fine with all the SQL agent owner when i diable to task which copies the file to a archive folder. This can be done in Dev...
--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, 2016 at 7:12 pm

#1897357
RE: SSIS or Windows workflow foundation ?

learningsqlkid (8/24/2016)
Now someone in my team mentioned that this can be achieved easily with windows workflow foundation which provides the same capability in much more flexible way
That "someone" made...
--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, 2016 at 7:08 pm

#1897356
RE: Can anyone explain this....

The FLOAT datatype isn't based on the DECIMAL numbering system although the result is displayed as such. FLOAT is based on BINARY representations of DECIMAL numbers and, when 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)

August 24, 2016 at 8:48 am

#1897218
RE: Can anyone explain this....

durga.palepu (8/24/2016)
I have verified this and it works fine for me, refer to the attachment.
Just post code in the future, please. No one can execute a JPG.
--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, 2016 at 8:19 am

#1897209
RE: Partitioning worthwhile?

BTW... if the table isn't critical to a DR restore, you might want to simply move it to another database and add a synonym for it. That would allow...
--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, 2016 at 8:12 am

#1897207
RE: Partitioning worthwhile?

pdanes (8/24/2016)
BLOB_EATER (8/24/2016)
For me partitioning is about manageability first and performance second.
Your MDF is 500MB with 8 years growth? I'm not so sure you need to go down 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)

August 24, 2016 at 8:07 am

#1897204

Viewing 15 posts - 16,966 through 16,980 (of 59,101 total)