User Profile

Collapse

Profile Sidebar

Collapse
sqldba
sqldba
Last Activity: Feb 29 '08, 11:39 AM
Joined: Dec 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sqldba
    started a topic how to Mutiply different data type columns
    in SQL Server

    how to Mutiply different data type columns

    Hi ,

    I have the below tables

    Table 1 with columns

    id int
    price char
    quantity int
    date date

    In this table, same id has several entries at different date.

    table 2 with columns

    groupid int
    groupname char


    table 3 with columns

    id...
    See more | Go to post
    • sqldba
      started a topic SQL Script to sync. two servers
      in SQL Server

      SQL Script to sync. two servers

      Hi,

      I have two servers, one is a production server and other is a testing server. Both these servers must be in sync.

      Please can anyone let me know how to synchronize these two servers(automat ically) without replication.

      In particular i want databases, tables, views, users and stored procedures to be same in both the servers. If a table gets added/deleted/update on the production , the same must be done...
      See more | Go to post
      • sqldba
        started a topic truncating data older than 30 days
        in SQL Server

        truncating data older than 30 days

        Hi,

        I have a table with
        C1- ID
        C2-Date
        C3-Date with time
        C4-quantity

        I need to create a daily process that will remove the oldest data(data older than 30 days) on the table and make sure the table is with only 30 days worth of data.


        Please help me.

        Thanks in advance
        See more | Go to post
        • sqldba
          started a topic SQL login and user creation
          in SQL Server

          SQL login and user creation

          Hi ,

          Please help me in writing a store procedure/ sql script on creating al ogin and adding the login as a user to the database with Select/update/execute permission.

          Thanks
          See more | Go to post
          • sqldba
            replied to Need SQL Script
            in SQL Server
            Hi Nedu,

            Thanks for the script,

            I need to create a Store Procedure for this script.

            Please help me in doing this with some modification that i have elaborated....
            See more | Go to post

              Leave a comment:

            • sqldba
              replied to Need SQL Script
              in SQL Server
              Hi Nedu,

              Thanks for the script.

              I still need your help. I need to create a store procedure with doing some modification on (make join) your script to retrieve some more data.

              I will elaborate.

              Table 1
              C1-accountid
              C2-date
              C3-gross(postivie and negative decimal values)
              C4-net(postivie and negative decimal values)

              Table2
              C1-groupid
              C2-accountid...
              See more | Go to post

                Leave a comment:

              • sqldba
                replied to Need SQL Script
                in SQL Server
                Hi,

                The sql statement for step1 is

                select top 10* from table_name where date > getdate()-1 and grossamount < (floor(-00.00)) order by grossamount

                How to proceed further.

                Please help...
                See more | Go to post

                  Leave a comment:

                • sqldba
                  started a topic Need SQL Script
                  in SQL Server

                  Need SQL Script

                  Hi All,

                  I am new to SQL programming, i have only a fair knowledge on sql programmin.So, I apologies for any silly questions:)-

                  I have a table which contains
                  C1-acountid
                  C2-date
                  C3-grossamount(pos tivie and negative decimal values)
                  C4-netamount

                  I need to retrieve the following on a single table
                  1. top 10 losers of the day i.e. 10 AccountIDs with the greatest negative Grossamount...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...