[microsoft:sql-server] Forum Topics

I have a table that has become corrupt and I need to merge the records back into one record. I have multiple records that should be recombined and I have hit a brick wall on this. In my table the data looks like this part_id Unique c_date m_date Qty ht_num …

I have 2 tables: a claim table and a corresponding date table. There can be multiple dates for each claim, with a qualifier type to distinguish them, and I'd like to retrieve them all in one row. Here's a snippet of what I have: [code=sql] SELECT d.PointerField , a.ApplianceDate b.AccidentDate …

I'm trying to install SQL2008.AdventureWorks_All_Databases.x86.msi, but whether I try to install "Sample Files" or "Create AdventureWorks DBs", I keep getting the following error: PrepInstance() failed for MSSQL$SQLEXPRESS. The following features are missing: Full Text Search I already have installed on my PC: Microsoft SQL Server 2008 Microsoft SQL Server 2008 …

hello,i want to display RTF (rich text box content)in crystal report,how i do ?i have a filed in db (sql 2000) that rich text box content stored in with image type,how display it in crystal report ?

Hi all, I have a program which connects to sql and uses crystal reports. I have many records and crystal reports takes a while to load up. Would multi threading help improve performance? Here is my code: [code]Private Sub EmpLog_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim …

Hi all, I am using SQLbulkCopy to transfer source data to multiple destination tables of SQL server 2005. I want to show the user - log file (text format) which data are transferred and which are not...how? please suggest! thanks jeet

i create an application in .net platform in which i connect sql sever and i retrieve data from dataset through datagridview and i have to make a task that if i edit in gridview it will save the changes in datasource

Hi All, How to add a [b]candidate key[/b] in a table in SQl?? Please Help. Thanks.

Hi, I have a combo box that takes its values from a database. I need to make unique items in the combobox. I could do this in database part, but I need other attributes of values. Let me explain: There is Surgery table in my database with id,name and clinic …

Hi, in MS SQL we have [B]TOP [I]some_value[/I][/B] clause which means that only some first records are selected. For example: [I]select top 10 products from table_products[/I] How can I select rows for example from 4th to 15th?

Hi I am totally new to crystal reports and i need to print invoices from C# with the data stored in SQL. Now i can retireve the data and display it in the report however, i cannot properly display it. The problem is that e.g. i want to print out …

I have "inherited" a series of scripts which are designed to run in SQL Query Analyzer to incrementally update a database based on a version id stored in a table. Each script includes code to create new tables, alter existing columns, add or swap out triggers, grant permissions, update data, …

hi I have some code of ADO.net to dynamically detect the database schema, [B]what I need is how to get Unique columns constraints and Primary key constraints using SqlConnection GetSchema() method.[/B] thanks

Hi, Recently i have been creating a Generator. That extracts all the names of the tables from the database tables and generates the class file for each of the tables in the database. I have successfully extracted the names of database tables and their corresponding column names with thier data …

Hi, looking for help and need pointing in the right direction, can anyone assist? Have a data file (txt) that contains 10000 numbers/data points. Storing the data file as varbinary(MAX) in an SQL table. My goal is to retrieve the file on user request and plot/chart the numbers as a …

I have 3 tables, below are their structures ( a bit of pseudo code ) I'm trying to update one table, with a variable column name, retrieved from another table [B]order[/B] [id,field1,field2] [I]example row ( '1' , '', '' )[/I] [B]produkt[/B] [order_id,produktnr] [I]example row ( '1' , '23' )[/I] [B]fields[/B] …

I have a INSERT, UPDATE trigger on a table, it works great and helps me from firing a stored procedure from all the (think it's over 50places) where it is needed. But I have one batch update to this table, that doesn’t require the trigger procedure; the trigger is very …

hi friends fetching datetime values from database, when data is null in code side it is displying the some garbage value instead that i want to show 'date is not found' the result is showind in grid view control service written for fetching datetime [code=C#] public List<Topics> GetAllTopicNames(int communityId) { …

hi, there, i am trying to connect the dropdownlist and gridview to the sql database. I am inserting radiobutton into the gridview. The whole thing goes like this, the dropdownlist is checked and once the radiobutton is checked, and clicked submitted, the next page must show only the checked data. …

I need to manipulate two tables(in different DB) to print out data, what's the effective way to do that in php code? [ICODE] $conn = mssql_connect($intraserver, $intrauser, $intrapass); $db=mssql_select_db($intradb, $conn); $result0=mssql_query("select a from tb1");// in $db for ($i = 0; $i < @mssql_num_rows( $result0 ); ++$i) { $line = @mssql_fetch_row($result0); …

hi i have retrieved data on data grid from backend. i want to write a code with which i will be able to retrieve the complete data related to the editable field from backend to front end. The edit and delete button needs to be seen on the right click …

A friend of mine programs in php and ruby. But we were talking about our projects and I brought up how I don't do much database type applications because I find it boring. And we somehow got on the subject of SQL. This is more of a discussion question, as …

Hi everyone, A few days ago I posted a question which someone did reply to. However, the tables have been re-arranged a bit and I didn't want to make my last thread confusing, so I thought I'd start fresh here. (Mod, you may close down my other thread; thanks). So …

Hi all, I want to send mail attatchment from SQL server. I have a Image field and i have stored word documemts in it. I am designing a form where an Email has to been sent with(attatchment) the word documents in the image field. So, i am looking for code …

Hi, I need to send an email which has an attachment; the attachment is stored in sql server-2005, in a table as an image data type. Thanks

Hi, Anyone,please help me out.How to give ODBC Connection on Centos5.5(linux machine) and also what do you meant by FREETDS? Thanks in advance............... with regards, santhanalakshmi.

i am doing a program to block ip address . First i import the list of ip address from 2 table of sql database. Then the third datagridview will show the ip address that difference in the 1st and second datagridview. Here is what I have so far... [CODE] using …

hello, can anyone tell me how to randomly pick entries from a database using ASP.NET as front end and SQL SERVER as backend ? i have written select * from table order by rand(); but instead of picking entries randomly, it simply displays the entries in the same order as …

Hello, While working with stored procedures I came across something I didn't know how to handle. I wanted to make a stored procedure where, One could give it 2 parameters. With these two parameters, it would return the uniqueidentifier of the row that matched, or if no match was found …

I am designing a pocketpc app to manage service delivery at restaurants. I have designed the interface of the app and defined the schema of the database using a Microsoft SQL Server Compact 3.5 database file. I cannot figure out how to interact with this file tho, I'm using vb …

Hi all, I want to display path(Path of a word Doucument file) stored in a Table (Sql Server 2005) in FileUpload Control through coding. Please Help me. Thanks ! Pankaj

Hi, I am trying to schedule a python compiled file to run using windows scheduler. But it does'nt run successfully The script writes to a SQL server database installed on the same machine as python and the script resides on the same machine. The script imports the urllib, sys, threading, …

Greetings All, After recently being laid-off I'm looking into some government funded training. They will pay for me to take a course with any local college so long as I have a diploma or cert within two years. One that stood out to me takes 10 month and leaves me …

This may seem like a simple question but I for the life of me cannot seem to get this working. I have an ASP page that I need to set a dropdown box to a value from sql. I have the dropdown getting filled from sql no problem. [CODE=c#] private …

Regrading to the topic can anyone help me about this and give me some example code for add and update data to ms sql 2000. I'm using the ADODB connection for the vb program! Help me i newbie on it. Please!

I am wondering if anyone can point me in the right direction so I can save the returned identity value from one of my stored procedures. How can I save it into a variable. Any help or examples is appreciated thanks!

Hi everyone, I've never had to do this before sooo, I need help. I have a table which maps managers to regular employees. So you could say that Manager A is mapped to 20 peeople and Manager B is mapped to 5, and so on. So the table looks like …

Hi, I've got 2 columns of numbers and need to divide the SUM of COLUMN 1 by the SUM of COLUMN 2. I've tried [code] (SUM(col_1))/(SUM(col_2)) [/code] AS col_3 but this doesnt work. Please help. Kind Regards Asil

Hi I want to store value from a row into a variable. I have used the following coding but it is not working properly. It is generating the following error: [B]Index was outside the bounds of the array.System.Data[/B] Please note that the table contains only one row. [code] objSqlConnection.ConnectionString = …

Hi I use the reporting services to generate the report.I use query like "Select Distinct(ID) from Table1".In that query Its generate the number of ID ,So In report user able to several "ID" at one time,so I think if I can use combo box then user can select ID which …

Hi I am developing an application (using C# and SQL SERVER 2005) for calculating fine in an library. The fine calculated should not included Sundays. I have used the following code to calculate the fine. But the code includes all the sundays and hence Fine is charged for all the …

This thing is really getting me in trouble. If any have any idea please share [B]Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "extra" reported an error. The provider reported an unexpected catastrophic failure. Msg 7343, Level 16, State 2, Line 1 …

Hi All, How can I accomplish splitting of data(string). For eg, If I want to split the 'Date Of Birth' ( given in the format dd/mm/yy) into its constituents dd, mm and yy separately. Specifically, I have a DOB field in my database(sql) and in the form, I have three …

[B]How i save Picture 'BMP File' in Sql Server Image Field, Plz send me full Code in VB.6[/B]

Hallo i'm Rinning an application with a sql database on pc1 it works fine but if i install the application on another pc i can't connect to the database i'm using SQL Server Management Studio Express 2 setup the connection but i cant find the 2nd pc where the data …

Hi can i use the if else statement to decide on the information go to specific tables that i create?? The form that have fill up will be send to the table 1 or table 2 that i created at ms sql 2000 base on the user write active or …

Hi all, There is a (I assume) simple query i cannot figure out (in a best practice way). Let's say I have three tables: [LIST] Users[/LIST] [LIST] AOI (Areas of Interest) [/LIST] [List]Users_AOI (Simply containing userId and AOIId for all interests for each user)[/List] So far so good. Now I …

Hi All, I want to know how to bind data to DataGridView Control. I have seen examples on google nd other sites. but all examples use DataBind() while in my program, it shows DataBindings() in intellisense. I cant find out how to do this. I have to bind data from …

I've been a member since February and this is the first thread I have created -- now I finally get to see where that solve button is! Anyway on a more serious -- who maintains the code templates for daniweb's programming forums? I post a lot in the C# and …

hi, there, i am doing a and it needs login page. I have a 2 textboxes, one for user id and the other for password. Using this two textboxes, I need to identify the three roles that i am using. This includes manager, delivery boy and customer to redirect to …