Try this.

http://www.sqlservercentral.com/articles/SQL+Server+2005/63184/

I think the problem you are facing is that an int / int produces an int. Take the following examples...

select 3/2

select 3/2.0

To fix the issue multiply one of your...

Yes. You need a Begin/End when using multiple statements.

IF (1=1)

Begin

insert...

update...

END

ELSE

Begin

...

Here is the link on how to upgrade using the attach/detach method.

http://msdn.microsoft.com/en-us/library/ms189625(SQL.90).aspx

Try this. What is the datatype of the CCNum Column? It does not sound like a uniqueidentifier.

Select Right(stuff(CCNUM,1,12,replicate('X',12)),16)

From YourTable

The script that creates the new guid is just for example. Use the logic in the select statment on your credit card field.

Select Right(stuff(CCNUM,1,32,replicate('X',32)),16)

From YourTable

How about something like this.

Declare @tst uniqueidentifier

Set @tst = newid()

Select @tst

Select Right(stuff(@tst,1,32,replicate('X',32)),16)

I think you would have to use a case statement to achieve the same funtionality. If the datatypes are different you can convert them to a commen type in the...

Pretty cool Jonathan. Yet another reason to upgrade to 2008.

That is pretty funny. (1 result to this thread)

Here is an example of a cursor outperfoming a set based solution. I am not saying it can be done often, but I never say something can't be done.

I was going to throw a rock at the hornets nest and run, but I will chime in. I seem to write code a lot more "loosely" when I...

I was able to disable a trigger on my test database using the dbname..tablename syntax. I wonder if it is...

The syntax looks correct. Make sure you do not have the code partially highlighted or you may get this error message.

I have altered the script to list all users in all databases that do not have a matching user in the master database.

DECLARE @Collation varchar(100)

DECLARE @sql VARCHAR(2000)

CREATE TABLE...