SQL Server

Page 1575




  • Topics
    Replies
    Last post
  • Question about Neural Networks
    by Yustos
    6 Replies
    Last post by Bogdan Crivat
      • I created a test table (name - "Nset") with the columns: id (int), n1 (float), n2 (float), n3 (float) and c1 (varchar). Then filled a table the followings information: id n1 n2 n3 c1 1 0,1 0,1 0,6 one 2 0,2 0,1 0,5 one 3 0,7 0,5 0,1 two 4 0,4 0,9 0,3 two 5 0,5 0,1 0,5 three And created a neural network with tuning by default. "id"-field
  • script component
    by smathew
    3 Replies
    Last post by Phil Brammer
      • i have 2 source columns testsource and testsource1 and 2 output columns test and test2 i am passing them through a script component to check if the columns are numeric or not along with some more logic...I am able to get the first column evaluated based on the logic but not the second column Is it that the script component can only look at one column this is the code i wrot
  • Adding child menus in Management Studio add-in
    by Shannon Cayze
    7 Replies
    Last post by yzguy
      • Hello all, I'm trying to write an add-in for the Management Studio that adds items to the context menu for certain objects in the Object Explorer. I know how to add an individual item when that item inherits from ToolsMenuItemBase, but how do I add child menus to that item Using Lutz Roeder's .Net Reflector I see that ToolsMenuItemBase overrides the abstract member AddChild but doesn't prov
  • Flat file connection manager not parsing file correctly
    by sadie519590
    2 Replies
    Last post by K108
      • Hi, I have a flat file, comma-delimited, with strings in double-quotes. In the connection manager for the file, I have specified that the Text Qualifier = "" However, in the preview tab, it still shows the strings as surrounded by the quotes, e.g. "mycol1" whereas it should show mycol1 without the quotes. Next, when I examine the data in the database
  • Calculated Member using CurrentMember.Properties("XX") does not work for ALL Level on a dimension
    by JuliusY
    3 Replies
    Last post by Deepak Puri
      • IIF ( [HAP5All_Board] .CurrentMember.Properties ( "Dept" ) = "PH" , ( [BoardIncAcct2].&[61510000] -- General Services + [BoardIncAcct2].&[61520000] -- Accounting & Financem Services + [BoardIncAcct2].&[61530000] -- Information Technology Services + [BoardIncAcct2].&[61540000] -- Purchaseing Services + [BoardIncAcct2
  • Rowversion as a history mechanism
    by PJFINTRAX
    7 Replies
    Last post by PJFINTRAX
      • Hello, I have a requirement to maintain a 'history' table beside a products table. Any time a row is changed (added/removed/updated) in product table I need to add a new record to the history table. I would be using a rowversion column in the products table. And would want that rowversion to be preserved in the data on the history table ... So I'm thinking I'd use a trigger etc..thats no a p
  • Backup DB to LocalMachine
    by Mohammed A.AboBakr
    2 Replies
    Last post by Mohammed A.AboBakr
      • alslamo alikom... hope u all be in a good health... ok...my problem that i have a client application that designed to adminstrate the DB server using SMO... now iam trying to backup the desired DB from the DB server which is another machine connected to the same network... i specified the file name and the DB name....and every thing runs smothly with no exceptions....but no file genera
  • Difference of two datetime columns caused overflow at runtime.
    by
    5 Replies
    Last post by Sujithf
      • I used this query to get a result select round(cast(DateDiff(ss, convert(datetime,rf.RECVD_DTTM), convert(datetime,con.ARRIVED_DTTM))/60 as float)/60,2) as LengthOfTime from customer rf but i am getting an error "Difference of two datetime columns caused overflow at runtime." Any idea
  • need help in 3 questions
    by Liquidloop
    6 Replies
    Last post by Liquidloop
      • Hi, Plz answer my following queries. 1. I need to get list of indexes, clustered & non clustered on a given table. I'm looking something similar to what we do for getting list of tables like select * from sysobjects 2. How can i specify table as a parameter. It would be clear if you could built me a query which will show number of rows i.e count for each table, list of each ta
  • Per-record processing?
    by jararaca
    2 Replies
    Last post by jararaca
      • Hi, I am looking for a way to process each record from a SELECT query. Each record has to go through a stored procedure to be validated and different actions have to be taken depending on whether or not it passes the validation. I'm a bit new to Transact SQL. My background is in programming, so I keep wanting to visualize a loop, which doesn't exist in TSQL, from what I understand. Can a
  • How to read sql tasks and so on from a package programmatically??
    by enric vives
    13 Replies
    Last post by enric vives
      • Hi everyone, Once I've accesed to package by means of LoadFromSqlServer method how to read its Sql Tasks, for example I'm trying with the Executables property but unsuccessfully results: pkg.Executables.Item(0) Thanks in advance,
  • Subreport visibility
    by nuk
    1 Replies
    Last post by Andrew - T4G
      • i want to display the reportheader and footer of a sub report from master report eventhough there is no data is populated for subreport.
  • Splitting single row of table in to two rows
    by DarshanAltekar
    2 Replies
    Last post by DarshanAltekar
      • Hi All, I was wondering is there any way by which i can split a single row in my table into two rows in my table in design of my report. In my table there are 16 rows i cant design table with 16 rows as it will increase size of my report body & it will give problem while exporting. Instead what i want to do is , design a table with two header rows first header with first 8 columns &
  • Changing location for transaction log directory
    by vamshi561
    14 Replies
    Last post by Deepak Rangarajan
      • Hi Experts, Can we change the transaction log directory to a different location If so Can any help to know how it is possible
  • how to control the distance between the two matrix? or (matirx and table )
    by younger
    2 Replies
    Last post by younger
      • hi everyone: the report show two tables two matrixs how can i control the distance between them I want to set the same distance between the table and matrix or (table and table )
  • Cannot Convert Char to Money
    by Mguvu
    5 Replies
    Last post by Mguvu
      • I've been trying to solve this problem or just find an alternative to do this. I have filled a temp table with certain values for all columns except those columns that rely on calculations that need certain cell values from other columns in the temp table. I have a while statement that runs through each cell for one calculation column and this is the code that updates the fields on the calc column
  • Longhorn Server, WSSv3, SQL Express 2005 and Forms Auth setup issue
    by David Rasmussen
    1 Replies
    Last post by Dr. Beetlejuice
      • I seem to be having a strange problem with accessing the SQL Express database under the following configuration. Install Longhorn Server Beta 2 Add WSS role, setup default site, everything seems to be working fine (using NTLM auth for the site). Content database clearly working fine to the embedded SQL Server Express. Want to switch to Forms Based Authentication with SQL Membership
  • "Error 233"
    by aanryn
    7 Replies
    Last post by aanryn
      • Hello, I'm using windows XP SP2 and I have installed SQL Server 2005 Standard Edition. I usually connect my SQL Server 2005 using windows authenticationmode and server name as default. I have a only one server to which 4 client machines are connected. When I'm connecting to my default server domain I get this message and I am unable to enter into SSMS "A connection was successfully establi
  • stored procedure problem using un quoted varchar
    by dsparks500
    6 Replies
    Last post by dsparks500
      • I have a stored procedure which returns a count of products and a limited number of rows from a query. I am using SQL Server 2005 and calling the procedure in asp.net The procedure is as follows Code Snippet GO ALTER PROCEDURE [dbo].[GetProductsByCategoryId] @Category VARCHAR(255), @Range INT, @PageIndex INT, @NumRows INT, @CategoryName nvarchar(255) OUTPUT, @CategoryPro
  • Date(only) and Time(only)
    by Ole Kristian Bangaas
    10 Replies
    Last post by MVP User
      • I was really expecting pure date and time datatypes to be in this CTP, but apparently there are not. It should be pretty simple to implement, given the fact that we already have the datetime datatype. However, it would save a lot of developers quite a bit of time. Are there any information why this isn't included Is it planned for a later CTP
  • connecting to sql server from mobile device
    by kamisama
    11 Replies
    Last post by Anonymous
      • How can I connect to sql server from a mobile device the server is on pc and my app is on the device. I want to perform commands and stored procedures which will be performed online on the pc and get immediate results. is there any way of achiving that
  • Matrix displaying data
    by Halden-VB
    6 Replies
    Last post by Halden-VB
      • I'm sorry if this is a stupid question, but this is my first matrix report. I am using a stored procedure that generates the following data: Item Color Size Qty Shorts Tan 32 0 Shorts Tan 34 2 Shorts Tan 36 2 Shorts Tan 38 0 The matrix displays as follows: 34 36 Shorts Tan 2 2 I would like it to
  • SQLSERVR.EXE & PAGE FILE
    by ZindrosH
    7 Replies
    Last post by mrdenny
      • Dear all, I would like to share with you the following strange behavior to one of my production servers. Some details: OS: Windows server 2003 sp2 Sql: SQL 2005 Workgroup edition 9.00.3042.00 Physical memory: 3.5 Gbytes No of users: 6-8 Min SQL memory: default Max SQL memory: default Application: Develp. platform STUDIO 2005, Visual basic 2 hard disks and RAID-1
  • Different instances of SQL Server
    by Fahd
    4 Replies
    Last post by Mark Benvenuto
      • Hi there, I was wondering if it's possible to create a new instance in the SQL Server something like this: (Local)\\MSSMLBIZ (Local)\\BUSINESS Thank you
  • Conversion failed when converting character string to smalldatetime data type
    by AngelinaPerez
    4 Replies
    Last post by Altana
      • Hi, I have SQL Server 2005 database table with the following data definition as follows: ID int LST_TIME varchar(5) LST_DATE varchar(21) LST_WEEK int SUBJECT varchar(100) Date format (Month,day YEAR) eg.- October, 21 2007 Time format, 00 - 23 hours, HH:MM eg. - 18:58 , and a VB code as below: Dim Command As New SqlClient.SqlCommand("SELECT * FROM dbo.LISTS WHERE (LST_WK