or you can give the Loser more permissions , which IE version are you using?

you use the [SQL Server Business Intelligence Development Studio]

which ever is better, you can also consider using a user defined function

i would first convert the file to xml using a frontend app, then use the xml capabilities of sql to extract data from the file. can you post an example...

yes you can use dynamic sql, storing your string in a column as you have said. you would need to use the replace function. this is assuming that you have pretty...

on the last screen, i will check for you when i get into the office

steve,

no offense meant to the original poster but if only we could all be elaborate in specifying the problem like you have done.

Mark,

I did not mean to offend you by my question.

Anyway I tested your question on a standard edition and managed to get the option to save to different file,...

Duane,

I understood your problem but you did not rely my question about whether its a random sample that you want or a straight top 1% as shown above by Steve

Can you tell me is there any way to use memory to store insertions and later on writing to database? What is the best strategy we have to follow

if...

by the way is it a random 1% sample you are after or top 1%?

can you post your script?

great but i would suggest that you use a column in your Order_Master table that contains a count of lines for your order which you should incorporate in your

are you using sql server express, if that is the case then that is why you are not getting the options

or using your code above,

SELECT

@orderid = NULL

SELECT

@orderid = MIN(