Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,216 through 46,230 (of 59,101 total)

RE: Split a date-range into periods

HanShi (10/23/2008)
I have work out your solution. Maybe others can benefit from this code.
As you allready mentioned, this solution is more generic. The TALLY table now only contains the number...
--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, 2009 at 7:10 pm

#920062
RE: help with sqlcmd

Lookup "OSQL Utility" in Books Online.
The real key here is, why are you trying to do this from the command line... SQL Server can check to see if a file...
--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, 2009 at 6:55 pm

#920059
RE: Partitining an existing table

I read the article, probably I dont have a high IQ, could you please let me know what I've done wrong and what I should do?
Reading just one article probably...
--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, 2009 at 6:19 pm

#920054
RE: getting all records between 2 fridays of a given date

Piotr Rodak (1/1/2009)
It does unfortunately..
set language us_english
go
select @@datefirst, datepart(dw, getdate())
go
set language british
go
select @@datefirst, datepart(dw, getdate())
I had to cope with this on a few occasions.
Piotr
That would be true if I used...
--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, 2009 at 5:59 pm

#920053
RE: Cursors Be Gone!

One of my fellow MVP's... Go back and look at Grant's posts... you'll figure it out. I've probably said too much, already.
--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, 2009 at 5:52 pm

#920052
RE: getting all records between 2 fridays of a given date

Datefirst doesn't even come into play on 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)

January 1, 2009 at 2:26 pm

#920033
RE: Join Query (Please Urgent !!!!!!!!!!)

Heh... interview must be over, huh? 😛
--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, 2009 at 2:23 pm

#920032
RE: The Year in Review 2008

Steve Jones - Editor (12/31/2008)
Guess no one is working today or my cell phone woes didn't strike anyone as funny.
Heh... not supposed to slam "Dash" phones against the "Dash"... that'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)

January 1, 2009 at 2:21 pm

#920030
RE: Join Query (Please Urgent !!!!!!!!!!)

This is obviously either homework or an interview test.
First, please read the article at the link in my signature below for how to post questions concerning data.
Second, show us what...
--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, 2009 at 1:57 pm

#920026
RE: SQL Help Required!!

Venkat (1/1/2009)
The Best way to handle this is..
Instead of storing the value as column in table
Write a Function which will return the contribution percentage
example F_GET_COUNTRY_CONTRIBUTION ( country_name, Year)
By...
--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, 2009 at 1:55 pm

#920025
RE: Dynamic Sql

EXEC (@SQL1+@SQL2+@SQL3...+@SQLn)
--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, 2009 at 1:48 pm

#920022
RE: Industry Experience... Required?

While I believe that industry experience can, indeed, be a huge help, I believe it should be "nice to have" rather than a requirement when it comes to DBA's and...
--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, 2009 at 1:46 pm

#920021
RE: aagghh! More XQuery trouble

The more I see about the problems of XML in a database, whether real or percieved, the more happy I am that I've taken the very bitter and hardline stance...
--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, 2009 at 1:38 pm

#920017
RE: Help creating a SQL query

santosh.shrestha (1/1/2009)
Thank you very much I have figured it out. It was quite easy. Thanks for advice regarding datatype. now I have to work on datatype of Table1. Due to...
--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, 2009 at 1:27 pm

#920015
RE: Cursors for T-SQL Beginners

gryphonsclaw (1/1/2009)
You don't have to use a cursor to concatenate a string.
DECLARE @myVar varchar(MAX)
SET @myVar = ''
SELECT @myVar = @myVar + mycolumn + ' '
FROM myTable
SELECT @myVar
The author...
--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, 2009 at 1:18 pm

#920014

Viewing 15 posts - 46,216 through 46,230 (of 59,101 total)