3,481 Topics
 | |
| | I have the following view: ALTER VIEW [dbo].[vw_RelInclusaoGeralCivil] AS SELECT DISTINCT m.Nome AS MunicipioNome, au.Nome UsuarioNome, s.TipoId AS SolicitacaoTipoId FROM Solicitacao s INNER JOIN Unidade u ON s.UnidadeEntregaId = u.Id INNER JOIN Endereco e ON u.EnderecoId = e.Id INNER JOIN [IBGE.Municipio] m ON e.CodMunicipio = m.CodMunicipio INNER JOIN Terminal t … |
 | Split pipe delimited into new columns as below : col1 col2 col3 col4 Data|7-8|5 Data 7-8 5 Data|asdsad|sad Data asdsad sad fish|c cx cx xc cc xc cx |ededededeed fish c cx cx xc cc xc cx ededededeed Data|iueroiheqroqer|ewoijewijewd5 Data iueroiheqroqer ewoijewijewd5 tune||5 tune 5 Data|| Data check http://stackoverflow.com/questions/19688863/split-pipe-delimited-into-new-columns  |
 | What is difference between MySQl & MSSQL database storage limitation. More descriptively, If I make databases using the above-mentioned database systems. How much data I can store in each of them, i.e. 1GB, 2GB, 10GB, 100Gb. What is the limitation? |
 | I wrote a program in early 2010 that ran a command line function that pulled data from SQL Server 2005. The program worked at the time, but does not seem to work now (for various reasons, it was not used for about a 1 year). BCP "EXEC emdb..Patch2" QUERYOUT D:\shares\patch2.txt …  |
| | Hi guys I have problem i need to make ERD relation entity between employee and allowance Employee table Name address Basic Salary Bonus Allowance table House rent Food Allowance Moving Allowance Basic Salary is monthly and fixed Bonus is monthly and fixed food allowance is monthly and fixed for married … |
 | Hi, I originally created this query to get a result from a single select statement Its funny that it became a very long query having sets of joined table Its also maybe annoying to look for it so im trying to trim it down most of it have same joined … |
| | Hi I am having two textbox, textbox1 is having autosuggest feature. i want to display related value based on textbox1 value. can any one pls help me. i collected the code from internet **Output Example** Report Name : PHP Report Version: It has to display the Verison from the database. … |
| | Hello... Can anybody explain me Ebay or something like that database structur.Do All Item Categoris Store in One Table(with Differnt types)or do they story in many table .ex books for one table,jewellery in another table and so on.if they are store in differnt tables how do we search them ? …  |
 | I am trying to look on the web for a way to create a stored procedure that I can run and then put in multile values and this is the closest I can find: CREATE TYPE dbo.EmployeeList AS TABLE ( EmployeeID INT ); GO CREATE PROCEDURE dbo.DoSomethingWithEmployees @List AS dbo.EmployeeList …  |
| | I have the following table: Region IdDescription IdUser Metropolitan Right 5 Metropolitan Left 6 Metropolitan Right 5 Metropolitan Left 6 Country Town Right 5 Country Town Left 6 Country Town Right 5 Country Town Left 6 Metropolitan Right 7 Country Town Left 8 And I want to query the kinds …  |
 | Hi guys, I hope this is the right section to post. I need to develop an application in visual studio 2012 that uses SQL (please bear with me as I'm not very well versed in databases and SQL and therefore I don't know what SQL visual studio uses), and when … |
| | Hi I have an issue in store procedure. Error is Msg 4104, Level 16, State 1, Procedure W_usp_SO_Table, Line 38 The multi-part identifier "dbo.SVendorMaster.SVCode" could not be bound. Insert table is working fine. But update command is prompt the error Pls advice me Maideen Here is SP SET ANSI_NULLS ON … |
| | Hi I do not know how to sum the one of the column in #table temp table It is my SP SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[usp_Customer_Due_Until_Now] @Code nvarchar(30) AS BEGIN SET NOCOUNT ON; select code as Code, Name as Name, sum(Nett) SINETT into #tableSI … |
 | Hello, I need a little help with trigger, I have been doing database development for a long time now but this is my first go around at a trigger. It is not working, can someone please look at this and let me know what I am doing wrong: ALTER TRIGGER …  |
 | I need to know if there is a way to improve the below function as it takes long execution time UserDefinedFunction [dbo].[GetChildrenAccount] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[GetChildrenAccount] (@AccountID INT, @DateFrom DATETIME, @DateTo DATETIME, @TypeTransaction INT, @Currnecy INT, @Branch INT) RETURNS DECIMAL(18,3) AS BEGIN DECLARE … |
| | Hi everyone, Thanks for visiting this thread. I have recently migrating my MSSQL database from one server to another server by copying the database. The database that I copied contains the ASPNET membership and other related tables. My asp.net web application is currently pointing to the new created MSSQL database … |
| | Hi, Im trying to extract data from sql server where conditions are multiple and variying I have a datagridview with 2 columns ID and Name I need to create Select Query to extract data where condition is 'ID should be equal to the value or values in Datagridview ID Column. … |
| | Is there a way to get a total counts from the resultset of two unions? This will be for DB2. select count(*) from ( select count(*) from xyz where abc='1' union all select count(*) from x1y1z1 where abc='1' ) |
 | i'am trying to create a setup file for my system where it has a database...can you help me???...i've tried to search it but it's only for mssql... |
| | If I have a datagridview that is bound to a dataset which comes from a MSSQL database, how can I have the datagridview display only one row of data from the dataset rather than all of the rows? Specifically, the first column is a combobox which is bound to the …  |
| | I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not be duplicate please review query below. alter proc spUserdetailss @name Nvarchar(50), @passwords Nvarchar(100), @emailadd Nvarchar(50), @Gender nvarchar(50) as begin declare … |
 | Hi All, I want the query to take the sum of individual rows. It can in MSSQL Query or Mysql Query. Please help.. Thanks in Advance. |
| | This function I have created to return all recorded Stock numbers in the Table "ContributorDeeds" the table contains only the start number of the stocks and the end number of the stocks (e.g, from number - to number) I need to get all the numbers between within that range. The … |
| | hello friends I have two tables with column A and column B. I want to update column B of table2 with column B of table1 . I have trying this query in ms access from Vb.net. update table1 t1 LEFT JOIN table2 t2 on t1.a = t2.a SET t2.b = …  |
| | Hi, I have to correct some data in SQL Server 2008 R2 database for an accounting system that was accidently over written. Basically I've to take stock items with fixed prices and compare those fixed prices against Sales Order Transactions for the stock item and correct entries where the transaction … |
| | I have written a SQL query to find product information in a c# program and it doesn't seem to work at all! I have tested a variety of other queries with my C# code and it works fine, but this throws an exception every time. SELECT TOP (1) CONVERT(varchar, tmpRptAssetEvent.EventTimeStamp, …  |
| | Hi I have an issue in below stored procedure. below Store procedure is working fine. But fixed the Year. Any one know How can do the year dynamically select by user? SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNo pivot (Sum(gross) for [yearno] in ([2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020]) )pivotTable pls advice Maideen |
| | Greetings, I'm facing a problem with the SQL Server and this problem concerning numbers when compared each other and these numbers are stored in the columns of data type NVARCHAR or VARCHAR. For example, if I'm having a column with data type NVARCHAR and it contains such values: 1 2 … |
| | Hi all, I have created a table in which i have a DateTime Column . i need that i dont want to insert values in that column from the front end. i have created a trigger for that purpose. whenever i insert a row in that table the dateTime column … |
| | What is meant by the bold part of the below paragraph An index is a copy of select columns of data from a table that **can be searched very efficiently that also includes a low-level disk block address** or direct link to the complete row of data it was copied …  |
| | I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change … |
 | I have a code behind in my web pages and I'm trying to write Greek characters in my SQL 2010 Tables. I write in my Tables but what I get is ????? why is that? What I have to do in my SQL in order get the Greek characters? Thank … |
| | Hi, I want to create a trigger to increment value of my VisibleNo field if it gets duplicate value. My Application is my multiple users at same time . When at first suppose two users open application it gets same visible no and it saves duplicate number. I want use … |
 | <item> <HaberKodu </HaberKodu> <Kategori</Kategori> <Sehir</Sehir> <title</title> <description></description> <pubDate></pubDate> <images> <image> 1 </image> <image> >2 </image> <image> 3 </image> <image> 4 </image> <image> 5 </image> <image> 6 </image> </images> <small_images> <small_image>1 </small_image> <small_image> 2 </small_image> <small_image> 2 </small_image> </small_images> <Aciklamalar> <Aciklamala>1 </Aciklamala> <Aciklamala> 2 </Aciklamala> <Aciklamala> 3 </Aciklamala> </Aciklamalar> <link> </link> …  |
| | i am trying to check availability of a room i have the following code: ALTER procedure [dbo].[CheckAvailability] @checkIn datetime, @checkout datetime as Select r.RoomName, RoomNO, [Description],Location, RoomPic, Price from [Room-Type] t , Room r, Booking b where r.TypeNo= t.TypeNo AND r.RoomName Not IN( Select b.CheckinDate from Booking b where ( …  |
| | HI Please help. how to solve this I am using the below code. insert is working fine. but i am having problem in edit session i edit page i can able to display both values from Database. If i am changing the textbox1 value i am not able to get … |
| | can any body help me or give me an sample code on how to create a very simple log in system using php and mssql..tnx in advance. |
| | I use SQL Server2008 R2. From yesterday, I get a problem to open it. When I try to open it by Microsoft SQL Server Management Studio an error is occurring. And I also get the same error when I call it from vb.Net2010. I am attaching here the error picture. … |
| | I have to pass two values to sp first value is nvarchar and second value is Int in SQL server,but i am not getting values, is my code is correct.Please help me out $query = mssql_init("courseofferedbyprof", $dbhandle); mssql_bind($query,"@facultyID",&$facname,SQLVARCHAR,false,false,50); mssql_bind($query,"@count",&$year,SQLINT2,false,false,50); $result=mssql_execute($query); |
| | I am now in a problem to prompt user at the first run of my program. The Server is msSql Server 2008 R2 and Plaform vb.Net 2010. At the time of starting, the program starts to search the file, where the ConnectionString is saved. If it get then well else … |
| | Greetings I want to optimize a SQL Query. The problem I have a database full of such Queries and I need help for optimizing those Queries the problem with the Query is that it contains dozens of CASE blocks and within those CASE blocks there are calculations the Query results … |
| | Hi if myTable has a column like Col 10 7 3 5 9 4 How can I select three smallest numbers? my resultset should be 3 4 5 I don't prefer the following; with myT as (select col from myTable order by col) select top(3) from myT Any better idea? … |
| | How do I get average of the duration for multiple weeks. Currently I get something like Student Avg completion time Week Year STUDENT 1 0 1 2013 STUDENT 1 5 1 2013 What I want is Student Avg completion time Week Year STUDENT 1 2.5 1 2013 <code> select a.student,avg(a.duration) …  |
| | I have a simple sql table with four columns The data types are Athlete nvarchar(30) Mydate date Mytime varchar(8) Session nvarchar(40) Sample Data **Athlete Mydate Mytime Session** Jerry 14/07/2014 00:00:32 200M Jerry 14/07/2014 00:00:31 200M Jerry 16/07/2014 00:00:59 400M Jerry 16/07/2014 00:00:57 400M Jerry 16/07/2014 00:00:58 400M Now what i … |
 | I am receiving a Code in sms like "yyyy/mm-digit" (digit increments with every message). so i want to ensure that the code sent by user is exactly in that format otherwise another action. So how ? Here is my code to check but it always execute else block, why ? … |
 | I am trying to calculate days between two dates so that I can find out if they fall in the 30 / 60 / 90 day bracket The calculation I am using is working fine ` DATEDIFF(day, dbo.TblReturnDetails.RcvdDate, { fn NOW() })` what I am trying to do now is … |
| | Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 O 01/03/2014 18:00 02-0009 I 01/04/2014 8:00 02-0009 O 01/04/2014 18:00 For every date there should be a 'I' and … |
| | i am trying to figure out the syntax to do a SQL inner join from 2 different databases... The sameple code looks like this: select * from database1.dbo.table1 t1 join database2.dbo.table2 t2 on t1.field1 = t2.field2 but I dont know how to refernce the " database1.dbo" and "database2.dbo" parts.. can … |
| | I need to setup SQL Server Express using the command line and also make the installation unattended I tried many command lines however each one of them did not work here is the last one: Setup.exe /ADDCURRENTUSERASSQLADMIN="True" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVIC" /AGTSVCSTARTUPTYPE="Disabled" /ASBACKUPDIR="Backup" /ASCOLLATION="Latin1_General_CI_AS" /ASCONFIGDIR="Config" /ASDATADIR="Data" /ASLOGDIR="Log" /ASPROVIDERMSOLAP="1" /ASSVCSTARTUPTYPE="Automatic" /ASTEMPDIR="Temp" /BROWSERSVCSTARTUPTYPE="Disabled" … |
 | I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time … |
The End.