Good One. It should work like a charm...

This is interesting, the problem is not with the dynamic sql. The problem is the filegroup name is expecting a character as the starting character.

Absolutely if you are building a Where condition using a string builder based on multiple column selected then I would say you would need to opt for Dynamic SQL...

If you want to introduce line feed and carriage return between the lines of address you should go with Goodguy's solution. Else just using ISNULL(column,'') should do it.

As long as your where condition column is also dynamically changed you would probably be left with no choice than dynamic sql.

What is cell format for the Value field in Excel. I believe ',' may be your delimiter for 100. You may want use custom formatting in excel before trying to...

That is interesting. Can you check the SQL Server logs and see if you could find anything that might have caused this. Your input may help others who may get...

I believe the issue is related to permissions. Please follow the instructions in the below post and see if you can find any success.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=836809&SiteID=1

Thanks

Please check What does sp_help DocumentsNumbering return you. Also check if there is something wrong with your UDT.

You need to run the SQL profiler and capture the trace for that application. You need to build your profiler to capture the calls from the application. It may not...

I could not really test this, so please run it in your qa environment

DECLARE @sql varchar(2000)

DECLARE @TableNAme varchar(100)

DECLARE @RowCount int

DECLARE @UpdateSQL varchar(2000)

SET NOCOUNT ON

DECLARE csrTables CURSOR FAST_FORWARD LOCAL FOR

select name,...

Use this update statement. I did not validate your where condition. But you should be able to remove your P prefix from your account using this.

--SET @UpdateSQL = 'UPDATE '+@TableName+'...

Hi Stephen, Can you please post your code. It would be really difficult to assume what could go wrong based on your statement. If you could post the code that...

I completely Concur with Johannes's solution where you just need to use a function that returns all values after applying the comma delimiting logic and insert the same into a...

Can you get on to Database setup tab and check Credential Type you are using. Basically from your error, it seems that you do not have access previleges to modify...