Eddie Wuerch announced on LinkedIn that he got his notification that he'd been laid of from SalesForce when he tried to login.  That's definitely NOT the way to do proper...

Agreed.  Do...

In order to do what Scott suggests, you'd need to make a SEQUENCE that counts from 1 to 999 and then recycles back to 1.  The formula to convert that...

Just a tiny simplification of what Jonathan posted and it starts with the "B" series like you wanted...

 SELECT TOP 6500
      ...

Aye... thanks for posting the link for that.  Much appreciated.

@ kirti ,

If you could answer the question above, I can make...

@ kirti ,

What do you want it to do when you go to 1 more than 10.Z999 ?

Hi All,

I am doing BCP out the table having 175 columns. For small table columns it works fine.

It errors out for this big column table.

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT col1...col175...

I've been researching this for over 3 hours and none of the syntax I've found works.  I have a column with data that's been merged from various other...

Heh... and still have everything run single threaded because of the way people wrote the code. 😀

Very simple example:

sqlcmd -S <ComputerName>\<InstanceName> -i <MyScript.sql> -o <MyOutput.rpt>

Just use a sqlcmd SQL script with the function below using a windows scheduled task in a batch file:

If  datepart(dw,getdate()) =...

Some old tech that I wish would come back is people that actually know how to ask a question and then read the answer and act upon it...

I would ask an "sqlguru". 😉

As a bit of a sidebar, we disable the SQL Server Browser as part of the security setup because it also kills some of the auto-discovery of machines.

You're still using the linked server?