SQL Server

Page 2908




  • Topics
    Replies
    Last post
  • How to delete rows in tables...
    by sdj_dk
    14 Replies
    Last post by Barry Andrew
      • I need to delete some rows in some of my tables after tranfering data from my OLTP to SQL database. Im using SQL 2000 I have tried with the following: Delete from fsalesinvoiceline Join dsalesinvoiceheader on Fsalesinvoiceline.salesid= dsalesinvoiceheader.salesid and Fsalesinvoiceline.company= dsalesinvoiceheader.company Where dsalesinvoiceheader.billtocustomerno=¡¯IND
  • Maximum height for table
    by bwags80
    10 Replies
    Last post by bwags80
      • How do I set the maximum vertical size of a table I would like to set it based on total vertical size in inches or a maximum number of rows returned. Thanks for any help. Brad
  • any *simple* external activation examples available?
    by B_W
    1 Replies
    Last post by Rushi Desai
      • BOL only seems to say that you can do it w/o really showing how, and the ExternalActivator sample at gotdotnet.com contains so much functionality I'm not sure what's required just for the external activation. Are there any docs or samples out there that focus on how to do it w/o obscuring the matter with a bunch of other functionality (I prefer docs to project samples, b/c the samples tend to have
  • My SSIS problems
    by TheViewMaster
    13 Replies
    Last post by Jamie Thomson
      • There are things I just don't get about MS programming: 1. Text file source - recognizes column as "database date [DT_DBDATE]" - but not able to process it as date - values like "2006-12-06T13:16:04" 2. When using import export wizard - it errors out when trying to transfer large amount of rows (40 million) - 1st time out of space error - but the db is in simple recovery model
  • Filtering Problems
    by Larry Fortner
    1 Replies
    Last post by Shyam Sundar
      • I am stumped on what is probably a simple glitch. I have an SSRS 2005 server report based on a stored procedure dataset, which accepts a single parameter. The parameter value originates from a session variable when the user opens the aspx page containing the reportviewer control (Visual Web Developer 2005). I've configured this parameter as a hidden parameter in the RDL design. In this configur
  • Data from Derived Table
    by Duncan McC
    1 Replies
    Last post by Manivannan.D.Sekaran
      • I am looking to run two different queries. the first one returns about 6000 numbers. i.e 123454, 15432, 2343545 etc My second query i want to use the results from the first query as a where clause i.e where Number in ( '123454' , '15432' , '2343545' ) Clearly i dont want to type out 6000 numbers in a query. How do i use the data generated in the first query as
  • Cannot load Data Flow tasks
    by CodeDigger
    2 Replies
    Last post by Subhash Subramanyam
      • When I copy over an SSIS package I have been developing from my laptop to my desktop with Windows File Sharing (shared folders) across a home network, the moved package fails to load properly. I can see the Control Flow tasks but not the Data Flow tasks - they simply disappear! I have update the Connection Managers to point to the new machine, and tested them (OK). Its the same as this is
  • SQL 2005, OPENQUERY and security context switching
    by Bobo1234
    1 Replies
    Last post by Raul Garcia - MS
      • Hi, I need to allow only a specific group of users to use a linked server. Rather than granting each user access in the linked server I create and give access to a local SQL login "link_user" and then grant the group impersonate to "link_user". The folllowing statements then work fine: EXECUTE AS LOGIN = 'link_user' SELECT * FROM OPENQUERY ( link
  • Linking Oracle view to SQL Server express
    by Stara
    3 Replies
    Last post by Mike Wachal - MSFT
      • Hi, I was able to link SQL Server Express to Oracle views using Linked Manager. However, when I run the query, the performance is very slow. Is there a way to improve performance in querying Previously I was using Access to link to Oracle view. But the performance is not good. Takes about 8 hours for approx 6000 records. Thanks a lot, Stara
  • Query problem involving DateTime column
    by shahrul
    12 Replies
    Last post by shahrul
      • Hi all, I am quite surprise by getting wrong resultset from a simple query like: select Order_No from Delivery_Order where cust_id = 5 and do_date >= '6/15/2008' and do_date <= '6/31/2008' In the database, there are data since the last two years. There is no data beyond today's date, in fact. But when I tried to query for 'Order_No' with specifie
  • Pivot fields into a single column
    by WVUProgrammer
    8 Replies
    Last post by hunchback
      • I have a row that looks like this Year 2006 2007 2008 2009.....etc. I want a select statement that will get me this Year 2006 2007 2008 2009 etc.
  • Access project connecting to SQL 2005
    by curt760
    7 Replies
    Last post by Anonymous
      • Most of our users are using MS Access project to work with our data in SQL Server 2005. The problem we have is that in order for them to access the tables they need to be given db_datareader and db_datawriter permission on the database. Our goal is not to give access to the tables themselves but to views. Therefore, we've created several views and placed them into a particular schema. Now we want
  • Filters - Report Builder
    by Surkot
    2 Replies
    Last post by Surkot
      • I have created a report showing both first name and last names with the following filters. Both of them are prompted parametres Last Name Contains ------------------ First Name Contains ------------------ When users enters both then we get the results back. I want the first name to be optional such that if user enters something for the first name then take it into the search criteria else show al
  • Connection Managers Area not coming up
    by mamidi
    3 Replies
    Last post by Phil Brammer
      • When I brought up the BI DEV studio first tiem the Connection Managers area showed up, but after I closed it by mistake from next time on wards it is not coming up. Can some one from this form help me how to get the Connection Managers area(pane) back Thanks in advance. Regards Mamidi
  • How to make this query...
    by raindm
    11 Replies
    Last post by raindm
      • Hi all. I have tried making this query for a while and i didn't manage to. I know it is something related to JOIN, but i didn't manage to make it work :\ I have two tables. Table1- db_stockprices Table2- db_stockSymbols db_stockprices is getting updated every day with stock daily prices. db_stockprices looks like: ID, SymbolID, Price,Date 1 1 3
  • What is the best book to start from scratch?
    by Douglas_W_Roberts
    5 Replies
    Last post by Brad M. McGehee
      • Hi - I have tried several times to get started with SQL Server (I think I downloaded SQL Server 7 2005), but everytime I do there are so incredibly many steps to get started that I end up not going any further. This has been going on for longer than I wish to admit - but it is a very long time. Isn't there some straightforward set of instructions that I can use to get started What I want to do is
  • Mirroring on separete domains
    by Merovingian6532
    1 Replies
    Last post by Arnie Rowland
      • We have 2 servers each having a domain (i.e. 2 domains) running Windows Server 2003 Standard Edition Service Pack 1 We would like to have one of the servers replicate/mirror the data on to the other but we are getting this error The error produced from the mirroring part is: TITLE: Database Properties ------------------------------ An error occurred while starting mirr
  • Trigger with access to remote server
    by jakub78
    6 Replies
    Last post by jakub78
      • Hello, i have two server connected to internet S1 and S2 (connection between both is only internet too). I need write trigger on S1 which send update or another command to S2. Is it possible, and how (without using .NET methods only by using Transact SQL) Thnx, jakub.
  • problems at beginning of set up
    by chris445
    9 Replies
    Last post by enizin
      • Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft. I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after
  • Trigger?
    by Hassano563658
    6 Replies
    Last post by Madhu K Nair
      • Hello Team i want to make a trigger to delete the orderdate when inserting the record ( if the orderdate is 1/1/1900) Thanks lot
  • Report connection fails with DNS name
    by techuser08
    2 Replies
    Last post by techuser08
      • Hi, I am facing problem while setting connection string in Report Service project. Problem is when I specify DNS name instead of machine name as the Server in the connection string. When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection" Also I am not able to view re
  • Creating Stored Procedure in SQLServer2005
    by Sirenetta
    7 Replies
    Last post by Lisa Nicholls
      • I have been using SQL Server 2000 and creating Stored Procedure. I need these Stored Procedure to create Reports in Crystal Reports. In SQL Server 2000: it is very simple to create a stored procedure: Go to Enterprise Manager->Databases-> Choose a database-> stored procedure->New-> Simply Add to the following syntax: CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS GO My pro
  • Secure a single SQL Server database + Make float fields encrypted
    by Nicolas Iacovides
    3 Replies
    Last post by Arnie Rowland
      • Hi all, I am developing an application for a big office which uses SQL Server 2000. Apart from my database, on that server, there are two databases by other companies. The administrator also has access to server but the client only wants him to backup the database. I have two questions: 1) First of all (if it is possible) I would like to protect my own database from the other companies.
  • Stored procedure assembly Error
    by Aaabbbccc123
    5 Replies
    Last post by nielsb
      • Hello there, I am having trouble with the following and appreciate any help.Thanks in advanced. I have created an assembly to delete records in exchange (which works fine when testing it in debug mode). I then create the assembly in SQL server 2005(tried both unsafe and external access btw), and then i create a stored procedure calling the assembly. Now my error occurs when i try to execute this s
  • Referencing a conditional column in the WHERE clause -- Possible?
    by Justin_CGI
    2 Replies
    Last post by Louis Davidson
      • I have two tables which I'm joining in a query. In the join, I'm creating a column whose value is conditional (see columns Actual_Latitude and Actual_Longitude below). Is it possible to reference the created column in the WHERE clause Consider the following query: