Viewing 15 posts - 1 through 15 (of 21 total)
I got it to work, but I'm not real happy with it.
IF OBJECT_ID(N'tempdb..#t1', N'U') IS NOT NULL DROP TABLE #t1;
GO
use Your_DB
DECLARE @StringToSearch VARCHAR(100), @ProcSearch VARCHAR(102), @Tot int
-- Change this string...
March 27, 2011 at 3:29 am
I used the term cursor incorrectly. I come from FoxPro where cursors are similar to temporary tables. I get two grid results when I run the query in...
March 24, 2011 at 2:36 am
I use this as a maintenance/development tool so speed is not important. @StringToSearch is changed each time I use it.
For instance, I want to find every place...
March 21, 2011 at 3:05 am
Agreed. I don't know how to get the repeating values out of the search string.
March 20, 2011 at 5:49 am
No, I am searching for the one character long string '#'
March 18, 2011 at 6:38 am
When I search for '#' in the following code it only finds the first reference.
CREATE PROCEDURE [dbo].[AREA_CustomerIssues3]
@ParType char(2) = ''
,@ParKey int = null
AS
BEGIN
SET NOCOUNT ON;
--select @ParType, @ParKey
;with cte as(SELECT...
March 18, 2011 at 5:40 am
Thanks. That is faster and cleaner than my code.
August 6, 2010 at 4:19 am
After further study I recognize the best solution is none at all.
I will remove the end date all together and the list takes care of itself.
Fred
July 19, 2010 at 3:18 am
Thanks for the help.
I use it to display data for users. For instance, if we have three different customers asking us to follow information on a supplier I display...
December 9, 2009 at 11:21 pm
August 31, 2009 at 4:46 am
I was able to make it work, but I have no idea if it is stable or a good idea.
ALTER PROCEDURE [dbo].[IH_GetRecords]
@Area char(15)
,@AreaKey Int
AS
BEGIN
-- SET NOCOUNT ON added to...
August 27, 2009 at 8:11 am
Sorry. Let's try this again. My code examples were incomplete.
I have a simple Stored Procedure that returns a record set to my app. I would like...
August 27, 2009 at 5:42 am
Thanks. Being new at this I didn't realize there was a setting.
July 23, 2009 at 7:59 am
I just tried to change a table. I selected a column that was char(35) and changed it to char(36), and pressed Save.
"Saving changes is not permitted. The changes...
July 23, 2009 at 1:09 am
New Query works, but the "Script Table as" choice for Alter is grayed out.
I need to work with it more to see what is possible.
Thanks.
July 22, 2009 at 1:56 pm
Viewing 15 posts - 1 through 15 (of 21 total)