i do this in a programming language so i can use regular expressions;

There are two issues to look at...are two procs EXACTLY the same , character for character, or are...

this would ignore colons and am/pm, i think...but it doesn't leave whitespace between a time and am/pm...

SELECT dbo.StripNonNumeric('Wednesday, 12:14 pm')

returns "12:14pm",, is that what you want?

you could get fancier on...

also guilty of that here!

i've done the same as what you are asking many times...moving data logic out of VB and into stored procs...post the code as an attachment, i'm sure we can give...

ray here is an older Scalar function I have saved;

If I were doing it today, I'd convert it to an inline tableValue Function, but this would be quick;

you could also...

Yes. The only way to get the space back is to...

tempdb is recreated every time the server is stopped and started.

the only way to reclaim the space (as far as i know) is to stop and start the service again.

something...

JamesX (3/9/2012)

---

I would if i could, but the tables are built by a program that was written from the manufacturs of the mainframe, each night it rebuilds the tables and...

i believe this is only items that have a chached plan that was recently used; if the command is not in this, you'd have to add a trace to capture...

kewl! where can i find that? can you send it to me via email?

this one loks so interesting, but I'm not able to take the time to convert the data in the screenshots into tables myself.

can you post a few sample rows of...

set the value to 39167687

the next value inserted will be 39167688.

proof of concept:

CREATE TABLE MyTable(ID int identity(1,1) not null primary key,someval varchar(30))

insert into MyTable SELECT ('normal')

insert into MyTable SELECT ('normal...

one piece of it is a catch all query, right?

And @SyCampusID = Case @SyCampusID When 0 Then 0 Else SyCampus.SyCampusID End

to see them all, i'd use row_number:

select row_number() over (PARTITION BY name, description ORDER BY code, name, description) As RW,

code, name, description

FROM YOURTABLE

from that same query, the ones with...

stick with dynamic sql;

something like this seems to work for me:

declare

@isql varchar(max),

@dbname varchar(64)

SET @dbname = 'TargetDatabase'

declare c1 cursor for

SELECT modz.definition

FROM sys.sql_modules modz

LEFT OUTER JOIN sys.objects objz

...