Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,871 through 21,885 (of 59,098 total)

RE: Tipping point for a numbers table vs inline tally

sqldriver (1/16/2015)
Well, it looks like jokers and deuces are wild here.
Heh... nah. King with the axe and one-eyed jacks. 😉
--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 16, 2015 at 7:03 pm

#1770931
RE: Are the posted questions getting worse?

Lynn Pettis (1/16/2015)
Sometimes trying to get answers from people is like pulling chicken teeth.
Heh... do like I do. I avoid the barnyard if I can. I don't try...
--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 16, 2015 at 5:43 pm

#1770927
RE: How to ignore "String or binary data would be truncated"

To be sure, the point I'm trying to make is that this error happens for a reason. You say there are a lot of columns in this table... are...
--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 16, 2015 at 5:01 pm

#1770921
RE: Export SQL Data to CSV using Batch Scripting

venkyzrocks (1/16/2015)
Hi,
Here's the issue I'm having.
1. the bcp output doesn't include headers
So, make some using a separate SELECT UNION ALL
2. the sql is too long to be included in...
--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 16, 2015 at 1:34 pm

#1770891
RE: Tipping point for a numbers table vs inline tally

Eirikur Eiriksson (1/16/2015)
Jeff Moden (1/16/2015)
sqldriver (1/16/2015)
You guessed right on the seconds 🙂
"Lawyers" and their "billable hours"; we should all be so lucky.
Oh my word! That's bloody well insane. :hehe:...
--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 16, 2015 at 1:23 pm

#1770888
RE: How to ignore "String or binary data would be truncated"

halifaxdal (1/16/2015)
Jeff Moden (1/16/2015)
halifaxdal (1/16/2015)
no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this issue.
based on...
--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 16, 2015 at 11:42 am

#1770848
RE: How to ignore "String or binary data would be truncated"

halifaxdal (1/16/2015)
no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this issue.
based on your table, 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)

January 16, 2015 at 10:04 am

#1770815
RE: Create a script to search for a missing word or a phrase

T.Ashish (1/16/2015)
Hi all,
We compulsorily use NOLOCK in our scripts on reporting DB and development generally forget putting NOLOCKS or schema names with tables.
Can anybody guide me in creating a...
--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 16, 2015 at 9:51 am

#1770810
RE: Help With Trying to Import File Names into a Table

Samuel Vella (1/16/2015)
Jeff Moden (1/15/2015)
No problem. Thank you very much for your efforts.
I have to admit that when it comes to SSIS, I get totally lost because I don't...
--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 16, 2015 at 9:47 am

#1770808
RE: Help With Trying to Import File Names into a Table

Lempster (1/16/2015)
Jeff Moden (1/15/2015)
Shifting gears on this same subject, let's have some fun and do a cooperative exploratory on a very typical spreadsheet import problem.
I've attached a spreadsheet (Sample Spreadsheet...
--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 16, 2015 at 9:35 am

#1770803
RE: Help With Trying to Import File Names into a Table

Samuel Vella (1/16/2015)
On the subject of T-SQL vs SSIS
SSIS shines when you have a lot of data outside of a database which needs manipulation before you load it into tables....
--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 16, 2015 at 9:30 am

#1770801
RE: How to ignore "String or binary data would be truncated"

halifaxdal (1/16/2015)
Hello, I have a script to be used to backup a specific table in a weekly basis, here is the approach what I take, if you have a better...
--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 16, 2015 at 9:06 am

#1770788
RE: Tipping point for a numbers table vs inline tally

sqldriver (1/16/2015)
You guessed right on the seconds 🙂
"Lawyers" and their "billable hours"; we should all be so lucky.
Oh my word! That's bloody well insane. :hehe: Do they track...
--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 16, 2015 at 9:03 am

#1770786
RE: DATE cONVERT

TSQL Tryer (1/15/2015)
I have a date filed - an example of what it pulls back is -
2013-05-10 08:15:24.000
I want it to just return - 2013-05-10 00:00:00.000, so the time...
--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 16, 2015 at 8:48 am

#1770780
RE: The irk about the "Use 32-bit" option

Heh... Microsoft knows how boring IT jobs can be and they try to keep things exciting. 😛
--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 16, 2015 at 8:46 am

#1770777

Viewing 15 posts - 21,871 through 21,885 (of 59,098 total)