3,481 Topics
 | |
| | I use report and have the table as shown below. The original column name are Parent and Child Row 1: Parent A and Child B Row 2: Parent B and Child C Row 3: Parent D and Child E Row 4: Parent E and Child F Row 5: arent Z … |
| | Hello all, Just wanted to pop in and introduce myself! I'm slowly getting back into ASP.NET coding (after almost 6 years), along with MSSQL, and hopefully moving on to using C# and others. I'm looking forward to learning from you all, and hopefully, sometime in the future, helping others!  |
| | Hi everyone! I have a query that take 5-10 minutes to run. And I use this query in ASP.NET Web Application. How can I manage to cancel query? For clarification lets say 2 buttons are on the form,one for starting and other for cancelling the query,is it possible if so …  |
 | btw any tutorials out there on how to create database with vb.net with mssql just to let me get started, i was hoping for a simple db to practice on like id,name. ive made db with php and mysql but vb.net is a bit far from php and mysql though …  |
| | hey i have a mdf file which i made an application in visual studio 2008 and i want to migrate all the data and the tables in to the MySQL server, can someone help me in this thanxxxxx appreciate a lot |
| | Hi all, I'm attempting to get some numbers from an XAL database (MS SQL Server 2005). My query is below. There are some conditions commented out. If I add either one of the lower ones the query executes in a matter of seconds but if I replace them with the … |
| | Hi I have three tables [ATTACH]18183[/ATTACH] Suppliers, Supply and Parts. I want two queries. a) List the name of the part along with the Total Price. b) List the names of the supplier that list both p1(part1) and p2 (part2) |
| | Hello: I have a table where a column called [I]ActiveStatus[/I] (of datatype 'bit') I am trying to run a query on may contain values Boolean values or NULL. Which means, if there are 10 rows in the table, a likely scenario would have 5 NULLs, 2 FALSEs, and 3 TRUEs. … |
 | I have a stored procedure where I need to insert from some other tables when those items do not exist in the original table. Here’s the stored procedure that I wrote. [CODE] ALTER PROCEDURE [dbo].[sp_CreateRequestedItems] AS BEGIN INSERT INTO dbo.RequestItems ([request], [applicationProfile]) --select from requests and profiles table into requestitems … |
| | I have the following three tables: ClassHeader ClassID Major TeacherClasses TeacherID ClassID StudentClasses TeacherID Major I want to select all TeacherClasses where the a given Major = ClassHeader.Major |
| | i need to isnert in database and i have query liike that [CODE]str_attend = "insert into Attendees([Userid],[Attendees_name],[Attendees_telephone],[Attendees_Email] )values (" & userid & " ," & arr(0).ToString() & " , " & arr(1).ToString() & " , " & arr(3).ToString() & " )" [/CODE] all values hold values in insert statment non … |
| | O.K. I've been agonizing over this for some time now, in this website i'm building, every registered user is gonna have some data that he can review add update delete. what would be the best way to store this data? in sql?, so that we have this one huge table … |
| | i want to concateneate my query with textfield value [I][B][COLOR="Green"]select tablename.columnname From TableName[/COLOR][/B][/I] lyk this Select tablename. & Me.textfield.text & from tablename plz tell me where m i doing wrong actually i m trying to only select single column by combo box.whenever combo box value is equal to column name … |
| | Hi, I've writen a stored procedure that is supposed to load 4 tables in a database that are to be used by a vendor to load their tables for an application we purchased from them. being that our data is on multiple servers, the query must read from two servers … |
| | Hi there, How can I write a stored procedure to select a value from a table and return that value?? I have a table Employee, when I send the email as a parameter to the stored procedure, I should get the employee number (it should return the employee number) I … |
| | i have code [CODE]Protected Sub btn_submitt_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_submitt.Click Try If (ddl_Country.SelectedItem.Text = "Select Country") Then Me.Label1.Visible = True Me.Label1.Text = "Please Select Country" Else Me.Label1.Visible = False Dim n As Int32 Dim connString As String = System.Configuration.ConfigurationManager.ConnectionStrings("containerConnectionString").ConnectionString Dim con As SqlConnection = New … |
| | Can someone please help me get rid of this "Error loading" message at startup? It is followed by the opeing of my System 32 file. I am using Windows XP on a Sony VAIO. The following is my HijackThis log. Any help will be greatly appreciated. Thanks in advance: Logfile …  |
| | hi... to all.. i've written the code in expression field... =format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00") the code is for printing the number in this format(12,23,23,34,123.00) now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas are printed.. i dont want to print the extra commas.. … |
| | hi.... in which version of sql server i can get the below two option... 1) performance tools 2)database tuning advisor.. please send me the download site... |
| | Hello... Can anyone help me...? I have the problem when installing SQl Server 2008 on Vista.. The message is : The performance counter registry hive is corrupted... please I need it Quickly... thanks...... |
| | hi all, I am new to mssql but C# programmer, can anyone help me on how to merge columns from different tables to a single table in sql for example i've 4 tables and the first table has a,b,c,d columns second table has e,f,g,h thrid table has i, j, k, … |
| | Hi folks I need some help! I have two tables the first contains account information, and the second contains flags that records in the account table may have. These are joined by the account?id. One account record may have several flags from the flag table. ie the following select select … |
| | Hello everybody and thanks in advance for any help you can provide. I am currently working on transitioning a mysql project to mssql and php v 5.3.3 I am having trouble with [code] <form action="{$_SERVER['PHP_SELF']}" method="post"> [/code] when I look at the source code of a working page... Say login.php … |
| | I'm trying to set up performance dashboard in SQL Server Management Studio Express. I'm currently running SQL Server 2005 SP3 ('product level') and also have installed the Performance Dashboard add-on. A couple of forums I've seen said that I could access the reporting feature by updating the Management Studio Express … |
| | I am trying to pull data from a table to fill a drop down list. Now, i got the fill part working, but am having an issue passing a variable value to my form post action. Code: $query ="SELECT UniqueIdentifier, LastName, FirstName FROM BrokerMain ORDER BY LastName"; $result = @mssql_query($query); … |
| | HI I have to create a small database that will be used by the clients, to get and be able to run their own reports. Can you think of any other Columns needed? You have to allow for a client to have one or more persons be the admin, that …  |
| | Here are the 2 procedures in question and the code that I use to call it. I will follow it all up with the error that is being produced. [code] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[usp_GetPropertyData]( @page int, @page_len int, @sortfield varchar(100), @desc bit ) as … |
| | [B]hello..! required a help i want to store a date in sql server field...i set the field type is datetime..bt i jus want to save only Month and year ...kindly help me in it..! i m working with vb6 i set the date formate [/B] [COLOR="Green"]myDate = Format(cmbMonth1.Value, "MMMM-yy")[/COLOR] [B]bt … |
| | Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column … |
| | hi...... to all i have one problem in executing the ssrs reports.. i've developed one project for that project there are some SSRS reports which are deployed in path ( "http://localhost/reports/") it is working fine... when i run through the project and press F5 ( i.e execute) the reports are … |
| | hi.... i've developed on ssrs report which displays the number in words i.e in million and billion.. i want it in crores ,lakhs,thousands,hundreds,rupees and paise.. can any one modifiy the code below.. which is in reports properties->code tab.. the below is my code which is of million and billion dollars … |
| | hi.... The code is about place the comma's (,) i.e separator between numbers in this format (12,21,21,123) it works good.. but when there's a decimal point such as 12345.58 it will show as 12,346.. it will round up the values.. ( which i dont want that .. i want as … |
| | hi... to all.. i've developed one ssrs report in "sql server 2008 express with advance services"... The virtual folder is not there in IIS .. ok it works fine .. i.e [url]http://mysystemname:8080/reportserver_sqlexpress[/url] it works good... but the same thing i want to execute in another system .. with my system … |
| | hi.... to all.. i'm using sql server 2008 express with advance edition with BIDS... i've developed one report in that employee salary.. i want to print the salary in the format (12,34,56,78,91,01,11,233.89) and i want to print in words such as (" ninty nine crores fifty one lakhs fourty nine … |
| | [ATTACH]17851[/ATTACH] Hi, Format my PC and installed SQL Server 2008. Setup hangs as shown in attached image. Installing on Win 7 64 bit OS. To install SQL Server SP1 is left to do due to this. FYI, the top text reads: Running post-Windows Installer configuration timing actions the bottom text … |
| | I have a query like: [code] select * from tableA where id in (1,2,3,..) [/code] List of ids ids very long about 200 000 ids. There is an clustered index on id colums. The same query on mysql rus fast but on MS it cant take about 20 minuts (on …  |
| | Hi, I know that when you set a column in ms sql to auto-generate IDs you won't be able to change the values. i'm having a problem with that restriction, because i have a table called Requisition, and for each entry, the requisition has a revision number. I've set the … |
| | Hi all, I hope anyone can give some pieces of advice on the following matter. I have developped internal server with a few DB in our company. Recently the system has been introduced to the all users, which willl acccess the data via Business intelijence SW (Business Objects in p[articular). … |
| | Hi, Please me to do this. I have one Webapplication. its build on vs 2010 and back-end is MsSql server 2008 and create setup for installing in another Standalone PC. The Problem is I can't run Application without installing Vs? is there any solution? can I run setup without install … |
| | pls,i need help in inserting a date from a text field using java, to mssql database. i am getting incorrect date for example when i insert 13/3/2010,i am getting the date 1/3/2011.i want a solution,i've searched a lot but useless.the problem is in mssql not java,so what i can do … |
| | pls,i need help in inserting a date from a text field using java, to mssql database. i am getting incorrect date for example when i insert 13/3/2010,i am getting the date 1/3/2011.i want a solution,i've searched a lot but useless. the code is: [CODE] try{ java.util.Date d; String s; d …  |
| | |
| | Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND CityId IN (23,45,85,86)' … |
| | I am using BIDS 2005 to write a report. The report takes a begin date, end date, and the parameter for salesperson names are filled by a query based on the date range entered. The report generates the stats for the salesperson when one is selected individually great. My task … |
| | hi, I am a SQL Guy, I like reading SQL Server books, Please suggest me some books which teaches advanced topics in SQL Server not just teaching the known things. |
| | |
| | 1.[CODE]SELECT pos_cashreceiptdetail.LocationCode,pos_cashreceiptpayment.TerminalCode,pos_cashreceiptpayment.ReceiptDate, pos_cashreceiptdetail.Description,pos_cashreceiptpayment.ReceiptNo,SUM(TotalCost) FROM pos_cashreceiptdetail,pos_cashreceiptpayment WHERE pos_cashreceiptdetail.Description LIKE 'Raw%' AND pos_cashreceiptdetail.LocationCode = pos_cashreceiptpayment.LocationCode AND pos_cashreceiptdetail.ReceiptDate = pos_cashreceiptpayment.ReceiptDate AND pos_cashreceiptdetail.ReceiptDate BETWEEN '2010-10-06' AND '2010-10-20' GROUP BY pos_cashreceiptpayment.ReceiptDate,pos_cashreceiptdetail.ReceiptNo[/CODE] 2.[CODE]SELECT pos_cashreceiptdetail.LocationCode,pos_cashreceiptpayment.TerminalCode,pos_cashreceiptpayment.ReceiptDate, pos_cashreceiptdetail.ShortDescription,pos_cashreceiptpayment.ReceiptNo,SUM(Totalprice) FROM pos_cashreceiptdetail,pos_cashreceiptpayment WHERE pos_cashreceiptdetail.ShortDescription LIKE 'Food Stall%' AND pos_cashreceiptdetail.ReceiptDate = pos_cashreceiptpayment.ReceiptDate AND pos_cashreceiptdetail.ReceiptNo = pos_cashreceiptpayment.ReceiptNo AND pos_cashreceiptdetail.ReceiptDate BETWEEN '2010-10-06' AND '2010-10-20' … |
| | I have a Fully Completed report in ms Excel. I want to change My Report using SSIS Pakage.. i realized that 'unpivot' and 'pivot' component will be needed.. so someone can help me to solve this matter.. thanks.. |
| | I have a table like below format. [CODE] CREATE TABLE Customer ( number VARCHAR(40) NOT NULL, --col 1 name VARCHAR(100) NOT NULL, --col 2 ssn VARCHAR(50) NOT NULL, --col 3 age INTEGER NOT NULL, --col 4 ) [/CODE] I want to add a new column in the table. If I …  |
| | Hello friends! I am creating a report, Abstract of Bid/Canvass, which will show all the supplier who bids. This also show what item is awarded to a certain supplier through showing the item row number and ranging it like 1-5. I've already created stored procedure that will show the range(s) … |
The End.