Search results for query: *

Will do! Thanks for the help.

I know you can call a SQL stored procedure from excel and have it populate cells but can you do the same with word? if so can some post a sample of exactly how to do that. Thanks in advance for you help.

Thanks for all your help! I got it working!

Hi!, We just switched to a new server the old one was 32 bit and the new one is 64 bit. The problem I am having is that the linked server I created to access a MYSQL DB now gives me the following error. it worked perfectly fine on the old server. "The specified DSN contains architecture...

Exactly! Thanks for your input.

Does anyone know why I would get the following error all of a sudden? All my dbmail stored procedures just started to fail after working perfectly forever. Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 357 Query execution failed: Sqlcmd: Error: Microsoft SQL Native Client ...

No, Permission have not changed and there is a space in the name but it always has a space every month and it worked fine in the past.

I have been using the following code for well over a year to import an excel file and it worked perfectly but now all of a sudden I am getting an error. Does anyone have thoughts on what could cause it to stop working. set @select = 'SELECT * INTO ' +'temptable'+' FROM OPENROWSET('+...

We are testing using Microsoft Azure and ran into a problem. We connected to the DB using management studio on a local computer using the admin login and we can see the DB but it will not display the tables or views. If someone has any experience with this and could point me in the right...

Thanks for all your input!

That is what I have currently. I think I have a work a round for now. Thanks.

It there a function available in SQL 2005 that will allow a field in the database to always have its current row number?

Yes, I took a look at your link but my sticking point is once I have the closest stores I need to get each location into the address file as new fields so I can print them out on a piece that goes in the mail.

I have two tables one has addresses and the other has store locations. What I need to do is pick the 10 closest stores for each record in the address table from the store table. I have a function to calculate the distance but struggling with how to get the store records that match into another...

Got it! thanks for your help.

yes, but the error keeps referring to the old login even though I switched it to SA.

I have a SQL SP that has been running fine for months but we recently move the SQL databases to a new box and now the SP aborts when running in a scheduled job. The weird thing is if I execute the SP manually it works fine. In the error log I get a log in failed when running it as a scheduled...

Is there an easy way to add a calendar month to a cell based on another cell? To be clear if I have a date of 1/31/2014 I wanted the next value to be 2/28/2014 and not 3/3/2014.

Can someone tell me what is the most efficient way to move our SQL databases from one server to a new server? There are about 10 databases that we are needing to move.

Thanks for your help gk53.