it ooks like the desired sorting is "strip non numeric chars and order by the numeric portion(if it exists) then by the string"

so

ORDER BY

CASE

WHEN ISNUMERIC(dbo.StripnonNumeric(ColName))...

you can simply use the SELECT... INTO TABLENAME FROM ... functionality to create the table, wethehr permenant or temp, of the fly:

SELECT SUBSTRING(ColumnData,1,3) AS ,

...

ok in theory, this is pretty close. I didn't test too many examples, so its up to you to improve it and test the edge cases, but it seems to...

yep i had inherited a similar situation; i created a role that had access to db_datareader,db_datawriter and EXECUTE, and replaced their original db_owner model; that worked for 99% of what...

ok i think this might help you visualize:

/*

InputDate StartOfMonth AS...

with MySampleData

AS (

SELECT

'06/01/2007' as StartDate,

'10/04/2010' as EndDate

)

SELECT *,

datediff(dd,StartDate,EndDate)

FROM MySampleData

ok that returns 1221 days...but lets...

we should all plan on meeting for a networking session at a local restaurant or something Thursday night; at least it'd be nice to put a face to your forum...

that's up to you; you can either...

from TSQL? you can't; what you'd have to do instead is to change the PRINT command to a SELECT; then you can put it in a variable or a table...

10.0.* is SQL 2008

10.5.* is SQL 2008R2. a next higher version of SQL; you'd have to either download an express version of R2, or buy , at a minimum, the...

that's not what you said before...

you said you added...

i don't believe the index was added.

this works fine for me, and orders the results as expected int eh second query:

CREATE TABLE TestTable(ID INT);

GO

INSERT INTO TestTable(ID)

SELECT 7 UNION ALL

SELECT 9...

debbas88 (5/10/2011)

---

I understand a Windows group will act as a login. So once a windows group is created, if I strip it from all server roles, will my application be...

oops i thought the issue might be how Oracle is less forgiving than SQL when it comes to conversions from string to DAteTime, but most of what you qare doing...

Integrated Security=True in the connection string.: that means that if myDomain\Karen uses your app, THAt is the username that will be used...NOT your test user.

you need to add a Windows...