Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,196 through 27,210 (of 59,101 total)

RE: a query like factorial

schleep (3/19/2013)
How about:
IF OBJECT_ID('MyTable') IS NOT NULL
DROP TABLE MyTable
GO
SELECT * INTO MyTable
FROM (VALUES(1,19), (2,90), (3,20), (4,8), (5, 9)) AS M(ID, VALUE)
GO
SELECTm.Id, SUM(m2.Value)
FROMMytable m
JOINMytablem2ON m2.ID <=...
--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)

March 19, 2013 at 7:36 am

#1598420
RE: Few tricky Questions about SQL Server 2008 that I came across...

beginner_dk (3/18/2013)
the company or the recruiter is unaware of the questions and the answers. He will just receive the score card with the percentile of the candidate.
That's actually a major...
--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)

March 18, 2013 at 11:06 pm

#1598288
RE: Trace - to Capture all or most queries

Which company asked these as interview questions?
--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)

March 18, 2013 at 9:18 pm

#1598277
RE: Building my first data warehouse. Advice welcomed :)

alan.hollis 1097 (1/14/2013)
Hi all,
I've been brought on board to help a company start to build their first business intelligence setup. I'm a developer by trade, and have good knowledge 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)

March 18, 2013 at 9:12 pm

#1598274
RE: a query like factorial

Whoa!!! Who said anything about the OP storing the VALUE as a character based data type??? :blink:
@Masoud,
Take a gander at the article at the first link in my signature...
--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)

March 18, 2013 at 8:57 pm

#1598266
RE: Bitwise Operator Fundamentals

Evil Kraig F (3/18/2013)
Ahhh, bitvector (bitmask, bitwise operators, combined flags, flagfield, etc...), my old friend.
Alright, let's start with the basics. You said you've read up on it but some...
--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)

March 18, 2013 at 8:45 pm

#1598262
RE: Few tricky Questions about SQL Server 2008 that I came across...

beginner_dk (3/18/2013)
these are an online assessment test questions called proveit
Yowch! You should alert the company that made you go through the "Proveit" gambit and then show them Gail's...
--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)

March 18, 2013 at 8:37 pm

#1598261
RE: sp_updatestats and the default sampling rate

inHouseDBA (3/18/2013)
Anyone else?
Yes. You didn't mention what you're doing to reestablish the log chain after you break it by setting the DB to SIMPLE recovery mode. I'm just...
--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)

March 18, 2013 at 6:06 pm

#1598241
RE: Best Approach to Archieve DB

runal_jagtap (3/18/2013)
Example -
We have a DB which have loads of data & we want to archiev it to some Server in such a way that
Scenario - Source DB 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)

March 18, 2013 at 5:56 pm

#1598239
RE: Best Approach to Archieve DB

runal_jagtap (3/18/2013)
4 View ... 0 replies :w00t:
14 minutes... broad subject. Need more patience. 😉
--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)

March 18, 2013 at 5:51 pm

#1598237
RE: Sql Query

SqlServerLover (3/18/2013)
Thanks SSCrazy. Union all does not work in my case as i do not want two rows .........
but left join worked.. thanks.
Since you said there was no fixed key...
--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)

March 18, 2013 at 5:49 pm

#1598236
RE: Are the posted questions getting worse?

Evil Kraig F (3/18/2013)
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
Lynn Pettis (3/15/2013)
I am really trying not say anything more over ther, but is really difficult. Group time at the TitD.
Hi, My name...
--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)

March 18, 2013 at 5:35 pm

#1598233
RE: Are the posted questions getting worse?

bitbucket-25253 (3/18/2013)
Can I brag, can I boast ..... can I pat myself on my own back ... wether I can or can not .. I will
My one hundreth QOD has...
--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)

March 18, 2013 at 5:30 pm

#1598232
RE: Adding a min, max and avg column

Your post is a bit confusing. According to what you posted, the "Child ID 10" is actually in a column called "[Time Completed]".
Take a look at the first link...
--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)

March 18, 2013 at 4:56 pm

#1598225
RE: Pivot Query with Count

Dynamic SQL is definitely NOT required for this problem. We're not pivoting the names of the subdistrict or location type.
--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)

March 18, 2013 at 4:16 pm

#1598207

Viewing 15 posts - 27,196 through 27,210 (of 59,101 total)