Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,466 through 27,480 (of 59,101 total)

RE: How to code Crosstab query?

The offlowing article explains it all.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

February 18, 2013 at 12:11 pm

#1588939
RE: You are a database administer for a multi-national...

L' Eomot Inversé (2/17/2013)
SET Language doesn't solve the problem. Currencies are probably different too, and that is going to have to be deal with. Of the options offered,...
--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)

February 17, 2013 at 9:40 am

#1588678
RE: You are a database administer for a multi-national...

Ric Sierra (4/24/2008)
The best way could be send the date in ANSI format: yyyy-mm-dd
I agree except it should be YYYYMMDD. The dashes aren't actually part of ISO or ANSI.
--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)

February 17, 2013 at 9:37 am

#1588677
RE: Duplicating Certain number of rows

Yeah... my bad. You did. I guess I just can't believe that someone designed the database to use a FLOAT datatype for such a thing. It's limited...
--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)

February 16, 2013 at 2:19 pm

#1588632
RE: TIME OUT

If you run the following, how many rows do you get?
select nid from table2 where bid=31
--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)

February 16, 2013 at 1:50 pm

#1588627
RE: Fibonacci numbers using a function.

byecoliz (2/15/2013)
Hello,I am calculating the first 20 Fibonacci numbers using a function,but getting wrong answer.The condition is to write a function not a procedure. here is my try,help me.
create function...
--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)

February 16, 2013 at 12:51 am

#1588582
RE: Fibonacci numbers using a function.

Sean Lange (2/15/2013)
I converted this into an inline table value function like this.
Careful now. That's not an "inline" TVF. That's a "multiline" TVF. An iTVF must be...
--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)

February 15, 2013 at 8:31 pm

#1588576
RE: Please suggest me

gopilqs (2/14/2013)
i would like to change carrer to sql dba
Why? Is it because you think there's a lot of money involved? For a lot of DBAs, they 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)

February 15, 2013 at 5:42 pm

#1588565
RE: Declared Variable in WHERE clause weird behavior

duane+sql (2/15/2013)
I'm seeing a huge performance difference between two queries that are almost identical. The only SQL difference is in the WHERE clause:
Query1: QueryID=@QID
Query2: QueryID=ISNULL(@QID,A.QueryID)
Full Query 1 takes 100x +...
--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)

February 15, 2013 at 5:34 pm

#1588564
RE: manage data file growth

30MB per day * 365 days is rougly 11GB. Set your current database size to 24GB (current size) + 11GB (anticipated growth) for a total of 35GB and be...
--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)

February 15, 2013 at 4:44 pm

#1588560
RE: Using a date table in a parameter

This will work (for mm/dd) in T-SQL for just about any version. Not sure if it'll work in SSRS and it's not much more sophisticated than what you had.
DECLARE...
--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)

February 15, 2013 at 4:38 pm

#1588559
RE: Using a date table in a parameter

jbalbo (2/15/2013)
Put what I have are 4 titles for 4 week prior to the parameter date and I wanted to write them out as mm/yy
Do you really mean "mm/dd" IAW...
--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)

February 15, 2013 at 4:25 pm

#1588558
RE: Parent to Child and subchilds

anilkumar04_b (2/12/2013)
Hi All,
I need to get the count of this without using Start With connect by option.
Why? Whats wrong with the CONNECT BY option?
--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)

February 15, 2013 at 4:05 pm

#1588555
RE: Display on Month and Year from date formula ??

I suppose consistency is a good reason. But, let's try something just for fun. Write some code to add 41:41:41.041 to a given date.
--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)

February 15, 2013 at 4:01 pm

#1588554
RE: How to export data from SQL in ad hoc way and have the data be emailed to user as csv/xls?

halifaxdal (2/15/2013)
This is not a pure database job, it might also involve works from front-end but I am hoping to get some idea from here. Thanks.
In my project, I need...
--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)

February 15, 2013 at 3:57 pm

#1588553

Viewing 15 posts - 27,466 through 27,480 (of 59,101 total)