it depends on whether the data is stored as varchars or proper datetime/time data types.

the datetime datatype allsowds you to add to it.

if the columns are datetime, the CTE is...

ok, so are you rounding up to the nearest power of 10, then?

like this?

SELECT Power(CONVERT(BIGINT, 10), N) AS MaxVal

FROM (SELECT TOP 18 row_number()

...

The group by is fine if you KNOW...

specific error is probably helpful; i suspect it's the column name is misspelled due to copy paste?

or is it because the table busidentity is not in the join criteria on...

there's a pair of functions that you can use to get either the things the views reference, or the things that the view consumes.

--objects that USE the views

SELECT

schema_name(vwz.schema_id) As...

that's a tough one, since the bat could be doing anything, and it's outside of SQL server.

you could open up Task Manager on the server, but the real question is...

i have specific jobs that are identical on all servers, things like backups, statistics, indexing.

i connect via Central Management servers, and run the create job script on all of them...

not quite sure what...

a really nice feature is you an update on a cte affects the base table, so if you generate an identifier for dupes, you update everything that is a dupe.

WITH...

so your applicaiton has sysadmin rights, and whenever it creates a login, it makes it sysadmin, and then adds a user i guess.

if you kill it in a trigger, you'll...

SqlBarbarian (5/6/2016)

---

thanks! Exactly what I'm wonder. With SQL Sentry Plan explorer they anonymize to "column1", but all the column references in plan are consistent. So I was thinking something would...

remember there is a difference between a LOGIN and a USER.

nothing gets any rights unless you add them to a group or role that gives them permissions.

so, never add a...

obfuscate object names? that might make things difficult to get help with, because someone might suggest a change to the schema of a table, you have the mapping issue; but...

ok, here's how i would tackle it;

assuming your analysis on the two chars is correct, this produces both "versions"

of the data;

now i would simply test for high ascii, and take...

SQLRO (5/6/2016)

---

If I try to remove leading zero from 0x0231 with

STUFF(column_name,1,1,'') then it removes 02 as that is the first character in binary and makes the binary pattern as 0x31...