to get preceeding zeros, you have to decide on the length you want(you said 3 digits in this example)

and do something like this:

SELECT RIGHT('00000000' + CONVERT(VARCHAR,(8 + 1)),3)

Kevin it has to do with datatypes; '008' is not numeric, it's a string, same as 'abc', but when you add it to an integer, it might get converted to...

linked server syntax:

Once you have the Linked Server in place I have found a few different ways of interacting with the mysql database:

Select Statements:

select * from mysql5...country

select * from OPENQUERY(mysql5,...

i think the recommended way is to connect via a dedicated admin connection (DAC);

I belive when you do that, all procs are decrypted automatically when you view them, to assist...

the function below is for SQL 2000 only; if you run it on 2005/2008/R2, all it does is drop teh encrypted procedure, but does not recreate it.

bjhogan (12/15/2010)

---

Check out this...

the error is your data types in your first table variable, and the way you are doing your case statements.

your first table is declared all as varchar(20), but then your...

you'll have to show us the procedure; the error itself is not descriptive enough to point out anything obvious.

the onlything i can offer is that if you are storing that...

I'd...

there are a number of threads here on SSC on this basic issue; it has to do with running out of memory;

there's not a lot you can do other than...

this article from Microsoft is what i have saved to get the list via PowerShell: I had this saved in my snippets, and the code I saved is unchanged from...

there is a technique for using dateadd/datediff together to get the starting date/time for any given period..year,month,week, even hour.

here's an example, giving you the begin hour and that same hour...

i have this saved in my snippets;

it's from a real comprehensive thread here:

http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

it's a stored procedure someone contributed to help set up a mysql linked server, along with...

Malcolm Daughtree (12/10/2010)

---

Uhhh. Because it's a SQL server NOT a firewall. What Idiot would expose a SQL server to the wilds of the internet for it to act...

vbradham (12/9/2010)

---

It amazes me that questions get asked, and yet no-one answers the questions. I would find so useful the example asked for here.

Leave the error checking aside, I...

excel automation is tough sometimes.

i'm pretty sure the issue is the first time a user runs Excel, a dialog comes up asking for your initials. I think the initials are...