-- Convert to int if a valid integer

select

TestData,

Output_INT =

case

when TestData like '-%[^0-9]%'then null

when TestData not like '-%' and

TestData like '%[^0-9]%' then null

whenTestData not like '-%' and

datalength(TestData) > 10then...

You said you had a float to decimal converion that errors out. Maybe you could start by posting an example of that?

This works Ok for me in SQL Server 2000 and 2005:

declare @var float

set @var = 132456789.12552346

select [Decimal] =cast(@var as decimal(11,2)), [Float] =@var

Results:

Decimal Float ...

Don't be shy about posting the code that you want help with.

It is better to go with the ID approach. If one of the codes changes, you only have to update a single row in one table. For example,...

You should ask your teacher for help if you are having trouble with your homework.

Rob Reid (1/31/2008)

---

Cheers for that SQL that will work a treat to output the correct GRANT permissions.

As for the role being deleted and re-created again, maybe but no-one will own...

Maybe the error was caused by someone deleting the role and then creating it again.

Seems more likely than someone accidentally revoking permission on all tables to just that role.

The link below has a number of different examples. My own is, of course, the very best.:P

Creating a Formatted Calendar

There are several methods is this link that will return...

Wayne West (1/30/2008)

---

Michael Valentine Jones (1/30/2008)

---

Microsoft is pretty quick to drop support on prior versions.

Not every vendor does that:

http://h71000.www7.hp.com/openvms/openvms_supportchart.html

OpenVMS VAX version 5.5-2 released in Nov 1991

Ending date for Prior Version...

Microsoft is pretty quick to drop support on prior versions.

Not every vendor does that:

http://h71000.www7.hp.com/openvms/openvms_supportchart.html

OpenVMS VAX version 5.5-2 released in Nov 1991

Ending date for Prior Version Support-Sustaining Engineering:

At least through 2012,...

It appears that the query is working exactly as described in SQL Server Books Online.

That tells absolutely nothing about...

He didn't say he was dividing into 4 filegroups.

He...

AlexSQLForums (1/30/2008)

---

Michael Valentine Jones (1/29/2008)

---

Even if your data files are on different arrays, the backup speed will also be limited by the speed that it can write the backup file....