Note that isnumeric is not always reliable

select isnumeric(','), isnumeric('12d6')

Double click the error

It will move the cursor to the specific line

milzs (2/18/2009)

---

I'm sure this is straightforward but it's the end of the day, my brain is fried, and I'm coming up empty. 🙂

I have two tables each with the...

something like

select col1,max(col2),max(col3)... from table

group by col1

Something like

select LoginOwner, min(LoginDateTime) as min_time, max(LogoutDateTime) as max_time

from table

group by LoginOwner,

dateadd(day,datediff(day,LoginDateTime,0),0),

dateadd(day,datediff(day,LogoutDateTime,0),0)

swmsan (2/18/2009)

---

Hi All,

I am using DateDiff function to find out the difference in number of days between 2 dates. [select Datediff(DD, '2009-02-10', getdate())]

I get same answer when I use 'D'...

EXEC sp_msforeachdb 'select * from ?..sysobjects where xtype=''tr'''

or

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/05/13/simulating-undocumented-procedures.aspx

Ninja's_RGR'us (1/15/2009)

---

Doh!!!, I just figured it out

SET @X = '278 * (1 / 4) - 2'

1 / 4 = 0 because both numbers are Ints.

if you use 1.0 instead of...

One of the methods is

declare @t table(ID int,Expression nvarchar(100))

insert into @t

select 1,'8*(1/2)-6' union all

select 2,'278*(1/4)-2' union all

select 3,'81*(3/5) +4'

declare...

Try this

select t1.col1, t2.col1 from

(your first query) as t1

cross join

(your second query) as t2

order by 1

For diffrent length

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/18/extract-only-numbers-from-a-string.aspx

Ashwin M N (12/30/2008)

---

Even if I execute this query I cannot exclude the 19"-R character. The " character is main problem.For rest all my query works fine.Is there any way...

Make sure you read this fully

http://www.sommarskog.se/dynamic_sql.html

You are welcome 🙂

Thanks for the feedback 🙂