as long as you due your due diligence, and check to make sure you won't have any data conversion errors, you'd be ok;

here's a quick example: if you radaptation of...

remove the GO statements.

GO statments are not a SQL command, but instead something that SQL Server Management Studio uses to split batches.

also, i'd recommend bullet proofing your code like this...

your case statement was 99% there:

you got caught with syntax, minor tweak to get ove rthe "IS" error:

CASE --nothing goes here when formula is used in a WHEN a.exposure_amt

...

profiler/trace/extended events tell you what commands were executed, but not what data changed.

an audit can tell you that a value changed.

the best way to handle it is of course at...

i think you want a constraint like this:

this is what you want to prevent in the future: anything that is NOT numbers

select p.Pext,* from person_test2 p where p.Pext like...

ya'll missed the southern naming influece here....

oh i missed combination of NUMBERS.

rules are being deprecated, you should just create a check constriant.

I know you said you can't add constraints, but technically a rule is a kind...

tcronin 95651 (1/16/2015)

---

I have a 3rd party app and db where I can not add constraints or change the data type. They have a phone extension field defines as...

to use "be made with the logins security context", the user must be a user on the domain.

if the user was a SQL user, an anonymous connection is made, which...

it would be more efficient to refer to an image that exists on the internet.

the size of the email is reduced, and also the throughput to your email server.

I know...

to grant permissions to other users, your user also needs the db_securityadmin priviledge

scroll down to "Permissions" on this page, and it's got the gory details:

http://msdn.microsoft.com/en-us/library/ms188371.aspx

halifaxdal (1/16/2015)

---

no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this issue.

based on your table, only...

looks pretty straight forward to me:

select

AVG(RSCORE) AS ScoreAvg,

AVG(RAmount) As AmtAvg,

AVG(Rvisit) AS VistAvg,

SUM(TotalAmt) AS TotalAmount

...

halifaxdal (1/16/2015)

---

Hello, I have a script to be used to backup a specific table in a weekly basis, here is the approach what I take, if you have a better...

your cursor is not designed correctly.

it gets the first record, does nothing, gets the next record, processes it, and then hits the END.

the last statement before END must be the...