you could do something like this:

a combination of the ccommandline type command and xp_cmdshell, you can ge tthe file contents of your *.sql files and execute them.

I just built this...

my first example, where i used delimiters that never occur in my data is a solid example of exporting and importing data with whitespace and dbl quotes int he contents,...

ok, bcp IN supports the quoted identifier, but not when you use bcp out/queryout;

it's been a while since i did bcp, i switched to Common Language Runtime to do my...

only if you change the datasource to use their AD credentials, instead of the cached username/password.

In that case, the end users most likely don't have permissions to query the data...

the order of the flags shouldn't make any difference, but i think if you run bcp /?, and put flags in the same order as the help specifies, that would...

you have to go deeper.

all that does is turn the string into a table. join that to another real table.

replace the function with dbo.DelimitedSplit8k(@Specimen,','); and CROSS APPLY that...

here's an example of a four character column delimiter(the -t) and a four character row delimiter(-r).

just put your pipe in dbl quotes.

i think if you just add the minus q...

Last YEARS data?

i thought you said last week.

the join criteria is the datediff info: i'm...

i think if you group your data by week or by day (with a filter for a weeks worth of data, and then join it against itself, you'll get what...

yes, it's expected behavior when we are talking about Windows groups.

you just have to take into consideration the situations you are seeing here: multiple groups, and the cumulative inheritance of...

the error is really straight forward.

just like an integer cannot have decimal information, the DATE datatype does not support sub-minute time increments.

choose a datype that is appropriate; ; DATETIME can...

here's a very basic example: just add a new identity column as a primary key, assuming there is not already any identity and not any existing PK either.

the identity function...

I believe the request is to split the @sku into a table , via dbo.DelimitedSplit8K for example:

right now he's passing a string that happens to have a comma in it.

WHERE...

turn on the SQL Browser. that's it's entire purpose.

if you are not going to run the SQL Browser service, i believe that on each and every client that is going...

interesting request, here's how i would handle it:

it's probably safe to assume that if it was installed from an MSDN media, all the version would have used the same installation...