Viewing 15 posts - 6,901 through 6,915 (of 7,616 total)
Btw, I suggest using the clear datepart name, not the obscure abbreviations -- it can help you/others later, and avoid having to use Books Online just to lookup the &#^)@...
January 23, 2013 at 10:52 am
That's trickier than it sounds, because of the way SQL Server updates the sysjob* tables, and because you don't want to have to hardcode job schedules into the code.
Instead of...
January 23, 2013 at 10:48 am
Don't know full details, but the usual outline for such queries is shown below.
SELECT
DATEADD(MONTH, DATEDIFF(MONTH, 0, tp.trc_startdate), 0) AS start_month,
SUM(tp.??) AS active_units
FROM...
January 23, 2013 at 10:36 am
I think what's arrogant is for a developer to assume that they have the professional skills of another a DA/DBA job when they've never done. Not sure why everyone...
January 23, 2013 at 8:26 am
Sean Lange (1/22/2013)
ScottPletcher (1/22/2013)
Sean Lange (1/22/2013)
GilaMonster (1/22/2013)
Sean Lange (1/22/2013)
ScottPletcher (1/22/2013)
DiverKas (1/22/2013)
2) Do NOT let your DBA's design the database.
3) Hire a...
January 22, 2013 at 4:44 pm
Sean Lange (1/22/2013)
GilaMonster (1/22/2013)
Sean Lange (1/22/2013)
ScottPletcher (1/22/2013)
DiverKas (1/22/2013)
2) Do NOT let your DBA's design the database.
3) Hire a Data Architect.
Just saying....
January 22, 2013 at 3:20 pm
DiverKas (1/22/2013)
2) Do NOT let your DBA's design the database.
3) Hire a Data Architect.
Just saying. The first 2 groups have...
January 22, 2013 at 11:15 am
You need to do something like that in the WHERE clause:
select
col1
,CAST(col2 AS datetime) as col2test
from #DateTest
where isdate(col2) = 1
January 21, 2013 at 3:46 pm
drew.allen (1/21/2013)
ScottPletcher (1/21/2013)
I guess...
January 21, 2013 at 3:43 pm
What you really need is someone that has experience doing it, period. This is not something that you can just "wing it".
If you have to do it with no...
January 21, 2013 at 3:13 pm
Huh? I don't see anywhere a "datetime" data type is specified, only varchar. I don't see why the code couldn't run fine as is.
I guess your actual...
January 21, 2013 at 2:46 pm
No, you should not have to; the db engine takes care of that itself.
From Books Online:
"
If the value inserted is larger than the current identity value for the table, SQL...
January 21, 2013 at 2:24 pm
INSERT INTO dbo.T1 ( ... )
SELECT t2.col1, t2.col2, ...
FROM dbo.T2 t2
LEFT OUTER JOIN dbo.T1 t1 ON
t1.Name = t2.Name
WHERE
t1.Name IS NULL --only include...
January 21, 2013 at 2:18 pm
The first is a datetime2 format, the second is a datetime format.
Try CASTing to datetime2 first, then CASTing that to datetime.
CAST(CAST(column_name AS datetime2) AS datetime)
January 17, 2013 at 1:19 pm
SELECT *
FROM <db_name>.sys.database_files
WHERE
type_desc <> 'LOG'
January 17, 2013 at 1:15 pm
Viewing 15 posts - 6,901 through 6,915 (of 7,616 total)