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...
_____________
Code for TallyGenerator
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
...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
June 1, 2010 at 3:07 pm
May 26, 2010 at 3:06 am
OK, I opened BOL for CREATE TRIGGER.
Syntax
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ {FOR | AFTER | INSTEAD OF } { [...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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?
_____________
Code for TallyGenerator
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)
...
_____________
Code for TallyGenerator
May 19, 2010 at 3:25 pm
Where do you assign any value to @sd?
_____________
Code for TallyGenerator
May 19, 2010 at 3:16 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.
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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,...
_____________
Code for TallyGenerator
May 10, 2010 at 7:03 am
How desired result should look like?
_____________
Code for TallyGenerator
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)...
_____________
Code for TallyGenerator
May 6, 2010 at 3:05 am
Viewing 15 posts - 2,356 through 2,370 (of 6,036 total)