That would work. But it will be easier to work with one column. I guess I will go with 2 columns if I couldn't figure out anything else.

You can use the bcp utility from command line.

bcp "SELECT fname, lname, address, city, state, zip FROM mydb..users order by state, city" queryout Users.txt -c -Smysqlserver -Umyusername -Pmypassword

Books online has...

Thanks guys.

>> the whole concept of returning 5 random rows from a set is strange to me.

We have a "What's New" section on our website. We usually have like 10-15...

Chris, Thanks for the reply. It works great, just what I needed.

Can you tell me how it works? I read that NEWID will return an unique identifier. But to use...

But this search page is for admin, not for public users. They might want to view all the users or export all the users into a csv list for some...

The search results are presented in a grid. User can click on 'select all' or 'select none'. I am not sure there is another way of designing the UI. It...

The 25000 entries come from a webpage. I have a search clients page, where users can search for and select the clients. And there are mroe than 25000 users in...

Actually I tried sending the list as a text variable parameter, a comma seperated text and convert each userid back to int. I have a table variable inside the stored...

Here are the results for the three queries.

clientid, messagecount

12001

12012

12020

12063

12331

clientid, ordercount

12000

12018

12020

12061

12330

clientid, messagecount, ordercount

120010

12011616

120200

120633

123310

And this is what I should get

clientid, messagecount, ordercount

120010

120128

120200

120631

123310

Thanks.

Hi,

I changed the owner of the temp table and it works fine. Thanks.

Hi,

I tried to change it to TRUNCATE TABLE, but it says user does not have permission to perform this operation on table 'temptable'. I checked all the permission check boxes...

Thanks for your reply.

Hi,

For "set @table = fn_splitstring(@strings)", the error message was @table was not declared.

For "select * into @table from fn_splitstring(@strings)", the error message was incorrect syntax near @table.

Actually "insert into...

Thanks all for your reply. It was helpful.