Viewing 15 posts - 136 through 150 (of 283 total)
The import data transformation was the second step in the base until I removed the first step. I put tracking emails into the base DTS and the step is executing.
Of...
March 5, 2008 at 9:55 am
We've had the problem where a package "suddenly" went weird on us in that it would work normally when executing each step one at a time but wouldn't work if...
March 4, 2008 at 11:50 pm
The system sp was just what I needed. Specifically:
exec sp_helprotect
@Name = 'TableName',
@UserName = 'RoleName',
@PermissionArea =...
January 7, 2008 at 1:55 pm
I thought I would test my own claim that no three-character sequence could pass IsNumeric and fail Convert. Sure enough, I found one (there could be more). The string '$+.'...
January 4, 2008 at 5:55 pm
The following ASCII values will return 1 from IsNumeric:
9 (tab), 10 (LF), 11 (VT), 12(FF), 13(CR),
36('$'), -- because IsNumeric also must recognize money
43('+'),
44(','), -- for example '123,456'
45('-'), 46('.')
and, of...
January 4, 2008 at 12:43 pm
I just thought of another reason for using triggers in validation. We use it here in some of our tables. We have a workflow value and it can be changed...
December 28, 2007 at 1:32 pm
There is a problem with the function and it is basically a problem with counting days. To illustrate, let's use something that is not a date. Say we have two...
December 28, 2007 at 1:06 pm
You steadfastly refuse to go into enough detail for us to determine if you can do what you want in a constraint or not. The one example you gave, "(((not([Package_Type]...
December 28, 2007 at 11:34 am
I'm not really sure what you're asking for. If you have a table where several columns must contain the same value, that's easy. Say you have a table where columns...
December 27, 2007 at 5:16 pm
The answer is, "create a unique index on those columns!" 😛
Well, so that will tell you if you have duplicates, but not which ones. Picky, picky.
How about:
select Convert( varchar, NumCol...
December 20, 2007 at 4:41 pm
Adding a "found in" column to the primary key of the master table wouldn't work -- key value 100 found in 1 and key value 100 found in 2 are...
December 5, 2007 at 4:48 pm
Prakash Heda (11/29/2007)
I normally put it while in developement, but then go ahead and remove it once product get stablized
In >25 years in this business, I've never seen a...
November 29, 2007 at 12:06 pm
tfifield (11/28/2007)
I use DRI whenever it makes sense to do so.
Actually, I would put it the other way 'round. Use DRI as a default. If a rational case can be...
November 28, 2007 at 11:22 am
You can't directly. But you can set it up indirectly:
select aaa
from (
select column1 as 'aaa' from table name
)
where aaa = something;
Of course, all you're really accomplishing here is creating the...
November 21, 2007 at 1:06 pm
aureolin (11/20/2007)
It is easily possible to create a system that has such stringent data entry requirements that it is nearly impossible to get real-world...
November 20, 2007 at 3:29 pm
Viewing 15 posts - 136 through 150 (of 283 total)