Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,341 through 23,355 (of 59,102 total)

RE: Are the posted questions getting worse?

SQLRNNR (6/27/2014)
Evil Kraig F (6/27/2014)
SQLRNNR (6/27/2014)
Evil Kraig F (6/27/2014)
Eirikur Eiriksson (6/27/2014)
The Dixie Flatline (6/27/2014)
Grant Fritchey (6/27/2014)
Koen Verbeeck (6/27/2014)
Grant Fritchey (6/27/2014)
Anyone think they can help this person? I think they really...
--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)

June 28, 2014 at 12:31 pm

#1725680
RE: no. of columns in excel may vary

ykonline (6/27/2014)
No, Columns positions will be same but we may receive new columns that
may not be exists in previous sheet which we received.
For Example,
First time, we receive the Sheet...
--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)

June 28, 2014 at 12:20 pm

#1725677
RE: Need help with query

My apologies. I'll blame it on a lack of caffeine. I overlooked the fact that you have a start and an end date.
I had a really good link...
--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)

June 28, 2014 at 12:01 pm

#1725675
RE: Group Islands of Contiguous Dates (SQL Spackle)

dwain.c (10/6/2013)
I skimmed the article but I couldn't really identify what's new in this re-publish.
I don't suppose you could give us a quick synopsis Jeff?
Apologies for the VERY late reply,...
--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)

June 28, 2014 at 10:49 am

#1725669
RE: Not even sure if this is possible???

I feel your pain and your boss' pain. Dealing with 3rd party application vendors is a huge pain especially when it seems that they break more stuff than they...
--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)

June 28, 2014 at 10:27 am

#1725668
RE: Not even sure if this is possible???

If you make the column in the table NOT NULL and make the field in the app a required field, I think that would be a much better solution than...
--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)

June 27, 2014 at 10:26 pm

#1725629
RE: Need help with query

arijit rath (6/27/2014)
Hi All
I have a data set as given below :
CodeStartDate EndDate ...
--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)

June 27, 2014 at 10:18 pm

#1725628
RE: Want to get records only from particular set of numbers.

SELECT KNO
FROM dbo.Consumer
WHERE KNO IN ('8789','8896','6963')
GROUP BY KNO
HAVING SUM(Amount) = 0
;
--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)

June 27, 2014 at 11:40 am

#1725544
RE: Powershell

dishantbmg (6/26/2014)
Actually i wrote a powershell program which is taking an input file containing some scripts, i want to capture message window of SSMS into a log file. How can...
--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)

June 26, 2014 at 8:35 pm

#1725323
RE: dynamic database connection of bulk insert task in foreach loop

I don't even know how to spell "SSIS" but perhaps my admission of that will serve as another "bump" for your post. I'd wouldn't mind learning how such 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)

June 26, 2014 at 8:15 pm

#1725322
RE: Write into a table a user-entered value and increment that number n times as existing rows

reliableitservice (6/25/2014)
I want to thank you for your help!!
I already apply this to the LIVE environment and is working like a charm!!!!!
THANK YOU SO MUCH!!!!
RITS
How are you preventing duplicate invoice...
--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)

June 26, 2014 at 7:00 pm

#1725314
RE: Remove cursor

suneel kamavaram (6/26/2014)
Create a function to execute sql query and then cross apply with TABLE1 which is the output of the result from the query modified by Bob.
create function dbo.fn_execsqlquery
...
--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)

June 26, 2014 at 5:30 pm

#1725306
RE: Byte Me: Insubordinate Clause

I think it would be much more fun to partition an IDIOT. 😛
--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)

June 26, 2014 at 9:32 am

#1725162
RE: Thrown into SQL position

Factory909 (6/26/2014)
I am not against differentials and implementing it into our dr plan. I am prepared to restore that many files, at least until I can find or build 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)

June 26, 2014 at 9:31 am

#1725161
RE: Thrown into SQL position

I would backup the T_Logs to separate files just for the sake of seeing when the most activity occurs each day (it's helpful to know down the road). It...
--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)

June 26, 2014 at 7:54 am

#1725083

Viewing 15 posts - 23,341 through 23,355 (of 59,102 total)