Use the + symbol to concatenate fields together.

caution you need to explicitly cast all your columns to a varchar datatype if they are not already a char.

create table mytable(pk int...

I think this is what ur looking for.

In enterprise manager, Right click on the database -- > All Tasks --> Generate sql script.

in the options tab select the checkbox script...

Sorry,

Stored procedures do not work that way.

your pseudo code is not very clear. can you elaborate on your problem

Thanks.

Well, if its done from an application, then it will be better to return a recordset from the stored procedure to the application, then have the application write it out...

Are you trying to do this from an application for regular use?

or are you just doing this to get out some data?

Your best bet is BCP.

You can also save the...

Welcome.

Hey, I'm not sure what your having trouble with.

But replication/taking a snapshot does not take the primary(publication) database offline.

There is no way to start sql server replication without a snapshot....

If your not going blind, then your not doing it right.

have you looked at datepart()?

select datepart(hh,getdate())

DATEPART

Returns an integer representing the specified datepart of the specified date.

Syntax

DATEPART ( datepart , date )

Arguments

datepart

Is the parameter that specifies the part...

Primary key is a constraint. So you have to drop the primary key constraint. then create a new one that is not clustered. then create the index you want.

use sp_help...

http://www.microsoft.com/sql/howtobuy/default.mspx

Well it depends on the application they are building, and the feature/functions they want to use in sql server. Like replication and log shipping are not available in sql...

Are you creating these insert statements in your application?

or stored procedures?

No matter, if you don't want to use the N'SomeText'

Then you should parameterize your query, Which by the way is...

No built in function but you can create your own.

But I'd have to say if your table has repeating group names then your table design has alot to be desired.

create...

Can you post a sample tables ,

Some sample data,

and a query on how you figure what the top 10 sources are?

and a sample result set of how you want...

Try a little sql dmo. there is no 1 command in t-sql to do it.

http://www.sqlservercentral.com/columnists/awarren/lotsoftablesandalittledmo.asp

Use derived table something like this.

by top meaning the first 10, or the top ten ranked by sales or some other method?

Select top 5 Product, ProductNumber, SourceNumber, Source

From Products

Join (Select...