Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 1,417 total)

  • RE: Split a date-range into periods

    smunson (10/23/2008)


    ...the meaning of the value in the UNITS field has changed...

    Hi Steve,

    Thanks for pointing that out. But I created this sample to only simulate my data. The UNITS value...

  • RE: Split a date-range into periods

    Hi Anzio,

    I have work out your solution. Maybe others can benefit from this code.

    As you allready mentioned, this solution is more generic. The TALLY table now only contains the number...

  • RE: Split a date-range into periods

    AnzioBake (10/23/2008)


    It seems I can not post code to the site, I wanted to post a more generic solution

    Hi Anzio,

    Allthough the provided solution fits my current needs, I'm interested in...

  • RE: Split a date-range into periods

    Thanks Mark, it works like a charm.

    I knew a TALLY table could bring me the solution 😀

  • RE: Export to SQL

    What about this approach...

    - create and (re-)fill a table with your data using the scheduled job

    - link the Excel-sheet with the correct template to the table

    - (automatically) refresh the data...

  • RE: SQL Profiler for Small Business Server

    Install the SQL-2005 Workstation components and be sure to include the Management Tools. SQL Profiler is part of this.

  • RE: Sql Server machine name change

    To correctly let SQL 'know' and display the changed servername you have to run the following code to update the system metadata (sys.servers and @@ServerName):

    sp_dropserver {old_name}

    GO

    sp_addserver {new_name}, local

    GO

    See the article...

  • RE: "SELECT TRIGGER"

    I agree with Barry. Just create a trace, to only select the textdata of statements (SP and T-SQL). Filter this on the databasename and "%TabelName% %ColumnName%" and you only get...

  • RE: Sql Server machine name change

    Yes, you can change the name of a server running SQL Server. I did it last month regularly when setting up a new development environment. Every time without any issue....

  • RE: email notification job

    by reading the error message it looks like the "SQL Agent" service is not running. If it is running, then probably the account used for the SQL Agent has not...

  • RE: how to set dynamic path statement in sql server 2000

    You forgot to add the time to the filename. The CONVERT(VarChar(20),GetDate(),112) give you a date in notation in format yyyymmdd. You have to add the time to this part to...

  • RE: Renaming logical file names

    From BOL (under ALTER DATABASE):

    Moving a file to a new location

    The following example moves the Test1dat2 file to a new directory.

    Note:

    You must physically move the file to...

  • RE: Regarding IIF fuction in reporting services.

    IIF is a function available in Microsoft Access database and not in a SQL database. You have to use CASE instead.

    Sample from BOL:

    SELECT ShipVia, CASE ShipVia

    ...

  • RE: Database mail question

    For my knowledge it is possible for Database Mail to recieve e-mail. You have to re-route the mail address from Database Mail to your own.

  • RE: Bringind a database offline or single user mode runs for ever?

    Are all logins you see with sp_who2 your own? If not, other users are accessing the database. Kill those connections and try again.

Viewing 15 posts - 1,276 through 1,290 (of 1,417 total)