why can't you just replace all spaces in the string?

update yourtable set yourcolumn = replace(yourcolumn,' ','')

maybe with row number, if we can assume there is a data entry for every date.; from the data, i'm inferring that we are getting 5 or more business days,...

also, you don't need to expose your Id to end users.

another post a while back asked how to generate a combo varchar/number field, like AAA001 thru ZZZ999;

would something like...

why not just seed your identity at 10,000, so they could only infer from 10,000 to 99,999;

an identity serves a much better purpose for indexing than a randome number ever...

well finding something that is older than 5 days is easy...but you have to know which column to compare;

it took me much longer to build the CREATE TABLE and INSERT...

wierd; I've always expected that restore gives the exact same data every time...restore it and the collation, which is in the databases sys.columns is restored to wherever it was.

I haven't...

just following up;

you'll want to test this two ways; after granting permissions to the procedure, just like i showed, log into SSMS as one of those users and run the...

Here's an example of how I've done it.

First, I made sure there is a specific role created that will let people do it; mine is very simple, because a web...

for SQL 2000, there is a set of extended stored procedures right here on SSC that have a collection of encryption methods:http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2000encryptiontools/2344/

the tools include the following:

The tools are extended stored...

Chandhini (9/1/2009)

---

Hi,

In my Database, i need to create two different roles to access the db. one is for application and the other one is for development.

For application -...

here's the example i always reference from my snippets:

DECLARE @var VARBINARY(128),

@res NVARCHAR(64)

SET @var = CAST(N'Hello World' AS VARBINARY(128))

PRINT @var

--results: 0x480065006C006C006F00200057006F0072006C006400

SET @res =...

i don't use complex foreign keys , but here is an example i whipped up for the syntax:

this foreign key references two columns in the parent table...limit is 16 i...

gboyer (8/31/2009)

---

All,

I am trying to find a count on all records in a table that have more the 2 numbers after the decimal point in an Amount Column. The field...

Scott Solice (8/31/2009)

---

I have an ntext column that contains the full text of an rdl object. I need to update every occurrence of Parameters!AnyParm.Value with Parameters!AnyParm.Label.

I could use Replace, Stuff,...

give us more info,

sounds like the query is big, so

save the actual query as a text file, and show us the estimated execution plan, saved as a .sqlplan file....