Hi there,

i'm not sure what you really want, but my random guess is that you are trying to execute dynamic sql, and you wanted the results to be returned...

Hi there, have you tried convert()?? me only conversant in simple sql:hehe:

WHERE YEAR(CONVERT(DATETIME, importdate, 103)) = 2007

103 = DD/MM/YYYY format change to suit your date time zone accordingly 😉

hope it...

insane_professional (10/22/2007)

---

hi, i think its a pretty simple task but i just cant seem to get it right as I am pretty new to SQL.

What i want to do is...

Thanks Andras,

Been google-ing for sometime but fail to come across any forum thread/article. Guess i've been using the wrong keyword.. That thread is great.. now i've some ideas to kick-start..

With...

Thanks John for ya reply 🙂

Its a gd and easy way out but i've to schedule the job to run daily. Guess i'll do it your way or alternatively is...

Hey MarkC guess you made me realise i should start reading up on SQL XML

Cheers ;),

Jon

:w00t: its not that i don't know the solution, i'm just trying to discourage what i would classify to be application logic at the database tier..

here's a working syntax.. as...

why not do this at application level instead?? It'll simplifies things alot.

Cheers ;),

Jon

PS: Its possible to do it with T-SQL but i wouldn't recommend that, you can do it with...

by the way, if you would like to have

1 1 aaa AAA CA

2 1 aaa AAA LA

being returned as

1 1 aaa AAA CA/LA

you can acheive it by using...

Hi there,

hmmm, sounds to me that you only needed 1 record to be return?? Correct me if i'm wrong, in SQL Server there is nothing such as "groupdistinctcolumns", but there...

hope this helps 😉

CREATE Function Foo (params...)

AS

IF (exists(somequery))

BEGIN

RETURN 1

END

ELSE

BEGIN

RETURN 0

END

GO

Cheers,

Jon