SQL Server

Page 4901




  • Topics
    Replies
    Last post
  • How to get the meatdata of a result set
    by Ricky Wang
    6 Replies
    Last post by Ricky Wang
      • How do I get the column names of result set returned by "Select * FROM t1" I am using ASP.NET library (SqlCommand for example) to issues this SQL statement. Thanks, Ricky.
  • Drilldown on Related measures: Calculations in DSV
    by Vijay R
    5 Replies
    Last post by Vijay R
      • Hi, I have a strange requirement, although there is a workaround that I have thought about , it quite does not satisfy what I need. Here is the scenario: I have about 200 calculations (basic arthimetic with maximum of 10 members). I have created them in the DSV as named calculations. The calculations involve other members of the DSV. We tried using calculated members but the performance beca
  • Layout question. "If" statement to determine formatting.
    by Sinh
    3 Replies
    Last post by vsankarv
      • Is there a way to setup a field so that if it equals 'Yes' then it highlights the row. And if its 'No' it leaves it in plain text. If this possible
  • running ssis package with ssis run time compoenents and sql server 2000...
    by paruchuri
    12 Replies
    Last post by CedricL
      • running ssis package with ssis run time compoenents and sql server 2000... Is it possible to run ssis packages that point to servers on sql server 2000 without installing sql server 2005 Can we just install runtime for ssis and run the packages Please explian with links if possible thanks a lot
  • Data Mining books
    by Helen999888
    3 Replies
    Last post by Helen999888
      • Hi, all experts here, Thank you very much for your kind attention. I am wondering if there are any recommended books about data mining techniques (algorithms) and their applications in different industries. I am looking forward to hearing from you and thank you very much in advance for any help and advices for that. With best regards, Yours sincerely,
  • Sum and divide - Not so easy
    by Rick582224
    0 Replies
    Last post by Rick582224
  • Report Model: Drill on calculated field in Report Builder
    by Araki66
    1 Replies
    Last post by Bob Meyers MSFT
      • Hi, I've created dsv that contain all fields from table database. in the smdl I've remove some fileds due to security. All fields in the smdl do not contain drill. Issue: When I created calculated field in the report builder the field has a link. When I clicked the drill I saw all the record data including field that not in the smdl. Questions: 1) Can I remove the link from the calcula
  • SQL Agent 64-bit Issue?
    by Rotscher
    8 Replies
    Last post by JayH
      • Hello I have also an x64-bit environment (Server 2003 R2; Sql 2005 sp2) The package run well in the BI Designer after changing the run64bitRuntime Property. I used the following script in the Sql Agent Job Command Line to automate this package: C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe /f "C:\Projects\Test\Test\Test.dtsx" /MAXCONCURREN
  • Update Package to save new property values
    by tviel
    10 Replies
    Last post by tviel
      • Hi, using custom tasks. My properties got saved properly the first time the task is added to the workspace. After that, changing values in the CustomUI updates the properties, but the package shows, that It doesn't need to get saved. So my properties don't get changed in the package XML. Moving my custom task on the workspace after changing properties, let the package go into "save me" state an
  • SAN Performance
    by Andy Fordyce
    3 Replies
    Last post by WesleyB
      • I have a situation where a client is experiencing performance issues with our application which heavily relies on SQL. We have a very large table that has heavy fragmentation, so to ensure this is rectified first before exploring other performance related issues we have decided to rebuild the index. We have had to allocate additional storage to attempt this by adding 3 LUNs (500gb each) + 3 additi
  • Passing parameters to SSRS report 2005
    by Srik
    4 Replies
    Last post by Salvo0194
      • Hi, From a aspx page I was able to Pass values (valid values) for the parameters to SSRS report 2005 which uses OLAP cube as datasource and got back the expectd result. but when I pass value other than a valid value i am getting ERROR message. do we always have to pass valid values only any help is greatly appreciated. Thanks, Srik
  • venn diagram?
    by scb2376
    0 Replies
    Last post by scb2376
      • Is it possible using reporting services to create accurate venn diagrams (here's what venn diagrams are: http://images.google.com/images q=venn+diagram&hl=en&um=1&ie=UTF-8&sa=X&oi=images&ct=title ), with real data (as opposed to the out-of-the-box images in word, excel). So the data source would feed back the # of elements in set A, the # of elements in set B, and then the
  • Label in parameter
    by Cissi
    2 Replies
    Last post by Cissi
      • Hello! Is it possible to create a row of "labels" in a multi-value parameter list i mean something like this: Name, Age JJ, 12 PP, 10 Thanks //C
  • Page break in middle of a group.
    by EricRH
    0 Replies
    Last post by EricRH
      • I have a report that has groups. I'd like the report to do a page break if the group is going to be split by a second page. Any ideas on how to do this
  • Using .Net Script as Source
    by anj755
    9 Replies
    Last post by anj755
      • I have a word document that I need to open in .net and then use every line of that file as a row for my input. I have decided to use SSIS package to do it. I have found plently of help to open word file extract the line, but I am unable to understand how I would use the script task as source and add rows so that the column used as output can be used as source.
  • DTS activeX script...please help begginner
    by airwalker2000
    8 Replies
    Last post by airwalker2000
      • Hi there, im using this vb script. '********************************************************************** ' Visual Basic Transformation Script '************************************************************************ ' Copy each source column to the destination column Function Main() DTSDestination("SES_STATUS") = DTSSource("Session Status") DTSDestination("SIT_ID&quo
  • Bug, Can not create varchar(max) columns with SMO
    by evrenokcu
    9 Replies
    Last post by bkejser
      • I just want to create a varchar(max) column with SMO. My code is as follows. Instead of varchar(max), a column with datatype varchar(1) is created!!! Table t = new Table(db, "t1"); t.Columns.Add( new Column(t, "c1", new DataType(SqlDataType.NVarCharMax))); t.Alter(); That seems to be a bug of release version. I don't face this problem in Beta 2 Is there a workaround for that problem
  • Dynamic capabilities with Parameters
    by VDeepak
    6 Replies
    Last post by Hammer2
      • Hello all, I have a winform application, where in we get the parameters from the reporting service and we display them in a panel for user's to input their criteria. So far everything worked good, but now we have a requirement wherein dynamic functionality is needed. For Example: Based on a selection of a combobox value, we want the other control to be enabled or disabled. Also we want
  • How do I use Group By to get top rows?
    by JerPC
    3 Replies
    Last post by Steve Kass
      • Okay, I am sure this is an easy question, but for some reason I cannot wrap my brain around it. I have a table that has data similar to the following: IPAddress VisitDate URLVisited 192.154.21.554 9/18/2007 http://www.microsoft.com 192.154.21.554 9/19/2007 http://www.google.com 164.21.124.23 9/19/2007 http://www.microsoft.com 192.154.21.5
  • Select full rows depending on distinct date
    by swemaniac
    7 Replies
    Last post by DaleJ
      • Hi Say I have a table with columns 'id, date, title, text' and in order to display a list of 'month year' I need to select rows with distinct month & year of the date component. I can select distinct year & month components by doing this: select distinct convert(varchar(7), date, 111) as date from posts but how do I return the other columns as well Regards, Johan
  • Send Mail Task not updating the "ToLine" property dynamically
    by AVNIP
    4 Replies
    Last post by jwelch
      • Hi, I am facing a very strange issue with the Send Mail Task: I am fetching the recipient from a Recordset and storing it in a variable (MailList). Now, I modify the Send Mail Task to include an Expression which updates the "ToLine" property with the email address in the "MailList" variable. Moreover, I am not hard-coding the "To" property in the &qu
  • How to convert Dynamic Properties to SSIS Package Config?
    by Jerry8989
    14 Replies
    Last post by 13Cats
      • I'm currently trying to convert over packages from SQL 2000 to SQL 2005. The biggest obstacle at the start has to do with converting my "Dynamic Properties" control. I use it to read an .ini file and load the user name and password to my connections. With 2000 it's nice and easy 1 file 3 lines. While trying to convert it I¡¯ve had nothing but problems. I've tried the Registry Entry but it
  • Getting content of a Query
    by PhongSon
    3 Replies
    Last post by Arnie Rowland
      • Hi all! I'm working on a project about SQL Server 2005. And, I want to get the content of a query executed on SQL Server 2005. So, is there any way to do that i'm stuck.:(( Thanks!
  • SQL server 2005 JDBC driver
    by Li556035
    6 Replies
    Last post by Sudhansu Tiwari
      • Hi Do we have to use SQL server 2005 JDBC driver to connect the sql server 2005 I got sql server 2000 driver for JDBC, it works fine to connect the database. But when I use sql server migration assistant for oracle, i got an error saying: [sql server 2000 driver for JDBC] Error establishing socket. Do I have to download SQL server 2005 driver for JDBC or I miss something else Thanks
  • SQL Dependency
    by LCoder
    6 Replies
    Last post by CHJ3
      • Hi! Is there any way to use the sqldependency feature from ADO.NET with SQL Server Express editation I need this feature but I develop a shareware application and I can't buy Professional or higher SQL server for every downloaded copy. Thanx.