2,935 Topics
 | |
 | Dear all, I have a table that contains image data type and has more than 20,000 records. I want to change its file group to the new file group. I tried to change it using table designer, but everytime I wanted to save it, it occured an error with this … |
| | Hi! I´m trying to have a datagrid with some data. It includes a subquery and does only work if I define the parameter. I don´t want that. I would like to group it. The query is: [CODE] SELECT count(*)*1.0/ (select count(*) from events_may_2010 where agent = '5013' and convert(varchar,call_date,112)= convert(varchar,GETDATE(),112) … |
| | Hi, I was wondering what is the "cleanest" way of combining two datasets by taking all the values from one data set and only the values from a second data set that have an index that does not appear in the first. Both data sets have the same columns. Even … |
| | Hy, I seek your help in solving the following problem: I have a select which returns columns like ( without count_same which I need to create by counting the same name): ID | NAME | no_items | count_same ----------------------------------------------------------- 1 | A | 1 | 2 2 | A | … |
| | Hi... I have two tables without primary keys and with a common field meterid... I can't add a primary key to any of these tables... Now i need to join both tables.. Can anyone write the query for this...plss... select * from table1,table2 where table1.meterid=table2.meterid; isn't working... The result of … |
| | What is the problem with the following login code? [code] Dim conn As SqlCommand = New SqlCommand("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts;Integrated Security=True") conn.Prepare() Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("select", conn.Connection) command.Parameters(1).Value = txtusername.Text command.Parameters(2).Value = txtpass.Text Dim i As Integer = command.ExecuteNonQuery conn.BeginExecuteNonQuery() If Page.IsValid Then Response.Redirect("~/salesbill.aspx") Else Lblerror.Text = "Username …  |
| | Hi I would like to show the data in a hierarchical manner as: bluehills > hills > south where hills comes under bluehills and south under hills in a hierarchical manner. How this is possible how can i retrieve in this manner using procedure Please help Thanks in advance MS |
| | Hi I've been trying to solve the following problem for a few days but everytime I get the error msg even when the entered value doesn't conflict with the statement. Plz I need an urgent help I have the following tables: [B]booking[/B] bookingId (PK) subjectId (FK) [B]Subject[/B] subjectId (PK) termId … |
| | hello. i have a database with school names, their budgets and their expenses. i have to write trigger not allowing to increase expenses, but only to lower their value. if someone wants to increase it, there should be message. i know i have to remember somehow the old value and … |
| | Hi, i've tried several times, but haven't succed in making this: Classroom2 Name: | Date: Oliver | 12-10-10 Homer | 12-10-10 [COLOR="red"]Peter | 11-11-10[/COLOR] Classroom1 Name: | Date: James | 20-10-10 Lars | 20-10-10 [COLOR="red"]John | 11-11-10[/COLOR] How do i make a SQL statement that ONLY selects the lastest dates … |
| | hi, im trying to divide two fields in a database like this: crterm=bal/pi but im not sure how to write it in sql. any suggestions? |
| | Dear Dani web user, Can anyone help me how to generate series of date that has start and end date and pick up the data along the way. I have used Stored Procedure below but its not working [CODE] -- CREATE TEMP TABLE declare @YTDbyMonth Table ( --Period nvarchar(100) DateStart … |
| | Hello - We are trying to do a restore which is started manually (not an agent job) via rdp. I'm being told that the restore fails if the the rdp session shuts down. I don't think this would cause the restore to stop. I haven't seen the error logs yet, … |
| | Some of my tables have no key since auto-number won't ensure no duplicates are entered. Other tables have multiple fields as key because this is the only way to uniquely identify. Migration did not like certain tables or queries due to this, are keys required? Also my Forms and queries … |
| | Dear all, I'm stucked with my XML problem. I have these stored procedures to save XML data into server hard disk. [CODE]CREATE PROCEDURE dbo.sp_XML_Employee(@Database varchar(10), @FileName Varchar(2000)) AS DECLARE @bcpCommand varchar(4000) SET @bcpCommand = 'bcp "SELECT EmployeeID, EmployeeName FROM ' + @Database + '.dbo.MasterEmployee ORDER BY EmployeeID FOR XML RAW(''Employee''), … |
| | G'day, I'm wanting to generate non-sequential 12 character codes to use as coupon codes or gift vouchers in mssql server 2008. I wanna avoid generating a random and checking existing, but i don't know if it's possible to generate shortened guids? like maybe a nuid or a suid? any advice? … |
| | Hi everyone, This is the error i am getting when i try to do SqlCommand.ExecuteNonQuery(). My application runs on multiple threads and constantly opens, executes and close connection. This error i am getting after running the application for some time. Error: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results … |
 | Hi Guys, I am currently creating an application to track timekeeping (a clock in/out system) and I am trying to work out the best way to do this. I have a Main Form which contains buttons to ; - Log in - Out for Break - In from Break - … |
| | Hello, I'm using Windows 7 Ultimate 64bit. I'm on admin account and all I want is to develop my ASP.NET pages on my main system - not only on virtual machine with XP istalled. The problem is that I cannot access the database on Win 7. IIS is working, ASP.NET … |
| | Hi, Hello all. I installed SQL Server 2005 on Windows 7 together with SP3. I set the surface area configuration to allow TCP/IP and named pipes. When i try to connect the machines running SQL, i fail, i cant access it. Neither can i change any settings in the surface … |
| | How do I prompt the user to enter an 8 character code that I will use in an MS SQL query script? |
| | Dear all, I have this query to generate sql row to XML Mode. [CODE]SELECT CurrencyID, CurrencyName FROM MasterCurrency ORDER BY CurrencyID FOR XML RAW ('Currency') , ELEMENTS;[/CODE] the result is : [CODE]<Currency> <CurrencyID>AUD</CurrencyID> <CurrencyName>AUSTRALIAN DOLLAR</CurrencyName> </Currency> <Currency> <CurrencyID>CHF</CurrencyID> <CurrencyName>SWISS FRANC</CurrencyName> </Currency> <Currency> <CurrencyID>EUR</CurrencyID> <CurrencyName>EUROPEAN EURO</CurrencyName> </Currency> [/CODE] I want the … |
| | Newbie SQL programmer. Here is my issue. I have a field, memid, varchar 30. I want to look at positions 1-9. If all are 9 positions are numeric , move those to memssn int field. Can anyone assist me? thanks |
| | I Have Created Following tables 1.Test_Student(Master) table which will contain StudentId(primary key), StudentName and StudentAddress as columns. 2. Test_Subject(Master) table which will contain SubjectId(primary key) and SubjectName as columns. 3. Test_StudentSubjectTrans (Transaction) table. This will be a transaction table between Test_Student and Test_Subject. This table will contain StudentId and SubjectId … |
| | I have Column named 'Price' in a table.I want to update the 'Price' Column by adding 5 .But i have some Null values in 'Price' Column.Whenever i update the 'Price' Column.All Values Updated Except the Null Values Column.So how can i update the null Column.Pls Help Alok |
| | Hello All i have a query on (Union all) clause i want to create a table through union clause. the code i am trying to execute is: [CODE] select * into table1 from (select * from partmst union all select * from importexcel) as mytemp [/CODE] but it shows error … |
| | hello all, i want to save the web page content into a database. how can i fetch data from that website and save into a sql database. im using c# as front end. need help. expecting reply soon since it needed for my project. thanks. |
| | Hello I want to compare an inserted date against two stored dates in order to validate an entry. The date entered is being stored in a separate table from the stored dates. I am not sure how to go about this. So far I have this: [CODE]create PROCEDURE sp_GetTime @FullName … |
| | I've created an SSIS package where I have an FTP Task inside a ForEach Loop container. I am trying to loop through each file in the particular folder and send it to the FTP site. I am sure that I got the For Each Loop working, as the error message … |
| | i want to insert multiple int values selected from dropdown in to a single column seperated by a delimiter(,) along with this values there are some other rows too in which some other values are inserted a table has Booking id which contain values like 1 and roomid which contain …  |
The End.