Search results for query: *

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

vongrunt, that was my question too. One of them at least. I was told this be a high level engineer for a mostly Java company. I hate it when I read me posts and find a bunch of typos! Sorry about that. Anyone have any more ideas on how to approach this? Thanks, Craig

This database will be sort of a router. The data streem will come in and be split off to different tables depending on the looup results of another table. If a perfect world the tables should not get large as this is not a repository. Of course nothing is perfect and at some point the data...

I need to generate a key for a feed from a couple mainframe systems to a SQL 2000 box. This will be a new high end server. The feeds will be dumping data into SQL at up to 300 TPS. Is there anyone already doing something like this? Also, I'm told that it is more efficient and less likely...

Thanks Denny, as I said, I know how to use QA in 2005. I'm looking for a way to display and edit multiple rows of data as in 2002's Enterprise Manager. The grid layout that is EDITABLE.

Denny, I agree, but how?