[microsoft:sql-server] Forum Topics

Hi, A while back you guys helped me make a query that returns all clients that have not made a payment in 90 days. this works good. I now want to exclude those who have never made a payment. I tried to add in [CODE]Exists (Select Receipts.DateReceived from Receipts)[/CODE] but …

I have dates and times stored in the database - the data type of DateTime (for example: 17.1.2010 16.23.34 - dd.MM.yyyy hh.mm.ss) The parameter which I define it has too look ONLY of date ("dd.MM.yyyy"), because I want to get all the values on a specific date and the sum …

I am writting an application in VB using VS2008 and SQL2005. I would like to save an array to my database and later retreive it. I understand that I need to serialize the array to do this but don't understand the process. I have looked at various resources on the …

Good Day All i have the Following sp [CODE]SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_Timetable_View] @selectionType varchar(30), -- either Venues, Staff, Subjects, Curricula etc... @selectedItems ntext, @selectedTerms ntext AS /*This Part of the code was Representing the Sp Get_Staff_Cycles_For_TimeTable due to temp table scope , i …

I have a store procedure in which i need to get values from another procedure, so i called it and tried to insert in table variable. but i got the "An INSERT EXEC statement cannot be nested." error message. anyone please give solution as i've already spent 2 days searching …

[icode] Hi all there, I need your help in my project of "online examination”. I am developing this for my lab. frontend: ASP backend: SQL Server 2000 Now the requirements r: 1. I have to generate papers which randomly select 100 MCQs from table and displays on client computers. The …

Dear all. I want to store csv file via sql sever and access the csv file for bulk import option,give me some example procedure that very useful to me. somebody help me.. Venkatesan.P

Dear Sir, SQL SERVER 2005, Table1 has data as follows Date----------sno----------name 14/01/10------1-------------A 14/01/10------2-------------B 14/01/10------3-------------C The Primary key is on SNO I want to apply primary key on sno+date columns I want to enter sno on daily basis as 14/01/10------1-------------A 14/01/10------2-------------S 15/01/10------1-------------D 15/01/10------2-------------U I want to use these codes before inserting …

I purchased a book that included an evaluation version of 2008 enterprise. I had downloaded SQL 2005 express and had tried to download 2008 which said it succeeded and I was left with 2005. I checked the OS list of supported ones. XP professional is on the list. XP home …

Hi, I want to run sql script from patch file I found how to run script file using sqlcmd but I don't want to run it from file I want to put the sql code inside the patch file

Actually i want data from database in DataGridView, OnLoad of Form. I have write this code but this is not working. I have checked that connection established correclty and query is also wrtie but where is problem? [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using …

hi this is my coding when i run this coding for display "Procedure or Function 'sp_developer_display' expects parameter '@developerid', which was not supplied." this error will display my sp in sql express is ALTER PROCEDURE dbo.sp_developer_display ( @developerid int ) AS /* SET NOCOUNT ON */ select developercode,developername,qualification,dateofjoin,designation,experience,knownsoft from tst_m_developermaste …

Dear Experts I have applied following custom Format to DateTimePicker dd-MM-yyyy So now DateTimePicker is displaying data as 15-01-2010 Sql server 2005, table1 has column named Date with datetime type How to store DateTimePicker text into date column of Table1 I want to save only date not time as 15-01-2010 …

how to use languages other than english in control which we use to take input like textboxes in c#. and how could these languages saved in database like sqlserver2000. plz help.

Hi guys, This is my first post here. Actually wanted to insert record into an sql database (using sql server 2000 and visual studio 2000) I'm using a dataview to see if the user already exists. This, i've been able to retrieve and it works. Now if the user does …

Hi, I'm using Crystal Reports XI with a connection to MS SQL Server. I've created an sql query in the Command for the report to run off which seems to work fine. I've added a couple of date parameters (prmBeginDate and prmEndDate) and included these inside the sql query (e.g. …

saving all data from data grid view in vb.net 2005 into sql server 2005 database table

hi this is my coding i run no error message but the data is not inserted in the table. i need help what is error in this program Dim MyConnection As New SqlClient.SqlConnection Dim MyCommand As New SqlCommand Dim connstring As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Documentcreation.mdf;Integrated Security=True;User Instance=True" Dim insstr As …

hi, i have a stored procedure named as'usp_rp_era_rejected_claims_detail'. [CODE=sql]ALTER PROCEDURE [dbo].[usp_rp_era_rejected_claims_detail] ( @S_Nos varchar (max)=null, @Practice_Code varchar(500)=null, @Date_From varchar(10)=null, @Date_To varchar(10)=null, @Date_Type char(1)=null, --'E' for Entry Date , 'C' Check Date @Report_Type char(1)=null --'U' unresolved, 'R' resolved ) AS BEGIN DECLARE @SQL Nvarchar(4000);[/CODE] I have an form in asp.net.The form …

hi.. im trying to put my data on a server & work on the same from other machine..im using win2003 as OS of my server & on the other machine's XP is the OS. my problem is, when i try to run my C# applications from the other machines, it …

I need some help... i am the beginner vb.net developer, so i need someone correct my coading to insert data from text field into database mssql... below is my coading; Protected Sub btnSimpan_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim dtTemp As New DataSet Dim ddClass As …

Dear Experts Data in Table1 is as follows Code-------product--------weight 1-------------Apple----------2.00 2-------------Mango---------3.25 3-------------Banana---------6.50 Then I have Datagridview with three columns same as Code, procuct, weight I have following codes [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click str = "SELECT desc1,weight FROM master where code =" & …

Hi, I am looking for best approach to query db table and get corresponding values on the basis of Ids passed. I have ids in String array, please provide best approach for point (a) and (b), what to use ArrayList, HashMap, etc... so that there are minimum loops... Sample code: …

Hi there! First off I´m new here, so, I'd say HELLO EVERYONE an thanks for years helping. I have the following problem: I need create a installation of a C# app that uses a SQL SERVER 2008. I am using INNO Installer because I thought it could be the best …

Hello everyone, While writing to the SQL Server database, I might encounter the below error message: “Error 823 I/O error <error> detected during <operation> at offset <offset> in file '<file>'” This error message may occur every time when I start SQL Server and access the MDF file. Thanks in advance.

Dear Experts Sqlserver Table1holds data as follows date---------------sno 01/01/2010-------1 01/01/2010-------2 01/01/2010-------4 01/01/2010-------5 01/01/2010-------7 02/01/2010-------1 02/01/2010-------2 02/01/2010-------6 02/01/2010-------8 How to findout missed sno in 01/01/2010? I want to get this result 3 6 Please help

Hi I am learning how to use database. I am using sql server 2005. I would like to know how to make an sql query to the database from vb.net. I have tried some code. what i would like to know is, how to make the sqldataadapter statement with 2 …

Dear Experts I use following codes to display data. Next & Back buttons work fine, but when I enter some sno into textbox1 then it displays nothing Codes on textbox1 lostfocus [CODE] Me.ds.Tables("employees").Rows.Find(Me.TextBox1.Text)[/CODE] Codes in Form Load [CODE]Dim sql = "select * from employees" Dim da As New SqlClient.SqlDataAdapter(sql, con) …

The code snippet below is the beginning of a script I've been working on. What I need to figure out is make sure that I can generate the corresponding day last year. The business logic is such that I am supposed to compare sales data from the last business day …

Hi, i have developed a asp.net project(on visual studio 2005) and created a web setup, this project is running fine while i am running in development enviorment(Visual studio), but after installing the setup ,my installed website is running but it is not able to access sqlServer Database ... what i …

hi.. Im trying to install SQL Server 2005 on my server.. but at a certain point it is giving an error which is unknown to me..im attaching a snap of the error.please let me know how to solve this error.. What does that domain account mean??? wher i can create …

Goo day all, i need a solution for the following scenario. I have a table, let's call it "sales" and i want to create a sql that will produce a detailed summary. below is the sample data (image 1)and how i want the end result to look like (image 2) …

Dear Experts How to apply primary key on sno column in the following dataset [CODE] dim sql = "select * from employees" Dim da As new SqlClient.SqlDataAdapter (sql,con) 'ds.Clear() da.Fill(ds, "employees") TextBox1.DataBindings.Add("text", ds.Tables("employees"), "sno") TextBox2.DataBindings.Add("text", ds.Tables("employees"), "Name") TextBox3.DataBindings.Add("text", ds.Tables("employees"), "City") TextBox4.DataBindings.Add("text", ds.Tables("employees"), "Phone")[/CODE] Please help

Hello every! I'm having some issues trying to pull data from a table. I need to pull data under the following constraints: The PRINTNAME column can not be NULL and can not be empty, plus the DISABLED field needs to be 0. This is what I have now, but I …

added checkbox on gridview this method: [CODE]<asp:TemplateField> < ItemTemplate> < asp:CheckBox runat="server" ID="CheckBox1" /> </ ItemTemplate> [/CODE] I want to save selected values another table but I did not achive.First I try this code and then I will convert this delete statement to select statement ,it deletes checked value but …

I am starting on a next to impossible journey to build a database with many records and with relational databases at a later date possibly. The primary database I am going to build will have approximately 10 million records in it. Each record will have 75 - 100 items of …

I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this

Help Pro's :'( I am a newbie in VB.NET .....I am using Sql Server Express 2005 as my database... I am currently working with my THESIS... A Human Reources Information System that concerns only with the file and record management of the employees... With two modules. a. Administrator for HR …

Hi all, I wanted to execute the query stored in a table with given intervals. I have a table called "calculations". it has the following structure: id | period | sql | result | now, in the sql field, I store the sql clause to be executed. In the period …

I am relatively new in the SQL/Web Development field. I have a DB (MS SQL Server 2000) and Web Apllication (.NET Framework 1.1). I would like to modify the seach and copy function in the existing web page. Please find attached the Design View as well as Source code for …

help me on how to write a code in vb2005 to create an sql database

i want to connect SQL server in C# application plz help how can i Connect DB in C#???

Can anyone tell me the complete process of connecting a website of basic html with SQL 2008.

HI I'm trying to insert data in 2 tables one is the master and the other is the details table, let us say it is test details first table : the master data of the test (name,date,......) second table : the parameter details (masterID,parameter,value) I want to do that through …

Hi all, I faced up the following problem: I have a table: ID|server | target | action ---------------------------- 1 |a | b | attempt 2 empty row 3 |a | b | success 4 empty row 5 empty row 6 empty row 7 |b | a | attempt Does someone …

I have a huge database which contains certain categories of products and their sales figures. I want to find CATEGORYWISE sale per Month. I have written a query for that. but I had to write 12 queries for 12 months. This is a sample Query for Month April I am …

I have a scary query on MSSQL 2005 here... Got a wiew that returns 2110 rows... and a table of cca 1 500 000 rows. Now, when I run this query [CODE] SELECT TS.col1, TS.col2, count(*) AS Number FROM view_scary VS LEFT OUTER JOIN table_scary TS ON VS.IdContact = TS.IdContact …

How to run a Asp.net page with database(Sql Server2000) on a browser? for eg: When I run a Asp.Net page involving login on Visual Studio 2005, the user is logged into his account but when I run the same page through a browser, user is unable to login. The error …

how do i translate group by and having into relational algebra? [code=sql]SELECT employee-name FROM EMPLOYEE, DEPARTMENT GROUP BY EMPLOYEE.suburb HAVING EMPLOYEE.suburb = DEPARTMENT.suburb;[/code] thanks.

HI Tuning sql for high performance is my project title... can any one explain wat is the exixting system and tell some of the ideas regarding project... <EMAIL SNIPPED> help plz....