3,481 Topics
 | |
 | USE [Emp1] GO CREATE FUNCTION [dbo].[Leave] ( @EmployeeID INT ) RETURNS INT AS BEGIN DECLARE @PayLeave INT, @NonPayLeave INT; SET @PayLeave = 0; SET @NonPayLeave = 0; RETURN ( SELECT IF((ImDescription == "Sick") AND (ImLeaveType == "Yearly")) { IF((ImMonthlyMaxLeave > 1) OR (ImYearlyMaxLeave > 10 )) { @NonPayLeave = @NonPayLeave …  |
| | Greetings, I want to know what is the best practices when setting new database options? which options I should switch them from False to True and vice versa  |
 | Good Day i have been hit by this error this night. I have a UDF defined like this CREATE FUNCTION [dbo].[funcFormatPercentages_Extended_numeric] ( -- Add the parameters for the function here @parPercentageToBeFormatted nvarchar(20) ) RETURNS nvarchar(20) AS BEGIN RETURN CAST(CAST(convert(float,@parPercentageToBeFormatted)* 100 AS decimal(4, 1)) AS nvarchar(5)) + N'%' END so i … |
 | Hi, I have no idea in which forum to post this. I run three similar web servers, all w2008R2 with IIS7. two of them only contain ASP / ASP.net sites running on MySQL. The third also contains Sharepoint 2010 with MSSQL server. This server has a problem that is does … |
 | need an insert query for my code , i wrote code to add table rows having textboxes, dynamically, e.g yoh have only passed HSSC exam then you have to fill 2 levels of education SSC, HSSC......or say you have passed Phd , then SSC,HSSC,BS, MS, Phd, you have to fill … |
| | My database with the following table: ITDetail Table: [Click Here](http://i.imgur.com/WcwRI.jpg) InvTrans Table: [Click Here](http://i.imgur.com/hPnlz.jpg) Currency Table: [Click Here](http://i.imgur.com/YUNxC.jpg) Database Relationship: [Click Here](http://i.imgur.com/CTCdo.jpg) I need to build a report with the time parameter (use the procedure; [Click Here](http://i.imgur.com/PwVYX.jpg)) with the following requirements: 1. MaterialID, Art, Color, Width is taken from the … |
| | I need to pass the @startDate and @endDate as variables to @range in the code given below. But when I execute the below code, I'm getting the Error as follows. What is going wrong in my code, and how can I correct it? Errors: Msg 102, Level 15, State 1, …  |
| | Hi All, I wish you a Happy new year!!!.. My requirement is to upload an excel file using PHP and to update the data in MSSQL. For which i have designed a screen so that the user can browse 2 input files and update the database. html code for the … |
 | Remove the last word while using left in sql query...I weant to avoid broken words while doing so... My query as follows: select top 2 tempJobTitle.id,tempJobTitle.JobRefId,tempJobTitle.JobTitle,LEFT (jobmaster.JobDescription2, 330)+'....' as JobDescription,jobmaster.PostedDate from tempJobTitle inner join jobmaster on jobmaster.JobRefId=tempJobTitle.JobRefId where tempJobTitle.Status='Approved' and jobmaster.ClosingDate >= '2013-03-01' order by tempJobTitle.DateofEntry desc |
| | I've have been doing some research on how to export export a pipe delimiated file from sql management studio but I cannot quite seem to figure it out. How would I simply turn this output into a piped file. [CODE]select * from #tmpRPLRouting where propertydatamap = '3' [/CODE] |
| | Hi Friends i am working for association management project. my database is mssql i am having 2 tables as below **1. table name is community_username** ASCN_NAME COM_NAME URFNAM Email_id URAC Name1 Commname1 Name1 Email1 Yes Name1 Commname1 Name2 Email2 Yes Name1 Commname1 Name3 Email3 Yes Name2 Commname1 Name1 Email1 Yes … |
 | Hi all I am currently working on a Battlefield player / server statistics application that i have written in C#. I am storing RAW player / server data in a table at the moment. My question is what is a recommended maximum columns per table as this statistical data which … |
 | Hi, I have a problem with a code harness given to me by my tutor. Every time i enter values into a form, I get the following message: > Warning: mssql_query(): message: Invalid column name 'N56DSRT'. (severity 16) in /web/users/l1099341/SDD/insertCarController.php on line 27 Warning: mssql_query(): General SQL Server error: Check …  |
 | Hello, i installed MS SQL Server 2008 0n a stand alone/member server runing windows server 2003 R2. I connencted it as a member server to a Domain Controller(child1.parent.local) in another site. This worked very fine both the replications were succecssful. The domain controller which i connected to, is a child …  |
 | hey every body , i need to know how i can create an automatic back up for my database step, i am using sql Enterprise server 2008 R , what i need is the steps of how to do thats and how i can check if the job start or …  |
 | How would it be possible using T-SQL to find the raw amount of time that has passed between when the job started and when the job ended? i have used this function datediff(ss,grn_date,GETDATE()) . this function gets the jobs done how ever if the diffrence btw the dates is huge …  |
 | In my project i want to create a database through my application, how can create new database using sql statement.( i.e create database...)  |
 | how i can make the relation ship in MS SQL ? |
| | Hi All! I have 3 tables: test1 id name1 1 value1 test2 id name2 1 value2 test3 id name3 3 value3_01 4 value3_02 I want to display all records of table test1 with values of table test2 (test1.id = test2.id) and values of test3 (if test.id match with test1.id) - … |
 | I have a table named Machines with fields: MACHINEID, MACHINEName MACHINECode, FACILITY where MACHINEID is a primary key. And i like to create a general stored procedure that does ADD, EDIT and DELETE operations and after updating i want the old record to be kept. How can i do that? |
 | Hi All, I have the following statement which is intended to have a Year over Year Percentage change: select CurrYear.Variable_Date,CurrYear.Variable_Value,cast(100*(CurrYear.Variable_Value-PrevYear.Variable_Value)/PrevYear.Variable_Value) AS Percentage_Change from dbo.tblCPISC as CurrYear left outer join dbo.tblCPISC as PrevYear on year(PrevYear.Variable_Date) = (select MAX(Variable_Value) from tblCPISC where year(Variable_Date) < year(CurrYear.Variable_Date)) order by year(CurrYear.Variable_Date) For some reason, I … |
| | Hi, I have a problem that in a database (named DDS) i can change or delete records in all tables but there is one which i can't. There isn't any primary or foreigh keys(There is one dependency, a view). So could you please tell me that is there any way …  |
 | HI TO ALL, I get this error:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.When Running my vb6 module on Another server SQL Server is installed on Windows Server 2003,and i am testing the application from WinXP and Win7 on my server it will work. Testing from other machines(Server) with … |
 | Hi, Im trying to get the depreciation value of an equipment every month. My system gets the number of months from date of purchased up to current date for the computation of depreciation. I can run the report anytime but the computation must be like this: Sample: Date purchased January … |
| | Hi All, I am wanting to round up my values at query time to 0 decimal places from 2 decimal places. I have SELECT DISTINCT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type, b.vSeries_Unit_Type, a.Variable_Date, ROUND(a.Variable_Value, 0) AS 'Value' but the output still has the 2 decimal places which are 0s and pointless in … |
| | hi i am writing a report, it must have parameters ToDate and FromDate,now the thing is i did all that but it stllrespond with just headring no data. Please help what am i doing wrong |
| | I want to make the closing balance of the current month lets say of March to be the opening balance of April in sql or crystal reports how to i go about it. Help need the solution agently please. the script below is the one i have used to get … |
| | Hi All, I'm having a go at SQL queries and have the following: SELECT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type,b.vSeries_Unit_Type, a.Variable_Date, a.Variable_Value FROM tblPopulationSC AS a INNER JOIN tblVSeriesList AS b ON a.vSeries_ID = b.vSeries_ID and b.vSeries_Geography='Manitoba' --and b.vSeries_Unit_Type=' 15 to 64 years' and b.vSeries_Type=' Both sexes' and b.vSeries_Unit_Type=' 65 years and … |
| | Hello, I had a very peculiar problem today which I am sure hundreds would have had and solved before. I have developed a VB.Net + SQL Server application and installed it in a few dozen places. All worked very well. Then I installed it in a persons computer in Middle … |
| | I want to develop a simple application which runs on single computer (just runs in one mechine) and did not need network. Program has to store some data in database and show them for printing. I have no experience with real-word program so I confused here: If the program is …  |
| | How to delete duplicate record in sql serer plz suggest me............ thanks |
| | I want to have the following on SQL Azure: IF EXISTS(SELECT * FROM [sys].[databases] WHERE [name] = db_name() AND [compatibility_level] = 110) BEGIN ALTER PROCEDURE [dbo].[Test] AS BEGIN -- Omitted body containing lots of strings END END or a work-around that does something similar. What follows is what I'm trying … |
 | Hey guys ineed help on how to install or which is first to install using VS 2008 and MS SQL server & and IDE server management tool for MSSQL 2005  |
| | Good Day All I imported data into a Ms Access 2013 from SQL and all the data is there. I created a Query and also created a report that will use the Query. So the Query returns all the data. There are around 590 000 records that needs to be … |
| | is it true that no. of rows affected by select statement (ado.net) , is always -1. i.e. NO. OF ROWS AFFECTED BY SELECT STATEMENT = -1 ; if it is then why ? |
| | i am sending emails to more than 1000 users at time , so i used a datatable to fetch email addresses from DB's table and then i loop over it voa foreach and then send it to each user via net.mail namespace's code that's ok, Done But problem is that … |
| | i am getting error ERROR: The specified string is not in the form required for an e-mail address. but when i pass static email address , it works , why ? protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connectionString); String command = "select visitorEmailID from tblvisitorSubscriptions"; … |
| | hi there. I have a problem in making my amortization. I just only want to know how to change data grid view's command text with where conditions. this what i've got: LoanSampleDBDataSetTableAdapters.loan1TableAdapter.commandText = "Select * from Employees where ID =" & n1 Then error occurs. |
| | hi there.. I just need some help for my loan management system. thus anyone know how can i stored schedule of amortization to the sql serve? is it 1 insert statement is enough to store in database? do this problem need looping. I don't know what code should I need … |
| | I am running a script on our production database reffering two tables : our table of users (3700 of them) and the table of quotes that they have made (280000 of them). Quote is the main object in our application, a very large object, for whom many data tables are …  |
| | Hi, is there another way of hiding or formating column value in asterisk in select statement? im using the command replace SELECT REPLACE([Item].[Price],[Item].[Price], '**********') AS Price From Tablename it works fine, but is there anyway to do this? Instead of replacing/forcing the value to display asterisk, i just need if … |
| | I published my project in vs2010 and im trying to deploy it to other computers. I used this connection string that runs smoothly on my pc. This code tries to retrieve the servername and try to connect to database mysysDatabase. This forcely change the app.config. Private Sub btnOk_Click(ByVal sender As … |
 | I am using SQL Management Studio Express and Visual Studio 2008. I have this string used for accessing the database for the system I have: Public constring As String = "Driver={SQL Server}; Server=MyName-PC; Database=RBMonDB; uid=; Pwd=;" This string is stuck on one PC. So I thought of creating a generic … |
| | Hi, I let say I use this code to retrieve date from database SELECT Table.Date FROM Table The format is 01/09/2013 (dd/mm/yyyy) How will i format this to get 09-Jan-2013 output then print this format to crystal report? I'm using dataset to connect data to crytal report I just noticed … |
| | Hi, I'm having trouble to filter a Customer Set by the date of his first buy(First Activity). I've tried this two ways: 1. Returns all customers, even with FirstActivity Null SELECT { [Measures].[Valor Item], [Measures].[First Activity] } ON 0, { Filter( { [CLIENTE].[Cliente].[Cliente].Members }, ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] ).Count > … |
 | Hi All! So, I have a shared windows host with IIS 7 with godaddy, so that I can use MSSQL/TSQL (which, as I understand it, is not available with Linux). However, my server configuration education was with Linux, and focused on the wonderful all encompassing .htaccess file to configure environment …  |
 | I have a series of user records in the form "`Lname, Fname (ABCD)`" where `ABCD` is the division the user works in. I need to be able to extract that substring so I can sort on it, count etc to I can see what divisions are using resources. In MySQL … |
| | hello! I got this error when I tried to connect to my db in sql server. > Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 8945dcd8080cc91' or one of its dependencies. The system cannot find the file specified. … |
| | Hello I had a problem uploading or adding a file on the database and shows the error stated on the title. The column holding the binary data was set to varbinary(MAX). I couldn't find what was my error because I was able to upload a 900kb MS Word Document but … |
 | Hello brothers, I am currently developing Single PC application in vb.net 2008 and Mssql Express 2005. 1. what are the Software I need on development Computer? to start develop application which can run on a main Computer and also from other Computers on LAN ( simple windows xp and windows … |
The End.