Viewing 15 posts - 2,356 through 2,370 (of 6,036 total)
When you run bcp on your local machine C:\ is your local drive.
When you run bcp on the server C:\ is a local drive on he server.
Compare:
"dir C:\" from command...
June 18, 2010 at 5:06 pm
This must be more clean:
SELECT *
FROM msdb.dbo.sysjobhistory HISTORY
INNER JOIN (SELECT job_id, MAX(run_duration) AS max_run_duration
...
June 17, 2010 at 6:45 pm
jcantlon (6/3/2010)
Thanks for the reply, Lowell.I tried your suggetion, but it just resulted in <br /> showing up in my email.
You need to start the string with <HTML> and end...
June 15, 2010 at 6:43 am
I believe you don't need that table at all.
What you need is a properly formatted query with GROUPING and ROLLUP.
If you look up BOL for these key words you'll find...
June 1, 2010 at 3:07 pm
OK, I opened BOL for CREATE TRIGGER.
Syntax
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ {FOR | AFTER | INSTEAD OF } { [...
May 22, 2010 at 10:07 pm
Try to replace DocketNumber in UPDATE() with another column name, not mentioned in the trigger at all.
The error is so odd you must be looking at the wrong place.
Can you...
May 22, 2010 at 6:02 am
Check your error message.
Which line this error happens in?
Is it the same line as the one where UPDATE() is located?
May 21, 2010 at 8:04 pm
And it should be all in one SELECT statement:
select CASE WHEN att1 = 1 THEN CONVERT(varchar(50), dateadd (mm, 3, @sd ), 101)
...
May 19, 2010 at 3:25 pm
What did you try to say?
I don't see any point in this script and SELECT statement does not have any criteria and @FromDate populated by cursor is not used anywhere.
May 11, 2010 at 12:49 am
Then you need to make sure users ALWAYS enter area codes, and prefix it with zeros.
Otherwise some local numbers like "952-1154" will be truncated without warning.
Apart from another failure point...
May 11, 2010 at 12:42 am
Be careful with this approach.
It would fail for strings with spaces on the right.
Try the same example with '90529702610 ' and see it for yourself.
Use this instead:
SUBSTRING (Phone, 2,...
May 10, 2010 at 7:03 am
How desired result should look like?
May 7, 2010 at 3:44 am
SELECT Department, DATEADD(dd, DATEDIFF(dd, 0, TDate ), 0) DayStart, COUNT(EmpID) [Daily]
FROM tblNGESDData
GROUP BY Department, DATEADD(dd, DATEDIFF(dd, 0, TDate ), 0)
--Weekly
SELECT Department, DATEADD(wk, DATEDIFF(wk, 0, TDate ), 0) WeekStart, COUNT(EmpID)...
May 6, 2010 at 3:05 am
Viewing 15 posts - 2,356 through 2,370 (of 6,036 total)