Viewing 15 posts - 14,251 through 14,265 (of 26,486 total)
Select COUNT(SerialNumber),
CASE WHEN DATEPART(hour,(DateTested)) between 7 AND 16 THEN '1st SHIFT'
WHEN DATEPART(hour,(DateTested)) between 16 AND 1 THEN '2nd SHIFT'
WHEN DATEPART(hour,(DateTested)) between 1 AND 7 THEN '3rd SHIFT'
END
FROM TestHeader WHERE...
October 17, 2011 at 10:21 am
Also, do you have a separate task accessing each table? I would think that each specific table has the same layout so that issue is simply changing the source...
October 16, 2011 at 11:43 am
battery_acid_h (10/14/2011)
The dynamics NAV databases can have several companies in a...
October 16, 2011 at 11:41 am
Can you give us the actual error message(s) you are getting?
October 16, 2011 at 11:22 am
Is there a single company table with all the company names? Can you provide us with the ddl for the critical columns for this table and some sapmle data...
October 14, 2011 at 8:36 pm
Junglee_George (10/13/2011)
Which one of the following is preferred considering the performance of the SQL query executed..??
Method 1
--------
UPDATE Table1 SET Col1 = ( Select Count(Id)...
October 14, 2011 at 4:10 pm
If you are getting errors, it would help to know the errors for one.
October 14, 2011 at 12:11 pm
Not that I'd recommend it, since SQL Mail goes away when you migrate to SQL Server 2005+, but I actually toyed with using SQL Mail to query a database and...
October 14, 2011 at 12:09 pm
declare @retval int;
exec @retval = dbo.my_storedproc;
if @retval = 0
print 'execution successful';
else
print 'execution failed';
Look up EXECUTE statement in Books Online.
October 13, 2011 at 3:49 pm
xgcmcbain (10/13/2011)
But if i know, nulls will not get in because i only have access.
How do you know nulls will never get in? Will you always be the only...
October 13, 2011 at 2:23 pm
tnk (10/13/2011)
In my experience it's best never to present so-called, "decision makers" with anything but the right decision(s)!
And IMNSHO, the right decision would actually be to move the current transaction...
October 13, 2011 at 2:11 pm
Defaults and not null should be declared in the schema itself.
October 13, 2011 at 2:03 pm
xgcmcbain (10/13/2011)
it will null, cause your implicity saying null, if i omit the column the default will fire
I think you are missing the point. If the column cannot be...
October 13, 2011 at 1:50 pm
xgcmcbain (10/13/2011)
what im doing is giving it a default so it seams checking not null is ambiguousno outside application has access but myself
You say that now. This could change....
October 13, 2011 at 1:42 pm
If you don't need the t-logs why are you running using the full recovery model? If you aren't taking transaction log backups, the t-log will continue to grow until...
October 13, 2011 at 1:26 pm
Viewing 15 posts - 14,251 through 14,265 (of 26,486 total)