Yep.. Which flavour of Sybase though? There's ASA (Adaptive Server Anywhere), ASE (Adaptive Server Enterprise), ADS (Advantage Database Server)....

In the long long ago the Sybase schema was developed in part...

John's right. 120 is the version of the CONVERT date statement you are after though.

SELECT CONVERT(VARCHAR(30), CAST (CAST('20110607 12:09:21' AS VARCHAR) AS DATETIME) ,120)

Is this just a one off...

OK, sweet as.

I'll do some reading on temp tables and work out whether they are suitable for my purpose or not.

Thanks for your help!

Jim.

Thanks John.

I was afraid that was going to be an answer, but it does make sense, I really shouldn't be afraid of doing more work for the right reasons!

Can I...

Thanks for your replies! Sorry I took so long to get back and have a look.

I've run your query Steve, and it's exactly what I was after!

Now all I...

Hi Guys,

Thanks for your help!

Dan, The problem is that for each ID I want every day of the month (or selected time period). So because there are three ID's I...

This should start you off 🙂

--DROP TABLE #Test

CREATE TABLE #Test

( FirstName VARCHAR(100),

LastName VARCHAR(100),

URL VARCHAR(200))

INSERT INTO #Test (FirstName,LastName) VALUES ('Jim','Bob')

INSERT INTO #Test (FirstName,LastName) VALUES ('David','Glance')

INSERT INTO...

Would I also be correct to assume that you want this to run in the background to create a file that shows the queries with the user's name, time and...

Hi OP,

It sounds to me like you want to capture the rows affected by queries run by users of the database. For instance if the application (could be a custom...

Apologies for adding to what seems to be a resolved thread.. BUT! I was having a very, very similar issue.

My sp looked something like this:

CREATE sp_blahblah @month INTEGER (YYYYMM) AS

BEGIN

--use...

That works a treat! I just had all the guys in the office standing around watching how awesome that is! Untill we cast the string back to an Nvarchar! haha....

Thanks Barry!

This won't so much apply to the stored procedures, rather to queries we send. So the second part of your answer was exactly what I'm after..

How did you produce...

I know what you mean..

At uni I learnt to use the WHERE type.. So my queries always 'used' looked like

SELECT *

FROM classes c, students s

WHERE c.cl_studentID=s.st_studentID

...

Hi Peso,

HAHA! Looks like I've got some learning to do.. You kicked my butt.. I was happy to get out what I'd done.

Looks like CTE's are something I need...

Hi Rashmi,

Please try the below. Please also note that it doesn't do exactly what you want, it will only return ALL of the children of a specified node. I ran...