Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,931 through 24,945 (of 59,099 total)

RE: Hidden Formatting Troubles with STR() (SQL Spackle)

PHYData DBA (1/2/2014)
Jeff Moden (1/9/2011)
Mike McIver (1/9/2011)
Really . . . another ridiculous article! I am responding to this reader's reply to illustrate the problem. Misinformation breeds misinformation ....
--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)

January 2, 2014 at 10:47 am

#1677004
RE: How will get distinct records in SQL table?

LutzM (1/2/2014)
I don't think a simple DISTINCT will do it since it would return two rows ("Test." and "Test..") where one ("Test") is expected.
Maybe one of the following approaches 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)

January 2, 2014 at 7:24 am

#1676901
RE: drop clustered index ,rebuild or reorganize non clustered index?

Markus (1/2/2014)
I guess the question remains... why would you drop a clustered index on a table?
I can see doing it only if you need to change the keys for something...
--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)

January 2, 2014 at 7:18 am

#1676896
RE: Query for specific format

caippers (1/2/2014)
Perfect!
Glad to be of help. The next question is, do you understand how it works?
--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)

January 2, 2014 at 7:15 am

#1676895
RE: Need help to split Data

dwain.c (1/1/2014)
Jeff Moden (1/1/2014)
Sean Lange (12/20/2013)
Last name is "Camps" so possessive would be Camps' 😀
Doh!!! Sorry about getting your name wrong. :blush:
Dwain must have been "camping out" just waiting 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)

January 2, 2014 at 1:20 am

#1676803
RE: Document The Code Please !

dwain.c (1/1/2014)
homebrew01 (12/26/2013)
Just a General Request.
When giving a helpful reply, throw in a few comments to explain some of the less obvious SQL statements. It can make a world...
--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)

January 2, 2014 at 1:17 am

#1676802
RE: Query for specific format

SELECT columnlist
FROM dbo.SomeTable
WHERE PhoneNumber NOT LIKE '([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'
Edit: Moved out of place parenthesis.
--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)

January 2, 2014 at 1:13 am

#1676801
RE: How will get distinct records in SQL table?

sql-programmers (1/1/2014)
Thanks for your response..
I need little more specific..
Business logic is I need to export all values from a table without any duplication. I considered Test. Test.. are the duplicates.
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)

January 2, 2014 at 1:09 am

#1676800
RE: advice on ssas career

gurjer48 (1/2/2014)
Hi,
Currently I AM working in ssrs reporting job ,I have a offer from a good company where I have to work on ssis and ssas .mainly they are into...
--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)

January 2, 2014 at 1:08 am

#1676799
RE: hi need advice on career

gurjer48 (1/2/2014)
Hi,
Currently I AM working in ssrs reporting job ,I have a offer from a good company where I have to work on ssis and ssas .mainly they are into...
--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)

January 2, 2014 at 1:06 am

#1676798
RE: Dropping thousands of tables programmatically?

I realize this is an older post that might have already been accomplished but I wanted to note (in case someone else reads this) that only the page deallocations are...
--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)

January 1, 2014 at 2:16 pm

#1676768
RE: How to Show time in my table?

raghuldrag (12/5/2013)
Hi Friends,
My Table strct:
===========
create table show_bus
(
id int identity,
from_p varchar(100),
to_p varchar(100),
timin time
)
My Expecting OUTPUT:
================
insert into show_bus values('a','b','6:05 AM')
when i tried to enter these format its showing error on sql...
--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)

January 1, 2014 at 2:12 pm

#1676767
RE: Triggers for insert,update,delete in MSSQL

navimir (12/5/2013)
Could you plz let me know how to check in trigger for old value and new value so that the result can be added to audit table??
This is 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)

January 1, 2014 at 2:04 pm

#1676766
RE: Insert dates into table in the giving range.

fahey.jonathan (12/12/2013)
If you don't want to create a Tally table, you can use sys.columns instead and create a tally number in memory. According to my research, this is actually...
--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)

January 1, 2014 at 1:15 pm

#1676765
RE: SQL Thousand separator with round

fahey.jonathan (12/12/2013)
+1 for Sean; yes, formatting would better be done in the outputting program. If you have to do it in SQL, here is one option for your consideration....
--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)

January 1, 2014 at 1:08 pm

#1676764

Viewing 15 posts - 24,931 through 24,945 (of 59,099 total)