Recent content by cfaulkner

Ah, thank you, thank you, thank you. It's the dynamic SQL. Thanks, Craig

SQL Server 2000 (8.0.2039) I need to grant execute permissions on a stored procedure that updates a table to a user that does not have update permissions on the table the sproc updates. I can't get this working. I use grant execute on dbo.sprocname to username and get UPDATE permission...

Thanks

This a vendor app that we have to work with. Basically the string that is being passed in is a query that then must be run (EXEC), so that may be another limitation. So, say we are passing in a 10k string (query) that is then run from the SP. Obviously we can't pass in the 10k, but we could...

I need a way of passing strings larger than varchar or nvarchar (8,000) into a stored procedure. There seems to be a problem with using the text datatype; like you can't. Can anyone offer a creative solution for this? Thanks so much!

Thank you, this worked: select substring([fulltext],84,datalength([fulltext])) I need to strip the first part of this off.

We have a vendor that decided using SQL keywords was ok for column names. I have a column named "fulltext" that I must manipulate. BOL states that you can do this but that you then must address them as quoted identifiers. I can't get anything to read this column when used in a function like...

I am using the CF MX 7 Report Writer for the first time. Does anyone know how to supress the blank lines that occur when a text area is not fully populated? For exaple, I have item and description. The description is not always the same length. That leaves balank lines between each item. Thank!

vongrunt And it works! :) Popped it into a function table with a few minor changes and I'm good to go. That made my day.

Both excellent suggestions. Thank you! Thank you! I'll play with them both and will likely include this in a function table. Sometimes I just like to complicate my life (i.e. my initial effort). Craig

jbenson001's code looks good and charindex is a better choice then patindex. Give his suggestion a try.

Oh yes, the duplication. I forgot about that for the moment. I tried converting the where 'int' into a varchar but received an error. BTW, this works but is it limited to the number of selects and VERY ugly; to me anyway. select emplid from dbo.temployees where mgrid = 255 union...

Use Patindex in conjuction with substring or left/right. PATINDEX Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.

I have spent about 10 hours on this issue so far trying everything that I can think of to work around this so any help would be greatly appreciated. I just feel like there should be simple solution here, I just may not be seeing the forest through the trees. I am trying to find all employees...

Did you ever find your answer. Can't beleive no one answered this one. If you still need help let me know your backup plan and I'll give you some ideas. If you are not doing log backups you can set you DB to avoid this problem. If you are there are still options. Craig