pedro.ribeiro (4/23/2009)

"Set nocount on" does this instructuction affects the error count (@@error) inside the stored procedure while it is executing?

Or the Set nocount on, only affects the...

yulichka (4/23/2009)

b_boy (4/23/2009)

If col A has a record like '%A' and col B is blank, then update col B with col...

You didn't provide enough information.

You need to add 375,000 rows, and you're concerned about having enough space.

So, you need to determine how much space each row will take in that...

anjana.maganti (4/23/2009)

i mena like using any fuction..

Anyways you...

anjana.maganti (4/23/2009)

I don't do a lot of VBScript programming, but from what I see:

1. your main routine never calls the DbaseUpd subroutine. I think before the conn.Execute line, you need a...

Ahh, didn't consider double-posting. I thought that I had posted that reply, but then I second-guessed myself and figured that I just didn't click the post button...

Try this:

declare @testdate varchar(50), @realdate datetime

set @testdate = 'Monday, January 28, 2008'

set @realdate = SUBSTRING(@testdate, CharIndex(', ', @testdate)+2, 50)

select @testdate, @realdate

Try this:

declare @testdate varchar(50), @realdate datetime

set @testdate = 'Monday, January 28, 2008'

set @realdate = SUBSTRING(@testdate, CharIndex(', ', @testdate)+2, 50)

select @testdate, @realdate

Dizzy (4/23/2009)

Does the whole procedure get executed only on the first day of the month, or is there some part of it that only gets executed on the first day of...

You are looking for the system view sys.all_sql_modules. Specifically the definition column.

Okay, how's this?

-- create temporary table

DECLARE @HOLIDAY_DESCRIPTION TABLE (

[holiday_number] [bigint] NOT NULL PRIMARY KEY CLUSTERED,

[holiday_description] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

...

doran_doran (4/22/2009)