Viewing 15 posts - 2,326 through 2,340 (of 15,381 total)
squvi.87 (9/14/2015)
Sean Lange (9/14/2015)
Your question has received a lot of views but no responses. That is because you didn't post a very clear question. Your sample data has two columns...
September 14, 2015 at 9:40 am
mar.ko (9/14/2015)
Thanks Sean, but whe I try to use a temp table, I get:"Msg 2772 - Cannot access temporary tables from within a function."
This is because you really shouldn't be...
September 14, 2015 at 9:35 am
mar.ko (9/14/2015)
I want to take this a step further and create a function that will return a...
September 14, 2015 at 8:44 am
mbrady5 (9/14/2015)
While I am able to find most of them, I am unable to...
September 14, 2015 at 8:31 am
_simon_ (9/14/2015)
My way of doing it now is like this:...
September 14, 2015 at 8:26 am
squvi.87 (9/14/2015)
Above is the sample data.
This is self referencing table. Mainstream column is based on the sub streams. If any of the sub stream fails then corresponding main stream...
September 14, 2015 at 7:26 am
Since you are using a temp table it is highly unlikely that another process is going to be able to access this table as it would be out of scope....
September 14, 2015 at 7:22 am
MikeS. (9/13/2015)
September 14, 2015 at 7:10 am
Kristen the forums here do have some drawbacks that not other forums have but I don't spend hours scrolling through posts on threads I am involved in to find my...
September 11, 2015 at 12:34 pm
Kristen-173977 (9/11/2015)
Sean Lange (9/11/2015)
You can click the "Active Threads" links
Thanks, that looks better.
Is there any means to
a) Click a link for the "first unread post" within the thread?
b) Any ICON...
September 11, 2015 at 9:31 am
John Mitchell-245523 (9/11/2015)
Is it as simple as this?
UPDATE dbo.TestSET Denominator = (
SELECT Numerator
FROM Test t2
WHERE t2.MeasureID = 'c001'
AND t2.GroupID = 'A'
)
WHERE MeasureID = 'C010'
AND GroupID = 'A'
John
Nice John. I actually...
September 11, 2015 at 9:12 am
Kristen-173977 (9/11/2015)
How do you follow the forum to read new posts in existing...
September 11, 2015 at 9:03 am
NineIron (9/11/2015)
MeasureID c001 is total discharges from our hospital. MeasureID c010 is Readmission rate. So, I need the Total Discharges in order to calculate the rate.
I am sure that makes...
September 11, 2015 at 8:56 am
mohelsheikh (9/11/2015)
when i execute the procedure i have no issue (this mean the procedure syntax is correct and using OPENROWSET is not wrong), but when i call...
September 11, 2015 at 8:50 am
Viewing 15 posts - 2,326 through 2,340 (of 15,381 total)