Viewing 15 posts - 106 through 120 (of 205 total)
OK, I have to ask, why do you choose not to use an identity column? That is the simplest solution to this situation, really.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 21, 2010 at 6:52 am
If you put a unique index on that column, or make it a Primary Key column, you won't be allowed to have duplicates in there and will no longer have...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 20, 2010 at 11:52 am
OK, thanks.
This does work:
case
When IsNumeric(Diag2) = 1 Then '3'
When Left(Diag2,1) = 'V' Then '4'
When Left(Diag2,1) = 'E' Then '5'
Else ''
End As CodeType2,
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 18, 2010 at 6:55 am
cvandevoorde (10/11/2010)
Stamey (10/11/2010)
Setting up error handling is is a good practice also, if you want the package to be able to continue running after it encounters an error, such...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 13, 2010 at 11:36 am
RonKyle (10/12/2010)
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 13, 2010 at 11:30 am
First, if you have exclusive control of these fields in Access, you can just change the Access data type to a more suitable length (what has been allocated in SQL...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 11, 2010 at 10:28 am
I will play with some of the options, but I have already read this page a few times.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 22, 2010 at 5:23 am
No, no explicit transactions.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 17, 2010 at 7:02 am
That works nice. I guess I needed to specify Output when I call the proc. That works better.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 16, 2010 at 11:37 am
Now I'm gonna try that other example, by Eralper, as the pivot has an Achilles heel, it spits back a syntax error if any of the ClaimCode values are null,...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 23, 2010 at 11:14 am
OK, finally got to run it. works like a champ. THANKS!
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 23, 2010 at 6:21 am
Yeah, did the Max. Now I have found data problems. In order to not return a few millions records I chose a random ID that I had verified had the...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 22, 2010 at 7:29 am
I'm getting close. Turns out the data type for the ClaimCode is VarChar, so the Avg operator will not work. Trying to find a better alternative there.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 22, 2010 at 6:43 am
That looks like a winner, if I can reconfigure it to my needs. In this case I have over 19 million distinct values in the table that would be #T2...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 21, 2010 at 1:58 pm
I have found this quite effective for kicking out users.
ALTER DATABASE [DATABASE NAME]
SET OFFLINE WITH ROLLBACK IMMEDIATE
Go
ALTER DATABASE [DATABASE NAME]
SET ONLINE WITH ROLLBACK IMMEDIATE
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 6, 2010 at 6:44 am
Viewing 15 posts - 106 through 120 (of 205 total)