Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,831 through 37,845 (of 59,098 total)

RE: SSRS rendering limits?

jcrawf02 (7/2/2010)
humph. Well, that's just annoying. Thanks for the response Jeff.
Agh... sorry about the short response, Jon. I just get ticked off at all these wonder "magical" GUI's that...
--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)

July 2, 2010 at 3:11 pm

#1188436
RE: hi i need cursor program

rajendra prasad-377679 (7/2/2010)
the main task is.
scenario:
assume if a production company take material for a weekly basis..
this week they have a stock 800 ton rawmaterial.
for daily basis they going to use...
--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)

July 2, 2010 at 2:53 pm

#1188433
RE: hi i need cursor program

Ram:) (7/2/2010)
yes I agree with Mr.Gail.. You may not need cursor for this..
As per my understand.. simple triggers will work for you
Whoa! Hold the phone! Triggers? For...
--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)

July 2, 2010 at 2:42 pm

#1188432
RE: Split string using Tally Table

BWAA-HAA!!!! First, this is NOT a good example of Tally Table code. It doesn't use a Tally Table and it doesn't use anything that could be called efficient....
--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)

July 2, 2010 at 11:23 am

#1188372
RE: SSRS rendering limits?

jcrawf02 (7/2/2010)
I have a view for a mailing list, pulls roughly 236k rows of data, SELECT * from that view runs in about 30 seconds in SSMS, when I pull...
--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)

July 2, 2010 at 8:57 am

#1188266
RE: Flexible ETL package

John Mitchell-245523 (7/2/2010)
I would say so, yes, otherwise you will need to change your code every time your exclusion list changes.
John
Z'actly.
--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)

July 2, 2010 at 8:07 am

#1188224
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Wiztech Russ (7/1/2010)
These articles are very well written, even an accidental DBA like myself can understand the logic in what you are describing. The actual examples also make it far...
--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)

July 2, 2010 at 7:44 am

#1188213
RE: Importing flat files

Ok... I've been watching this one for a bit and I'm curious... so let me ask a couple of questions, please.
1. It's my understanding that if 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)

July 2, 2010 at 6:51 am

#1188164
RE: To split comma delimiterd string

RBarryYoung (5/4/2009)
Please see this article [/url]by some really smart guy who hangs out here.
Heh... I know it's been over a year and I'm sorry I missed this. Thanks for...
--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)

July 1, 2010 at 7:21 pm

#1187984
RE: To split comma delimiterd string

rafidheenm (12/22/2009)
Hi ezhil,
please check this article ..
This article has two types of split.
1. XML split
2. SQL Function (Basic SQL string split for SQL 2000 or later)
http://www.sqlservercentral.com/articles/XML/66932/
With regards,
Rafidheen.M
Just saw...
--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)

July 1, 2010 at 7:20 pm

#1187983
RE: How to handle Tempdb.dbo.##XXXXXXX

zeeaay (7/1/2010)
Under my Systems Databases>tempdb>temporary tables; I have there table with dbo. ##XXXXXX. when I run an application I get the following error
Microsoft SQL Server Cannot insert the value NULL...
--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)

July 1, 2010 at 6:41 pm

#1187978
RE: Error! Msg 103, Level 15, State 4, Line 1

Anamika (7/1/2010)
Many Thanks,
Ami
Um... no... not yet. Take a look at the data you have. See all those "\N" thingies??? That's not supposed to be a part of 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)

July 1, 2010 at 6:35 pm

#1187976
RE: SSIS - Writing Exceptions to Flat File

I'm pretty sure that it can't actually be done. I believe you're stuck with just deleting the empty file. As a side bar, though, I wouldn't delete 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)

July 1, 2010 at 6:26 pm

#1187974
RE: what are the roles and resposibilties on sql dba

And one more link... I consider it to be the best link on the subject yet and it also teaches an essential skill that all aspiring DBA's must absolutely master...
--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)

July 1, 2010 at 6:19 pm

#1187972
RE: How to handle Tempdb.dbo.##XXXXXXX

zeeaay (7/1/2010)
Under my Systems Databases>tempdb>temporary tables; I have there table with dbo. ##XXXXXX. when I run an application I get the following error
Microsoft SQL Server Cannot insert the value NULL...
--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)

July 1, 2010 at 6:16 pm

#1187971

Viewing 15 posts - 37,831 through 37,845 (of 59,098 total)