SQL Server

Page 4464




  • Topics
    Replies
    Last post
  • Matrix and column and row based averages without using avg()
    by Ross B.
    2 Replies
    Last post by Ross B.
      • A A A A B B Avg. Name 1 2 3 4 1 2 xxxxxxxxxxx 12/16 90 100 85 10/8 100 -- xxxxxxxxxxx 20/16 93 5/8 100 -- xxxxxxxxxxx 16/16
  • Input flat file is - truncate extra data
    by Linda Cornerstone
    3 Replies
    Last post by Linda Cornerstone
      • I am using the flat file connection manager. I read in a set of flat files and copy them into a staging database table. I want to ignore anything in the text file past column 266. I can't get this to work correctly. I can't define the last column to end at 266 and ignore the rest. I tried adding an extra column but that did not work either. Linda
  • Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
    by Manoj Verma
    3 Replies
    Last post by Matt Masson - MSFT
      • i have a sequence container in my my sequence container i have a script task for drop the existing tables. This seq. container connected to another seq. container. all these are in for each loop container when i run the package it's work fine for 1st looop but it gives me error for second execution. Message is like this: Distributed transaction completed. Either enlist this session in a new
  • LDF Info
    by Mystagogue
    2 Replies
    Last post by Michael Hotek
      • I used administrative services to shutdown my SQL Server 2005 service...and then I copied an mdf file the service had managed to a different server (I did not "detach" the mdf before shutting down the service - I figured the "detach" would be implicit in the service shutdown).  When I tried to have the new server attach the mdf with Management Studio (minus the ldf which I did not cop
  • implement manual replication between two SQL Server 2005 Express?
    by ste72
    5 Replies
    Last post by Andrea Montanari
      • Hi, I need to synchronize the data between two SQL Server 2005 Express. The database is really simple, just few tables (but data are inserted very often) without any triggers. Since Express edition could not behave as a Publisher I was thinking about implementing manually a sort of Replication mechanism... It should be a sort of Transactional Replication with queueud updating. Does it sound a good
  • Cell reference in SQL Report
    by Perm
    2 Replies
    Last post by Perm
      • Hi, Is it possible to use Cell reference in the calculations, in SQL reports. Like Excel allows "=A1 * B1", where A1 and B1 are two cells with some numeric value. Is it possible to use Cell reference in SQL reports Like "textbox1 * textbox 2"... or something like that, with textbox1 and textbox2 containing some numeric values. Thanks Perm
  • Replication Issues
    by Macho
    2 Replies
    Last post by Macho
      • Hi, I have created a publication in Microsoft SQL server 2005 and the publication credentials are used by an application targeted for a windows mobile 5.0 which using RDA pulls the data from the Master data file and creates a local symbol data file, the first part is working fine, i.e RDA pull from Sql Server 2005 to the SQL CE, Now i am trying to add features where in the changes made
  • I need help with a SQL Query
    by Chicken Leg Willy
    3 Replies
    Last post by Chicken Leg Willy
      • I know that there's a lot of you out there that are really good at Sql Queries. Hopefully, one of you will have pity on me and clue me in. I am working with a Visual Studio 2005.net VB application accessing SQLServer 2005 and SQLServer Express databases. I am using a sql query with ado.net data adapter to return data to a grid bound to the data adapter. My problem is that there is data in th
  • Time zone conversion
    by sandy_1
    5 Replies
    Last post by sandy_1
      • Hi, My sql server 2000 database stores the date in GMT in the tables, is there a simple query/function that I could use in a query that converts the date column values from GMT to EST/PST Thanks
  • Backup with CHECKSUM operation...
    by monk3yatthekeyboard
    3 Replies
    Last post by monk3yatthekeyboard
      • Looking for some clarification on the CHECKSUM option of the BACKUP command. If the the CHECKSUM option is specified in the backup, will the backup fail if CHECKSUM finds bad values (or at least raise an error) Or, is it only reported when doing a RESTORE VERIFYONLY Thank you.
  • SQL Server Process steals RAM
    by Torsten_Katthoefer
    2 Replies
    Last post by Jerome Halmans
      • Hi there! I've a problem, what seems to be a Bug... I've a Win 2003 Server, 64Bit, Enterprise Ed., SP1 on an Intel Xeon CPU 3,2 GHz, 8,00 GB RAM with physic. Adressexp.. Furthermore, i've a SQL Server 2005, latest Service Pack (9.0.3042). When i restart the SQL Server, i've aprox. > 7GB of free RAM (showed in Task Manager). At night, a few SSIS-Pakages run, and in the morning,
  • Data Not Copying to MS Access Table
    by cdun2
    6 Replies
    Last post by cdun2
      • Hello, I have a Data Flow Source that uses a SQL Command to pull data. In the SQL statement, I used CAST to change all varchar types to Nvarvchar to suit MS Access. I can preview the data from the source. In testing, the SQL statement only pulls about ten records. I have a Microsoft 2000 Access database table as a destination. Data in each column in the table is required, and all columns
  • Product of a Field
    by Volatility
    2 Replies
    Last post by Shyam Sundar
      • Hi All, I have a field with numbers (double datatype) as values and I want a aggregate function that gives me the product of all the values in that field. Is there a way to do that in SSRS
  • Restore readonly filegroup sqlserver 2000
    by Stijn Fonck
    2 Replies
    Last post by Stijn Fonck
      • Hi, I have a database running on sqlserver 2000. This database (let's call it TestDatabase) has 2 filegroups called 'PRIMARY' and 'SECONDARY', and is bulk-logged. The 'SECONDARY' filegroup is set to readonly since no data gets changed there by the applications, it is read-only data. Sometimes this read-only data needs an update, so I need to update the data in the 'SECONDARY' filegroup by r
  • Print Query
    by BilalShouman
    7 Replies
    Last post by Louis Davidson
      • Hello I wanna ask if there is a procedure that prints out a query result example : exec sp_print 'select * from test' Is there sthg like that Regards
  • declaring a sql query to a variable...
    by dottedquad
    3 Replies
    Last post by Louis Davidson
      • Hello all! After I declar a variable how would I set the result of a sql query to the variable so i can utilize it further in my stored procedure -Thanks, Rich
  • Email task - no error - no mail
    by Dhanasu
    12 Replies
    Last post by Dhanasu
      • I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this
  • Timeout Expired
    by Amir Ayub
    24 Replies
    Last post by Amir Ayub
      • Hi, Can someone help me on this When I run simple select query "Select * from Aadata" it works but when I filter with date it doesn't work please see below error: Error Source : .Net SqlClient data provider Error Messge: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding I fixed connection propert
  • Grep / Harvest / Extract the SSIS SQL Commands
    by Dotnet Fellow
    8 Replies
    Last post by Dotnet Fellow
      • Is there a way to programmatically, or in an automated fashion, pull out, that is extract or harvest, all of the SQL Commands contained in SQL Server Integration Services (SSIS) Packages, and place them in one easy-to-read file for further optimization analysis Is there a way: A) To pull these SQL SELECT's and other SQL Commands from the SSIS .dtsx file(s) B) To pull these SQ
  • Passing multi value parameters to CreateSubscription
    by Cato1969
    8 Replies
    Last post by Cato1969
      • Hi folks, I am trying to create a SSRS subscription from an asp.net app. I collect the parameter values from the client and make the arrangements to send them to the CreateSubscription method. When the report has single value parameters, my code works perfectly. But if there is a report param with multiple values, I get the error System.Web.Services.Protocols.SoapException: Default value or
  • Multiple Columns Index/Key (does it free me from creating a single column indexes???)
    by Ran Kizi
    1 Replies
    Last post by Alle
      • I hope i'm in the right place, but thanks anyway.... Actually i have 2 questions (regarding sql-server Indices/Keys): 1) I have an index, which is consisted of 4 columns. I've read elsewhere that this index functions (as well) as an index (single column index) on the first column of this multi-column index. Does this mean that if i'd like to have (in addition) Indices
  • Some very blurry questions I really need answers to!
    by Peter_J0nes
    4 Replies
    Last post by Arnie Rowland
      • Hello all, I recently started learning SQL 2000(70-228)in hopes of getting a certification, after having ordered the nuggets for this and reading through the official microsoft book I am doing some tests I found online. But here's where my problem starts, some of these test questions go against what I think I just learned. To give you an example, check out following screenshot,
  • Time changing data
    by jk_uk2
    4 Replies
    Last post by jk_AnalysisServices
      • Hi, I have a 2005 cube with, amoung others, and Account dimension and a Time dimension. The time dimension is the fairly standard Year->Quarter->Month->Week->Day etc, with Day being the point at which I load data. In the accounts dimension I have a member called Cost Rate, where I hold a 'day rate' that represents an employee's cost on a daily basis. Unfortunately this Co
  • How to change the default Dateformat for Database
    by Guri
    1 Replies
    Last post by Caddre
      • Hi, I want to change the default date format from 'mdy' to 'dmy'. I can do this for session by using SET DATEFORMAT 'dmy' but I want to this permanent on Database level (p referred ) or SQL instance level how can I do this Thanks in advance
  • Adding mutiple columns
    by Rajesh_M
    10 Replies
    Last post by hunchback
      • HI, I have two tables A and B with following Data Table A ------------ ID(PK) | V | W | X | Final ---------------------- 1 | 4 | 5 | 6 | output Table B ------------ ID | Par_ID (FK) | Cost_Per_Annum ------------------------ 1 | 1 | 12000 2 | 1 | 24000 3 | 1 | 14000 Output should be calculated using below the formula . output = Column V * 1st record of par_id=1 + Column w *