Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,796 through 30,810 (of 59,101 total)

RE: Function to find whether last days of the month is weekend

siva 20997 (3/9/2012)
You need to add this function
CREATE Function [dbo].[Get_MyDate]( @dDate DateTime ) Returns DateTime
AS
begin
declare @mDate DateTime,@m1 Int,@m2 Int,@d1 Int
...
--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 10, 2012 at 9:21 am

#1457497
RE: Can anyone tell me free tools for dba?

Heh... must be the web browser that you're using. 😀
--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 10, 2012 at 9:13 am

#1457496
RE: SQL and binary numbers

siva 20997 (3/10/2012)
That is what the AND Operator does
Just to be clear... AND does no form of division. You may be able to emulate it with division but I...
--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 10, 2012 at 9:09 am

#1457495
RE: Can anyone tell me free tools for dba?

BWAA-HAA!!! One link coming right up, fellas!
[font="Arial Black"]Click here for requested link[/font]
--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 9, 2012 at 8:53 pm

#1457438
RE: SQL and binary numbers

The OP also said he was using DECIMAL. I understand the bit values being used but I didn't want people to mistake what you said for being limited 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)

March 9, 2012 at 8:45 pm

#1457436
RE: Bringing forward compound salaries by periodic salary increases in forecastscycle

Your use of all caps for column names would indicate that you might be trying to do this in Oracle. Are you using SQL Server or Oracle for 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)

March 9, 2012 at 8:43 pm

#1457435
RE: SQL and binary numbers

siva 20997 (3/9/2012)
These are like Bits in a Byte being switched on or off
AND ing with whatever (in this case 32) is the correct way
However doing that seems to 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)

March 9, 2012 at 9:24 am

#1457267
RE: Reading data from two CSV files

Once you've downloaded the splitter function from the bottom of the article that Mark pointed you to, you would solve the problem as follows...
--===== Declare the variables and preset them...
--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 9, 2012 at 7:06 am

#1457170
RE: Can anyone tell me free tools for dba?

My favorite of all time free tools... GOOGLE.
--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 9, 2012 at 6:10 am

#1457126
RE: SQL and binary numbers

I'd save on the headache by changing the datatype in the table to INT. I might even add some computed columns to the table to split out the individual...
--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 9, 2012 at 6:08 am

#1457125
RE: How to convert some columns into rows with the first two columns still retained as columns

rmelgarca (3/8/2012)
Thank you Jeff.
I was able to use the unpivot command but only with one column not translated.
What I did after that was to join it to the original table...
--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 9, 2012 at 5:45 am

#1457109
RE: Load Positional File

Ever considered using T-SQL BULK INSERT with a format 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)

March 8, 2012 at 9:07 pm

#1456942
RE: Number of working days

weston_086 (3/8/2012)
thanks this give me the result .but i donot want by this way .as i want based on workday(where workday='y').bcz i have another columns like workday_international which are all...
--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 8, 2012 at 8:53 pm

#1456938
RE: what is uniqueidentifier in sql how it will work

Sean Lange (3/8/2012)
To answer when you should use it...I would avoid it unless there is a legitimate reason to use it. Often it gets used as a primary key which...
--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 8, 2012 at 8:39 pm

#1456937
RE: Function to find whether last days of the month is weekend

Gianluca Sartori (3/8/2012)
Eugene Elutin (3/8/2012)
I wouldn't too, if my database would continuously change the language settings during the day...
😀 You made my day!
I can go home happy now!
Spaghetti and Porkchops...
--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 8, 2012 at 8:37 pm

#1456936

Viewing 15 posts - 30,796 through 30,810 (of 59,101 total)