i think since the data is comma delimtied string, you can be sneaky and use LEN / LEN(REPLACE

/*

Att q x ...

here's a DML delete trigger example that is catching a ton of whodunnit information and sending an email;

maybe you can use that as a model?

CREATE TABLE WHATEVER(

WHATEVERID INT IDENTITY(1,1)...

i've edited my working oracle linked server connection with your info, so it seems to match how i've got mine set up:

--#################################################################################################

--Linked server Syntax for Oracle 10G

--#################################################################################################

DECLARE...

rayh 98086 (4/11/2013)

---

Thank you both!

When I check the file, copying into Notepad, I do not see any extra characters. To be safe, I even created created a test by...

usually when i get that error, it's because the files are coming from a UNIX file type, where the rows end in \r instead of \n

usually this fix,...

you have to script the table out , whether via SSMS, powershell, or custom TSQL.

select into newtable only copies an identity definition(if it exists) and column datatype/size/length/nullability.

it does not...

i'd have to see an example of what would actually be prohibited where you said

"Trick questions in a interview are strictly forbidden in working environments governed by EOE"

that doesn't...

the system function sys.dm_exec_sql_text(a.sql_handle) is for SQL2008 and above only.

SQL2005 will throw an error on syntax, because it's not valid. no cross applying functions back then but the...

excellent point, something like this would be five rows in a text editor, but one...

Duran i guess you'd have to show us an example or two from the results of the query, instead of the query itself.

for example, maybe the recommendation is an...

i just found this for powershell:

http://stackoverflow.com/questions/3891952/sql-server-script-data-smo-scripter-not-working-when-output-to-file

for doing it via TSQL, i've used a script by Narayana Vyas Kondreddi for years and years:

http://vyaskn.tripod.com/code.htm#inserts

there's a few parameters that need to be...

here's what i have saved that looks like a stepping point to getting the string converted; it does not produce the final result, but something not quite finished:

--change it back:

;with...

whoops sorry;

here's an example of converting that int value into a binary map;

while i have an example of converting an into to varchar as a binary mapping, my example...

saved in my snippets:

declare @ipAddress varchar(20)

SET @ipAddress='010.000.123.094'

SELECT

CONVERT(varchar(3),convert(int,parsename(@ipAddress,4))) + '.' +

CONVERT(varchar(3),convert(int,parsename(@ipAddress,3))) + '.' +

CONVERT(varchar(3),convert(int,parsename(@ipAddress,2))) + '.' +

CONVERT(varchar(3),convert(int,parsename(@ipAddress,1)))

SELECT

convert(int,parsename(@ipAddress,4)) * 256 * 256 * 256 +

convert(int,parsename(@ipAddress,3)) * 256 * 256...

do you really need #1 all active directory uses, or #2 only the ones in a certain group?

there's an extended stored proc that makes #2 easy:

--you need to KNOW the...