Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,481 through 27,495 (of 59,101 total)

RE: Need urgent help in a tricky t-SQL

Abu Dina (2/15/2013)
Group hug? 😀
Ewwww! 😉
--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:51 pm

#1588551
RE: removing duplicates rows from a parent table.

Sean Lange (2/15/2013)
gopikishan.maheshwarlal (2/15/2013)
Hi all,
i need help in deleting duplicate records from a table a. but the table which i'm going to delete has 2 child tables, table b...
--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:43 pm

#1588549
RE: Duplicating Certain number of rows

You still haven't answered the other questions. What determines how many dupes you want to add? What is the datatype of the column you want to do 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)

February 15, 2013 at 3:38 pm

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

Sean Lange (2/15/2013)
You should use DATEADD because the simple math does not work with date or datetime2 datatypes.
I have to ask... if you're not using the DATE or DATETIME2 datatypes,...
--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:36 pm

#1588544
RE: Using a date table in a parameter

jbalbo (2/15/2013)
Hi,
I have a parameter startdate, I am using a shared dateset which gets the value do a dimdate table to only display friday dates.
Is there away to set 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)

February 15, 2013 at 3:20 pm

#1588539
RE: Best way to insert into two related tables?

OTF (2/15/2013)
You can also take a look at using OUTPUT.
I've found that to be a wee bit more difficult than you would think unless you have an alternate key 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)

February 15, 2013 at 3:18 pm

#1588536
RE: SSIS ForEach Loop Container - loop through all DB's

It's the Database!!! (2/15/2013)
I am trying to get the FELC to loop through all the databases for my sql server. I want to set up a variable by database_id from...
--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:13 pm

#1588533
RE: Unseen characters

prathibha_aviator (2/15/2013)
For example a field with 760 jenness should give me an output of 12 instead of 11..
Perhaps it's just a bit of phat phingering but "760 jenness" only...
--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:10 pm

#1588529
RE: Fibonacci numbers using a function.

I don't understand why people write functions for this. No matter how many time you run the code , the values will NEVER change.
Why not just build...
--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 2:52 pm

#1588521
RE: Duplicating Certain number of rows

So how do you expect to store "100640A" in your database as a FLOAT? That just can't happen. You'll need to change the column to VARCHAR and 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)

February 15, 2013 at 11:42 am

#1588454
RE: SQL Developer to SQL DBA

ScottPletcher (2/15/2013)
Those people aren't DBAs. If you're a DBA, it is absolutely self evident to you that you need backups.
That's why I raised the flag on this. 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)

February 15, 2013 at 11:40 am

#1588451
RE: SQL Developer to SQL DBA

ScottPletcher (2/15/2013)
I've got scripts that will generate point-in-time recovery scripts. And generate and execute tail log backups.
I suspect you could get a script(s) from the web for that 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)

February 15, 2013 at 11:38 am

#1588449
RE: create a function to remove vowels from a given string

Abu Dina (2/15/2013)
Jeff Moden (2/15/2013)
byecoliz (2/15/2013)
thank you all for that new code. Abu Dina, you're right on the return correction. Now when i do that correction the function removes only...
--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 10:13 am

#1588413
RE: TRIGGER does not commit

Sean Lange (2/15/2013)
Well it seems that while I writing my response you edited the original trigger and posted almost exactly the same thing I was suggesting. 😀
Heh... I have users...
--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 10:06 am

#1588409
RE: SQL Developer to SQL DBA

ScottPletcher (2/15/2013)
Jeff Moden (2/14/2013)
ScottPletcher (2/14/2013)
That's a significant change!
In order, here's a quick list of the most important things to do first:
1) Make sure the DBA role will fit you. ...
--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 9:42 am

#1588390

Viewing 15 posts - 27,481 through 27,495 (of 59,101 total)