2,736 Topics
| |
I have a view with two tables and three fields tables are called SC011000 and SC33013 the fields are called SC01049 and SC33013 both are datetime fields. I want to make the third field show the biggest date. but i am doing something wrong I am typing in case when … | |
Hi, I am new to SQL and just trying to self teach myself... I have written the below script and I am recieving an error. If anyone could help this would be much appreciated... [CODE]SELECT (CASE WHEN SL_PL_NL_DETAIL.DET_NOMINALCR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALDR ELSE SL_PL_NL_DETAIL.DET_NOMINALDR = NULL THEN SL_PL_NL_DETAIL.DET_NOMINALCR END)][/CODE] | |
Hello Everybody! My problem is connected to the SQL Server Enterprise Managager. I worked with it for a day testing a database attaching/detaching it and after I closed the Manager the following problem occured. The local database seems to be dissapeared. However, the applications through the network reach it because … | |
So, I'm a tech writer, not a database guy, but I've been asked to develop documentation for my company's databases. This means I have some questions. It seems obvious to me that there must be some SQL documentation tools out there, but I have no idea what is used for … | |
my table structre like this ID nAME 1 Mumbai,Pune,Chennai i want output of name like this Name Mumbai Pune Chennai pl help m 'new to sql Thanks in Advance | |
Hi all, This is ridiculous they teach so much at uni except what you need to know to program :-/ haha. This is actually gonna be a 2 part question but I'll do it one at a time. So I'm developing a small program for a company, this company has … | |
Dear Friends, I am new to sql, I have 2 tables named as payroll and employees. My payroll table has many columns as per my requirement. But I am giving here only few columns of my table.Few columns of payroll table has data in following format: empid, month, year, basicpay, … | |
I would like to develop a database system using ms sql server 2005 express or 2008 express edition where the data may store in other than english language into tables. so i did it using mysql database but not working in 2005 express edition. Is there any solution? | |
ProductID | id | TaxDescription| 2009001 | 1 | Excise 2009001 | 2 | Edu Cess on Exc 2009001 | 3 | S.HS.EduCess-Ex 2009002 | 1 | Excise 2009002 | 2 | Edu Cess on Exc 2009003 | 1 | Excise 2009003 | 2 | Edu Cess on Exc 2009003 … | |
I get error while connecting to server .i have sql server 2008 r2. [B]can not connect to local A network related or instance-specific error occured while establishing a connection to sql server. the server was not found or was not assible. verify that the instance name is correct and that … | |
I am using SQL2008. I want to generate log file of each and every transaction carried out on my table. How can i do this? | |
create function funAdd2(@a int, @b int, @c int output) returns int as begin declare @c = @a+@b return (@c) end | |
Hi Guys I recently installed the SQL Server 2008 R2 - Developer on the top of Windows Server R2 (Standard) on VM machine hosting by windows 7 64 bit.I Installed a default SQL Instance and I didn't get any error message during installation and everything goes fine but now when … | |
Hello, I have not used Sql server. I have microsoft sql server 2008 installed. but when i click management studio, it says evaluation period expired. I can download sql server 2008 r2 developer from my university site. Should i go ahead and download sql server 2008 r2 developer and uninstall … | |
hi.. i'm facing a new problem in ssrs reports ... i have hosted an asp.net application which is running fine in XP.. but when i open the application in UBANTU OS application is working fine but reports in kannada are not displaying it is displaying some russian character .. same … | |
[CODE]I am having two tables in MS SQL SERVER 2005 in master database. 1st table is Country & 2nd is City. [COLOR="Red"][B][U]I want to know the command for Copying a Column(with values) for eg say Name from City Table to Country Table. Column is not empty, its having values(data entries). … | |
i am trying to create a dataset for use with crystal reports. i have a dataset called dataset.xsd with two tables BatchHeader and BatchDetail these have a relationship of BatchID on both tables. (see picture1) I have this working when there is only one table in the dataset with this … | |
Hello guys. I'm developing a web application in which I have to connect to a mssql server which is connected through a proxy server. I have allowed data transfers for the MSSQLSERVER service, and allowed connections for port 1433. I've read that this is absolutely insecure, and it still gives … | |
Hello, I'm trying to sort a training table in order of the sequence of tasks. These tasks are numbered 1.1.1 1.1.2 1.1.3 ...... 1.1.10 1.1.11 When the query sorts this and displays it, it comes up: 1.1.1 1.1.10 1.1.11 1.1.2 .... Is there a way to get them to come … | |
Hello Everybody! I have the following problem: I want to make an application, which need tables to show, edit, etc. You would be able to select the table, which you want to work on, by a dropdownlist (the whole project is in ASP.NET). I want to load the selected table's … | |
good day for all i want to know how i can make linked tables in access with sql server 2008 i tried with odbc in access 2003 but i can not please help me i tried with Microsoft SQL Server Migration Assistant 2008 for Access but i can not | |
Hello folks, I beg your pardon if I have posted the thread in wrong forum. But my query is related to sql server and visual basic 6, so I thought posting it here rather from visual basic forum will help me getting most replies.... I have developed an client-server based … | |
Hi Guys Could you please let me know what SQL query I can run to get the parent of a specified table? I already used this code which is providing a list of child tables [CODE] SELECT object_name(parent_object_id)As 'Childs List' FROM sys.foreign_keys WHERE object_name(referenced_object_id) ='Stores' [/CODE] How can I run … | |
I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can … | |
afternoon everyone, I am new to using MSSQL and need help with SUBSTRING function. i have a strings like below s2-Total Solids - Std Method V1E-RVT4/2.5@20degC Initial V1Y-LVT2/60@20deg Initial A2-Alkalinity - ISO Method(%) I would like to only get the data before the first "-" IE s2 V1E V1Y A2 … | |
So how can you tell if you've maxed out express and need to move to the full blown version. Not referring to database size but performance? Asking because we are moving a website and the webhost master asked if he will be on express or full version claiming that express … | |
HI I want to create new sql account in sql server 2005,and user only able view sql agent job history details only.How do I do this.Please help. Thanks Tank50 | |
Hello everybody and thank you in advance for taking the time to read this. I am having trouble connecting to a remote MSSQL server from our web page server using the SQLSRV Connect. I have installed all the necessary php extensions and sql drivers, and they all appear as they … | |
Team - This has to be way more simple that I am getting. Been searching google for hours with no luck. Simply stated, I am trying to delete a datalist row which is bound to a mssql database. Simple right! I am missing where it is putting the key or … | |
The End.