There are plenty of people willing and able to help. The main reason nobody has helped yet is...

tilew-948340 (5/29/2012)

---

I need to move a DB from SQL server 2008 R2 on a Window7_64 machine to a WindowXP_32 (not sure that the machine would survive to an update to...

sql server developer (5/29/2012)

---

CREATE TABLE dbo.TestAsset(AssetID INT IDENTITY(1,1) PRIMARY KEY, SerialNo VARCHAR(100))

--CREATE Filtered UNIQUE Index to allow multiple records of NULL and Unique non-null values in serialNo column

CREATE UNIQUE NONCLUSTERED...

Some of the best learning comes through teaching. This has never been more true to a profession than sql server. The topic is so huge that nobody can master the...

Kind of an odd requirement to check for scientific notation. Not sure there is exact but maybe something like this?

;with SomeVals (CharVal)

as (

select 'AKN12345' union all

select 'REC12345' union all

select '12.47e43'...

There are lots of people around that can and will help. However what you posted is not enough information to even fully understand your question let alone be able to...

SELECT SYSTEM_USER

Well we do get MENtal pause. I have often found that this is the...

Well I hope it doesn't take that long...Labor Day is not until September....

I posted Gail's favorite yesterday in case you missed it.

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

What would you do if @ObjectDB = 'YourDB'? If you do a bunch of hard coded conditionals this proc will out...

You will to convert the entire thing to dynamic sql.

You can reference objects from any database on the server with full 3 part naming convention (database.schema.object)

Using a variable like...

blampe (5/25/2012)

---

I don't think I'm being clear enough, what I want is the procedure to run so it will replace all of the table values under ssn with COMPLETELY DIFFERENT...

If you want some real help read the first link in my signature. You need to provide a lot more details about what you are trying to do before anybody...

blampe (5/25/2012)

---

use Brett_Test

GO

if exists (select * from sysobjects where type = 'P' and name = 'countSSN')

drop procedure countSSN

GO

create procedure countSSN

as

set nocount...