Viewing 15 posts - 61 through 75 (of 93 total)
opc.three (6/24/2011)
Yikes! Will multiple people will have the ability to call said proc, possibly creating a situation where it is called concurrently?
Our system is set up so that each project...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 24, 2011 at 1:00 pm
CELKO (6/22/2011)
Why do you want to do this in SQL? It was never meant for writing parsers. And you got some data element names wrong.
I don't get a choice...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 23, 2011 at 7:52 am
Craig Farrell (6/20/2011)
Why not just:UPDATE Working_PIS SET AccountBalance = ( AccountBalance * CONVERT( Money, PositiveNegativeSwitch + '1'))
UPDATE Working_TRN SET Monarch_TRNAmount = ( Monarch_TRNAmount * CONVERT( Money, PositiveNegativeSwitch + '1'))
First,...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 20, 2011 at 4:15 pm
Yeah, this is one that is more of a curiosity since I haven't used the tally table logic before. I was able to get my data to work with:
Update dbo.Working_PIS
Set...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 20, 2011 at 3:56 pm
latinmusic74 (6/9/2011)
How SQL developer got the experience from to became SQL developer?
An idea that I've had some luck with back in the day (and will be kicking off again on...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 16, 2011 at 3:14 pm
Outstanding!!! Thank you for the review. 😀
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 16, 2011 at 11:43 am
Mike,
That was an amazingly complete article. Thank you!
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 13, 2011 at 2:19 pm
GilaMonster (6/13/2011)
It obfuscates the storage of the definition in the system tables
I'm not sure I follow you completely. Are you saying that other users would not be able to see...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 13, 2011 at 10:23 am
Sorry, I forgot to include example data:
Insert Into dbo.ProjectTracking_Temp
(AssignDate,
CompleteDate,
DueDate,
EstRecovery,
ETA,
ResourceType,
ServiceType,
MedNum,
HospitalSystem,
HospitalName,
DatabaseName,
FiscalYears,
ProjectNotes,
CompleteFlag,
PriorityOrder)
Select '06/02/11',
'',
'',
'10,590.00',
...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 9, 2011 at 2:19 pm
I'll need to explore that Merge command myself, but I have a stored procedure already set up for a process just like this. This is my live code, and it...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 9, 2011 at 1:24 pm
Thank you, that was exactly what I was looking for.
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 9, 2011 at 8:20 am
This has been an interesting conversation so far, and it has clued me in somewhat to where I'm rated at. I am curious how close I've gotten it, and would...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 9, 2011 at 7:38 am
I'm sure the experts have a faster way to do it, but this is what I came up with:
If Object_ID('dbo.StringTest') Is Not Null
Drop Table dbo.StringTest
Go
--------------------
Select 'Microsoft Windows Server...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 6, 2011 at 4:22 pm
I have tried playing with Begin Transaction / Commit Transaction / Rollback Transaction logic, but I've never been able to get the syntax down correctly. Other than MSDN is there...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 3, 2011 at 4:34 pm
Thanks for the code David. I used to work in VB 6, but I've been out of it for a number of years. I've got several books going right now:...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
June 3, 2011 at 4:25 pm
Viewing 15 posts - 61 through 75 (of 93 total)