Viewing 15 posts - 6,046 through 6,060 (of 7,168 total)
ash0550 (6/16/2011)
Ninja's_RGR'us (6/16/2011)
ash0550 (6/16/2011)
case when BillOfMaterialsID <= 100 then 'Cheap'
When BillofMaterialsID between 101 and 500 then 'Medium'
When BillofMaterialsID between 501 and 1000 then 'HIGH'
When BillofMaterialsID between...
June 16, 2011 at 3:52 pm
How about some DDL, DML and some expected results? The article has examples of the items I'm asking for.
June 16, 2011 at 3:38 pm
ash0550 (6/16/2011)
Nope it is not workingAnyways thanks
It may not be "working" because only you can see your screen. Please provide sample DDL and DML as well as your expected results...
June 16, 2011 at 3:34 pm
Michael Valentine Jones (6/16/2011)
opc.three (6/16/2011)
...
That said, Michael's script has "DATE_ID = Days since 1753-01-01". I am not modeling anything more than 111 years old...was it done this way in the...
June 16, 2011 at 3:30 pm
You're welcome, thanks for posting back 🙂
June 16, 2011 at 3:05 pm
Under Collection what do you have for the "Retrieve file name" setting?
> Fully qualified (you want to select this one)
> Name only
> Name and extension
June 16, 2011 at 2:59 pm
No sweat...besides I don't think that's the root issue, I just wanted to confirm the mask was working, which it sounds like it is. SSIS can handle files with spaces...
June 16, 2011 at 2:12 pm
Jeff Moden (6/14/2011)
opc.three (6/14/2011)
DayInstanceInMonth - tinyint - values 1-5 representing the n-th time this day has occurred in the month
Most people don't think of such a thing. I was...
June 16, 2011 at 2:01 pm
gcresse (6/13/2011)
June 16, 2011 at 1:36 pm
No.
How's that for short, sweet and accurate? 😉
June 16, 2011 at 1:30 pm
GilaMonster (6/16/2011)
...Not what I was thinking about at all. For savepoints, the name of the transaction is still meaningless, the name of the savepoint is what's important.
Agreed. There is an...
June 16, 2011 at 12:30 pm
billj-705548 (6/16/2011)
June 16, 2011 at 12:06 pm
This thread should be moved into the Relational Theory forum 🙂
Try thinking of an array as a column turned on its side and go from there.
June 16, 2011 at 11:51 am
While your manager is outside the box ask him/her to consider what will happen when two people need to modify "The Proc"...one to change how Lady GaGa does her work...
June 16, 2011 at 11:44 am
Not trying to step in front of Gail...my shadow would maybe cover her pinky toe but the thread looked idle...
SAVE TRANSACTION is when naming a transaction becomes relevant.
June 16, 2011 at 11:36 am
Viewing 15 posts - 6,046 through 6,060 (of 7,168 total)