Forum Replies Created

Viewing 15 posts - 13,816 through 13,830 (of 13,849 total)

  • RE: TRigger Problem

    This is a bit confusing and needs a bit more info.  Are you saying that every time you create a record in table1, you need to create an associated record...

    June 21, 2004 at 12:45 am

    #511174

  • RE: Append query - best architecture

    Nice thinking and thanks for the response - you've approached it from an angle I hadn't considered. 

    But had to get on with it and have already written a wedge...

    June 18, 2004 at 12:15 am

    #510958

  • RE: Data file

    This is from BOL – SQL Server 2000 and gives you lots of useful capacity info.
     

    Send...</a></td><p></tr><p></tbody><p></table><p></div><p></div> </div> <div class=

    June 17, 2004 at 9:34 pm

    #510948

  • RE: programmatically switching off (x row(s) affected) in query analyser results pane

    Use 'set nocount', eg

    set nocount on

    select etc

    ...

    set nocount off

    Regards

    Phil

    June 16, 2004 at 5:29 pm

    #510749

  • RE: Running stored procedure in QA - ODBC Error

    Excuse my lack of knowledge, but how do you control the method by which QA connects to a particular SQL Server instance?

    Cheers.

    June 4, 2004 at 1:46 am

    #508949

  • RE: Running stored procedure in QA - ODBC Error

    Windows 2000.  SQL Server 2000 SP3.

    Cheers

    Phil

    June 4, 2004 at 1:13 am

    #508942

  • RE: Select latest 2 records - Select top?

    Think you can do it with a UNION query – something like:

    select name, max(last_seen)

    from test

    group by name

    union

    select t1.name, max(t1.last_seen)

    from test t1

    inner join test t2

    on t1.name = t2.name

    where t1.last_seen < t2.last_seen

    group by...

    June 3, 2004 at 11:48 pm

    #508932

  • RE: Dumb SQL question....

    The sysuser_sysusergroup and sysuser tables do not even exist on my SQL Server 2000 installation – are they standard?  I'm sure that I could help out if I understood the...

    May 13, 2004 at 5:57 pm

    #506399

  • RE: Alert conditions - what is best

    Eh?

    Bit more detail required here.

    May 13, 2004 at 12:57 am

    #506240

  • RE: date ( check constraints what ever)Problem in SQL-SERVER 2000

    Two ways spring to mind.

    1) When the application sets the deleted flag to 'Y', why doesn't it set the deleted date as well as part of the same transaction?  This...

    May 13, 2004 at 12:44 am

    #506239

  • RE: TSql Script

    Try this:

    select top 10 * from information_schema.routines

    where routine_type = 'procedure'

    and then refine to get the fields/data you want.

    May 12, 2004 at 5:38 pm

    #506222

  • RE: MSQL Server 2000 Inet connection problem

    What error message do you get when the browser won't connect?

    Can you still ping external addresses?

    If you stop the SQL Server service, does it fix the problem ... are you...

    May 11, 2004 at 1:54 am

    #505916

  • RE: Removing certain records of a SQL Server table

    In the interests of referential integrity, you'll probably need two delete statements.  The first will delete the relevant invoice lines and the second their corresponding header records.

    (Not sure quite why...

    May 10, 2004 at 11:06 pm

    #505899

  • RE: Need Help With Query

    You need to use aliases ... effectively creating two instances of the TeamList table and then using them as if you had two separate (but identical) tables ...

    select team1.teamname,...

    May 9, 2004 at 10:53 pm

    #505743

  • RE: what is the best Editor for SQL Server

    Query Analyzer (one of the SQL Server client tools) is the standard development environment for views, stored procs etc.

    Not so sure that many guys in this forum think that EM...

    May 9, 2004 at 10:43 pm

    #505742

    • Viewing 15 posts - 13,816 through 13,830 (of 13,849 total)