Viewing 15 posts - 61 through 75 (of 92 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...
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...
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,...
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...
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...
June 16, 2011 at 3:14 pm
Mike,
That was an amazingly complete article. Thank you!
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...
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',
...
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...
June 9, 2011 at 1:24 pm
Thank you, that was exactly what I was looking for.
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...
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...
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...
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:...
June 3, 2011 at 4:25 pm
Viewing 15 posts - 61 through 75 (of 92 total)