Viewing 15 posts - 7,576 through 7,590 (of 13,460 total)
seshukumar.thokala (5/12/2011)
I tried ur example wt u posted but my problem is in my database i am having data like 30.6.1 so how to...
May 12, 2011 at 4:09 am
Sergiy (5/11/2011)
Lowell (5/11/2011)
it ooks like the desired sorting is "strip non numeric chars and order by the numeric portion(if it exists) then by the string"
Your assumption is onviously wrong.
Look at...
May 12, 2011 at 3:54 am
it's the left join that is confusing you.
in the first query, the left table has all rows, and matching records from the second table get joined.
after that, you are filtering...
May 11, 2011 at 6:14 pm
you should avoid(actually...i say never) trying to move data to another database or another server from within a trigger; the trigger could fail and rollback if the database/network/latency issues arise....
May 11, 2011 at 6:09 pm
slash-r is for the RETURN of CrLf, very typical from unix/linux-sourced files: slash-n is CrLf, which you were already aware.
vbCrLf = CHAR(13) + CHAR(10) = \n
vbCr = CHAR(13)...
May 11, 2011 at 6:03 pm
Aaron you want to change it a little so your lookup tables get populated by a SELECT featuring the DISTINCT clause:
----INSERT INTO WorldTable using Select
INSERT INTO World (Description)
SELECT DISTINCT World
FROM...
May 11, 2011 at 5:58 pm
my only suggestion is going to echo Mike; show us what you have so far; if the columns are variable length, I'd end up writing a program instead of trying...
May 11, 2011 at 10:50 am
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))...
May 11, 2011 at 4:57 am
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 ,
...
May 11, 2011 at 4:48 am
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...
May 10, 2011 at 2:58 pm
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...
May 10, 2011 at 2:42 pm
ok i think this might help you visualize:
/*
InputDate StartOfMonth AS...
May 10, 2011 at 2:36 pm
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...
May 10, 2011 at 2:28 pm
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...
May 10, 2011 at 12:54 pm
ma29 (5/10/2011)
I do have an R2 version do I need to go through the whole install or does it update allaspects of the program.
that's up to you; you can either...
May 10, 2011 at 12:39 pm
Viewing 15 posts - 7,576 through 7,590 (of 13,460 total)