there was a recent article that demonstrated how to run all *.sql files in a given folder.

that means the scripts contain commands that already have to have the parameters to...

maybe join only on names,and filter for where the ENum <> Anum?

SELECT distinct T1.[last name],t1.[first name],ENum,t2.Anum,T2.lname ,t2.Fname,

FROM ECLINICIAN_Info T1

LEFT JOIN ACLINICIAN_Info T2

ON t1.[last name] = t2.lname

and t1.[first name]...

well if it doesn't exist, then you'd be adding a column of all null values right?

you can join the two tables together instead of an exists, but that finds things...

and here's a basic example for the command line:

sqlcmd -S . -d master -E -Q "exec sp_who"

sqlcmd or bcp are the two command line options.

bcp is designed for importing or exporting data, whereas sqlcmd can do both, but also execute commands;

i've used use sqlcmd to...

I've got a script i call missing and implied foreign keys that i built over the years.

it's basically a peel the onion kind of attack, which kind of assumes some...

because you said intellectual property, i'm thinking that your database is given to your clients, and a different DBA than yourself administers that database. if you control the db, you'd...

--whopps removing and moving to other post.

Laptop...Thumbdrive...Golf Cart...32bit...workaround...Free..."connections are only open for a second or two to retrieve a row or write a row"

a few of the keywords i'm picking up here directly telling towards the...

this is because you have a correlated subquery, mostly due to bad aliasing. it's not a bug, but a behavior that occurs when you don't code correctly. properly aliasing columns...

whoops i menat by hour and not description... changed above.

ORDER BY cte.StartDateTime,r.hour_number

if you were gettign help in another thread, you probably should have continued in that thread, instead of a new post.

looks like this would work to me:

ORDER BY cte.StartDateTime,r.hour_number

you must have an explicit ORDER BY in your query to guarantee the data appears in a specific order. you stated you have no order by, so that is the...

Rod at work (9/21/2015)

---

I hadn't thought of renaming the foreign key constraints. That's an interesting idea. However, even if I did rename the foreign key constraints they're definition would still...

you are correct, only the table would be renamed.

you can rename each of the constraints, separately, one at a time, if you wanted with sp_rename, which you had already identified.