Viewing 15 posts - 736 through 750 (of 844 total)
This looks to be a double posted question.
Here is what I replied to the other post. Why would you need 2 when statements? Never mind I see why, didn't...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 5, 2014 at 7:34 am
See if this does what you want.
declare @startdate datetime;
declare @trandate datetime;
set @trandate = '02/05/2012';
set @startdate = (select casewhen @trandate between '06/04/' + cast(year(@trandate) - 1 as char(4)) and '05/04/' +...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 5, 2014 at 7:20 am
How about a way to log the results from stored procedures? Seems like a simply request. As the user community says to us all the time 'How hard...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 31, 2014 at 7:53 am
Misha_SQL (1/22/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 22, 2014 at 1:05 pm
Well said Craig. This is the point I was trying to make. I need to hone/work at trying to be better at expressing my thoughts into words. ...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 15, 2014 at 12:43 pm
Steve Jones - SSC Editor (1/15/2014)
below86 (1/15/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 15, 2014 at 10:51 am
Grant Fritchey (1/15/2014)
For all those who think that you shouldn't...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 15, 2014 at 10:45 am
Steve Jones - SSC Editor (1/15/2014)
below86 (1/15/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 15, 2014 at 10:16 am
Steve Jones - SSC Editor (1/15/2014)
below86 (1/15/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 15, 2014 at 9:40 am
Thomas Abraham (1/15/2014)
Making tradeoffs in time versus quality in just the right places, that's what a craftsperson does.
Well said Thomas.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 15, 2014 at 8:24 am
You get pulled into so many different projects with so little time it impossible to 'craft' the perfect solution. As they say 'A jack of many trades, master of...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 15, 2014 at 7:41 am
Steve Jones - SSC Editor (1/13/2014)
Or ask for more monitors to surround yourself and prevent distractions :w00t:
It seemed to take forever to just get two, I think the chances of...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 13, 2014 at 8:49 am
Almost ever query we write will span more than one database, so that's why I prefer it.:-)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 13, 2014 at 8:30 am
liteswitch (1/13/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 13, 2014 at 8:21 am
Jeff Moden (1/12/2014)
GilaMonster (1/12/2014)
Use three-part naming for your queriesSELECT <column list> FROM Sims.dbo.Students
SELECT <column list> FROM SimsCopy.dbo.Students
I agree that works great for ad hoc queries (and you already know this......
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 13, 2014 at 7:34 am
Viewing 15 posts - 736 through 750 (of 844 total)