A bit shorter code (but doing the same as Gail's solution):

UPDATE [Test]

SET [Name]= COALESCE(@Name, [Name]),

[Designation]= COALESCE(@Designation, Designation),

[City]= COALESCE(@City, City)

WHERE EmpID= @EmployeeID;

Explanation:...

Take a look in the script repository http://www.sqlservercentral.com/Scripts/. You can find many scripts to get information about permissions. One of them will most certanly fit your needs.

How are you currently passing the value from the GENERATE to the SHOW stored procedure?

If possible post the code of both procedures, so we can analyze your problem and provide...

From your description it is very hard to tell what the problem could be.

I suspect one of the queries within the BCP process occasionally won't return data (no rows present...

It looks like your script is being cut-off. The compplete word in your error message should be "ERROR_REASON" instead of "ERROR_REASO".

I think you should split the complete script file into...

I haven't tested this with your ssample data, but I think this will give you the result:

SELECT

[VendorNum]

, [VendorName]

, YEAR([PostingDate]) as 'Year'

, Sum([Amount]) as 'TotalSum'

FROM [tempVendorPurchases]

GROUP BY

[VendorNum]

, [VendorName]

, YEAR([PostingDate])

If the results change when you uncomment the [MerchState] field, that means the current GROUP BY overlaps multiple values in the [MerchState] field. The main question is: which of these...

sreenubabu.s (11/5/2013)

---

I want to upgrade SQL 2005 to 2008, i don't want to do in-place migration directly.

we are planning Side by Side Migration only in the Production.

would it work ?...

I'm sorry, this goes a little beyond my current knowledge. Because your current issue is regarding the file folders, I suggest you post this problem on a VB-script / VBA...

Yesterday I was finally able to create a test case of my own. The code I provided in the previous post is tested by me.

Initially I just used the code...

The code below will give you a working example. It will loop through all files within the given folder. When the file is of a type: "Microsoft Access Database" then...

Take a look at this site: http://allenbrowne.com/func-ado.html. You can use the sample to query the database for a list of tables. Hopefully this will give you an error when executing...

Unfortunate I'm currently not able to setup or test this myself. I can only give you some pointers...

So you say you don't get an error with the "objConnection.Open strConnection" command...

If the previous doesn't work I'll have to guess some follow up steps.

What happens if you supply a dummy password? Will this generate an error or will it still pop-up...

You mentioned you can't create the database user and give permissions from the LOGIN (ssms: instance - security - logins - properties existing login). But are you able to create...