Viewing 15 posts - 7,771 through 7,785 (of 26,490 total)
Have you checked to see if there are any tasks running under the Windows Task Manager?
April 30, 2013 at 3:02 pm
RexHelios (4/30/2013)
Thanks, Lynn Pettis. I will refer to the article.- Rex
And I can't stress enough, be sure to read the discussion as well. There is much to learned from...
April 30, 2013 at 2:48 pm
In many cases we don't actually need the entire table structure to help splve a problem. Many times, only a subset of the columns are relevent to a problem...
April 30, 2013 at 2:37 pm
RexHelios (4/30/2013)
Thanks, but the "AdjustedTotal" should be a sum of previous "AdjustedTotal" and current total. Your solution is showing sum of Previous "Total" and current "Total".
I will try to...
April 30, 2013 at 1:25 pm
By the way, if you are converting MoYear to a datetime value, you really should store it in a datetime column, not back as a character string.
April 30, 2013 at 12:50 pm
Something like this?
DECLARE @BaseData TABLE (ID INT, Total INT)
INSERT @BaseData (ID, Total)
VALUES
(1, 215),
(2, 86),
(3, 43),
(4, 101),
(5, 92),
(6, 64),
(7, 117),
(8, 59),
(9,...
April 30, 2013 at 12:45 pm
GilaMonster (4/30/2013)
And there's a target on my back. Again.ffs, it's not as if there's some massive prize out for the 1st person who corrects me each week. :angry:
Are we talking...
April 30, 2013 at 12:33 pm
If you want a character version (or at least close) of the value shown as datetime, look at the last convert in the following:
declare @TestDate varchar(10) = '01/2013';
select
...
April 30, 2013 at 12:30 pm
If you run the following, you will see that the datetime value is implicitly converted to the character string you showed:
declare @TestDate varchar(10) = '01/2013';
select
@TestDate,
...
April 30, 2013 at 12:28 pm
latingntlman (4/30/2013)
update table
set MoYear = convert(datetime, stuff(MoYear,3,0,'/01'), 101)
When I select the table the values are displaying as Dec 1...
April 30, 2013 at 12:25 pm
Have a read here regarding the options, particularly for @body_format:
April 30, 2013 at 11:47 am
You really are doing too much. You can create a computed column using the convert part shown below, just replace the variable @TestDate with your column name :
declare @TestDate...
April 30, 2013 at 11:31 am
bgdjwoods (4/30/2013)
April 30, 2013 at 10:37 am
DBA12345 (4/29/2013)
Server|||| Cost
abcd ||||| 75
abcd ||||| 25
dtgr ||||| 65
dtgr ||||| 35
table should lok like below.
Server||||| Cost
abcd...
April 29, 2013 at 4:00 pm
Oh, and ANY changes (code, schema, database, etc.) should be tested first in a development and QA environment prior to going into production.
April 29, 2013 at 3:08 pm
Viewing 15 posts - 7,771 through 7,785 (of 26,490 total)