User Profile

Collapse

Profile Sidebar

Collapse
ciqeane
ciqeane
Last Activity: Nov 29 '10, 02:37 AM
Joined: Aug 19 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ciqeane
    started a topic how to clear password in report manager
    in SQL Server

    how to clear password in report manager

    dear all,
    i am having some issue while using SSRS. there is username and password prompt for the first time when i want to view the report in report manager. after that when i want to view in the same pc, i no longer need to key in user name and password. problem occurs when other user want to log in using their username and password to view report using my pc. how to clear up the password saved so everytime they go into report manager, the...
    See more | Go to post
    • ciqeane
      replied to how to sum iif?
      in SQL Server
      many thanks to all. appreciate:)
      See more | Go to post

        Leave a comment:

      • ciqeane
        replied to how to sum iif?
        in SQL Server
        seriously i dont know how to sum iif. so i made a dataset for each GAS, LIQUID, OIL, OTH.
        a simple dataset, something like below:

        select sum(t_oamt) as Gtotal from
        temp_table
        where month = @month and year= @year and DanielProd = 'GAS'

        so i just sum the dataset value,
        Sum(Fields!Gtot al.Value, "Gtotal")

        Thanks all.
        See more | Go to post

          Leave a comment:

        • ciqeane
          started a topic how to sum iif?
          in SQL Server

          how to sum iif?

          Hi. i want to sum the iif value and i dont know the right way to do that.
          i attached the sample data in sum iif(zip file) please help me solve this problem....
          See more | Go to post
          • ciqeane
            replied to SQL case substring problem. please help
            in SQL Server
            oh my God, it works when i use the single quote!!
            thanks a bunch all.:-)
            See more | Go to post

              Leave a comment:

            • ciqeane
              started a topic SQL case substring problem. please help
              in SQL Server

              SQL case substring problem. please help

              here is the sample data

              Code:
              CREATE TABLE Boo (
keycol INT PRIMARY KEY,
datacol VARCHAR(20));

INSERT INTO Boo VALUES(1, 'DM/B19S/7281520');
INSERT INTO Boo VALUES(2, 'NW/L11U/BALL 10/300');
INSERT INTO Boo VALUES(3, 'RK/H11S/65-2511RK');
INSERT INTO Boo VALUES(4, 'FI/G21U/0004/BN5-12');
INSERT INTO Boo VALUES(5, 'FN/199U/FABRICATE');
              Here is my query, please help me figure out...
              See more | Go to post
              Last edited by NeoPa; Aug 19 '10, 01:05 PM. Reason: Please use the [CODE] tags provided
              No activity results to display
              Show More
              Working...