i'm guessing here, but i'm thinking that using a FOR XML to concatenate the itwm field into a comma delimited list might be what you are after;

here's a basic example...

is the login the user is connected to a member of the sysadmins?

is "User1" really a domain account like myDomain\User1 that might be inheriting BuiltIn\Administrators,?

not sure what you mean by elimination, nor what data you wanted at the end;

to me it looks like you have to join the table agaisnt itself...

is this right?

/*

--Results

organization account...

mohammed moinudheen (10/4/2011)

---

There could be problem with your SMTP server. You might need to check with your network team regarding this to verify if ports are open etc. for the...

for me, cursors are ok in certain situations...when dealing with metadata items like you are.

my rule of thumb is: if it's in one database, no cursors allowed.

so the corallary...

it's pretty well documented that SQL will keep data for a TEXT datatype in a varchar(8000) as long as it's less than 8000 chars, otherwise it's stored a different way,and...

your sample data didn't show the "or" part of your query...all the data would be returned regardless, because the4y are all between your start and end dates.

i changed the sample...

paul take a look at this thread from a while ago

http://www.sqlservercentral.com/Forums/Topic1115027-359-1.aspx

in that thread, I slapped together an example of a proc that executed as dbo,and did the following:

created(or found) a...

does this return the expected data?

SELECT

id,

SUBSTRING(CONVERT(VARCHAR(max), Data),

CHARINDEX('<t2>', CONVERT(VARCHAR(max), Data)) + 4,

( CHARINDEX('</t2>', CONVERT(VARCHAR(max), Data)) -...

books online 's first logon trigger example is limiting a login from more than three connections:

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

make sure you NEVER CLOSE the window you use to create your login trigger during...

laddu4700 (10/3/2011)

---

Hi,

I need to export 9 sql server tables data to pipe delimited text file.

I tried to use import/export wizard, but I can't export more than one table at a...

patla4u (10/3/2011)

---

Hello All,

I want to know that...if user can insert,update and delete some records and i want to track all information(means user name ,time,which database) then how can i do...

PRINT @teste just before the attempt to bcp. it's probably a single INSERT command, right, and not a whole stack of inserts, because you are not putting your results together...

well to do it exclusively via xp_cmdshell, you've got to have the right command, and it's got limitations.

the maximum length of the string that you can use at the command...

where is the...