Viewing 15 posts - 526 through 540 (of 844 total)
Brandie Tarvin (3/15/2016)
aavi1011 (3/14/2016)
App team provided select statements and want output of select statement as report in xls or csv format to thier email ID
Is this a one off run...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 16, 2016 at 7:34 am
Phil Parkin (3/3/2016)
below86 (3/3/2016)
Jeff Moden (3/2/2016)
oneteabag (3/2/2016)
...but the challenge is every section is pretty much relying on the output from the previous section.
So why not use the single proc...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 3, 2016 at 9:46 am
Jeff Moden (3/2/2016)
oneteabag (3/2/2016)
...but the challenge is every section is pretty much relying on the output from the previous section.
So why not use the single proc with the 4,000...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 3, 2016 at 7:50 am
Today is the first day I haven't got one in a long time.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 24, 2016 at 8:23 am
Gary Varga (2/11/2016)
below86 (2/10/2016)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 11, 2016 at 7:04 am
Please feel free to enlightened me.:-) But from what I've seen so far, only a couple weeks now, you can check in code in VCS but it isn't in...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 10, 2016 at 3:14 pm
roger.plowman (2/5/2016)
below86 (2/5/2016)
No bug should be so bad it has to be fixed RIGHT NOW OR THE WORLD DIES!
I would like to live in your fantasy world. It sounds...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 5, 2016 at 7:54 am
No bug should be so bad it has to be fixed RIGHT NOW OR THE WORLD DIES!
I would like to live in your fantasy world. It sounds so perfect....
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 5, 2016 at 7:38 am
roger.plowman (2/1/2016)
"Instant fail.
You NEVER EVER EVER put a change into production without going through development/QA/approval/whatever.
NEVER.
Here is the reason I would NEVER EVER want to be on call for this type...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 1, 2016 at 12:25 pm
Phil Parkin (2/1/2016)
And if your development and release processes are strict enough, the version in SC will match...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 1, 2016 at 12:15 pm
You could use something like this to just find the max date of those columns, it won't get you the column name though. I found this on another site,...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 20, 2016 at 2:33 pm
Eirikur Eiriksson (1/20/2016)
below86 (1/20/2016)
CREATE TABLE #datetest
(
id varchar(8),
L1 date,
L2 date,
L3 date
);
INSERT INTO #datetest (id, L1, L2, L3)
VALUES...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 20, 2016 at 8:58 am
Just a simple way I would try and get this:
CREATE TABLE #datetest
(
id varchar(8),
L1 date,
L2 date,
L3 date
);
INSERT INTO #datetest (id, L1, L2, L3)
VALUES ('1005', '1-1-16', '1-17-16',...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 20, 2016 at 7:29 am
erics44 (1/6/2016)
jaime.simancas 27970 (1/6/2016)
erics44 (1/6/2016)
jaime.simancas 27970 (1/6/2016)
Skill is not defined by how you write a query, but by how you solve the right problem.
hmmmmmm, seems like a very profound...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 6, 2016 at 9:17 am
jaime.simancas 27970 (1/6/2016)
below86 (1/6/2016)
jaime.simancas 27970 (1/6/2016)
erics44 (1/6/2016)
below86 (1/6/2016)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 6, 2016 at 9:05 am
Viewing 15 posts - 526 through 540 (of 844 total)