limiting access to an existing workbook would simply be permissions on a file share, right?

I don't think you need powershell for that, just assign the right permissions to a folder...

you posted in SQL2008 forum, so my questions are for that platform. i think you might be posting a MySQL question in a SQL Server centric forum though.

Since SQL Server...

did you already grab the General Equivilency Mapping stuff?

https://www.cms.gov/medicare/coding/icd10/2015-icd-10-cm-and-gems.html

your example is a great one how codes don't have exact equivelents

in the file for ICD9 to OCD10, 250.00 maps to E11.9,...

GonnaCatchIT (4/15/2016)

---

Thanks for the inputs.

I tried increasing the timeout to a 1 hour , but still get the same issue.

If the Query plans are being generated differently on 2 environments....

we can't help you with homework, but if you have specific questions you can't seem to get right, if you show us what you've done,we can offer suggestions.

If i...

the If does not shortcut the validation for objects and columns. all objects must exist before the statement executes. you see the smae behavior if you have an ADD column...

i think it's related to permissions; a lot of the time someone might get a permissions error that says

"User does not have required permissions. Verify that sufficient permissions have...

is there a specific error? what if you try https?

old thread from six years ago...

the msdb object mentioned msdb.dbo.restorehistory is not a system object; adding a trigger to...

since this is on a cluster, pretty sure you cannot use local disks to each box, regardless of whether they are SSD's or not ; only drives that are shared...

is it accessing metadata, like sys.tables and stuff,so you KNOW the object sit access exist in ALL databases, or is it assuming that specific tables exist int he database you...

the public role has access to tempdb, so you could create a semi-permanent table that would exist until the sql service was stopped and started/server rebooted, by creating...

not sure if this is what you are after, this was my first guess

/*--Results

ClosestUnder ClosestOver

20 25

*/

;WITH MyCTE([Code],[Number],[Value])

AS

(

SELECT '5',convert(float,'10.00'),convert(money,'1.9201') UNION ALL

SELECT...

did you try the query at all?

i just made a minor change and tested, i got this error because the directory structure is not there yet, could that be it?

Msg 50000, Level 16, State 1, Procedure...