3,481 Topics
 | |
| | This SP is working well. But when recordcount in dbo.PTSGELEN is over 1000000 approx. it comes timeout error. ALTER PROCEDURE [dbo].[PTS2Tabloya] @KOLETIK nvarchar(40), @SIL tinyint , @EKLENEN int OUT AS BEGIN SET NOCOUNT ON; set @EKLENEN = 0 IF @SIL=0 AND LEN(@KOLETIK)=20 begin INSERT INTO dbo.URUNGIR (GTIN,SN,XD,BN,CLABEL,SLABEL) SELECT GTIN,SN,XD,BN,CLABEL,SLABEL FROM …  |
 | Hi, I have problems with getting data out of the **MS SQL Server 7.0** database in right encoding using **odbc** connection: $conn = odbc_connect("Driver={SQL Server};Server=$server;Database=$database; CharacterSet => UTF-8", $user, $password); I had the same problem when I used MS SQL Server 2005 and sqlsrv connection, but I found the solution. … |
| | I had two versions of SQLEXPRESS on my computer earlier ,now I have uninstalled 2012 SQLEXPRESS from my computer Now when I try to attach .MDF file made in 2012 version it gives me error. TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'My-PC\SQLEXPRESS'. (Microsoft.SqlServer.Smo) For … |
| | good day! im working on a migration tool for mysql to mssql. is there any references or codes that you guys can share to me to create databases and transfer data from mysql to mssql? ive just got this idea of using dump mysql files since they also have sql …  |
 | Hello friends, I am using sql server 2005 as a backend. I want to filter the datagrid based on fromdate,todate,companyname,employee name. I have done the date filter's.... The problem is with the other two filters. The actual problem is.. The application has to filter based on company only if the … |
| | Hi. I have developed project using visual studio 2012 in vb code. Application is running fine in my local machine. But In server it will show the error once excuting report. server is MS Server 2008 R2 with SP2. Here is the error . This is my senario Database: MSSQL … |
| | Hello, I am dealing with SQL server 2005 and i have data from a system where i am tracking an application at each stage in the system. i have data in a tabular form as follows and the dates are derived from an sql statement. how best can i write … |
| | Hi Guys, I have a requirements to backtrack 2 days if the date fall as Monday. Why? We dont have any transaction from Sunday to Monday at 6:00AM that's why need to backtrack 2 days. i want to share with you my query. if you have any additional idea to …  |
 | Im working through sprocs with MySQL and I came across something that made me quite uncertain... I learned sprocs with MSSQL and I am used to declaring as such: create ... myProc (@var type, @var2 type(xxx)) as .... and for declares, we declare vars as declare @var3 type(xxx), @var 4 … |
 | I was trying to connect MSSQL EXPRESS with Java. I was successfully connect with MSSQL SERVER with user name and password. but I can't connect a database which does not have user name and password. I was inserted "integrated security=true" in my code. But it is still unsuccessful. Help Me … |
| | Hi I have an issue in asp.net using vb code I am using Visual Studio 2012 with MSSQL 2005. I have problem in adding Report viewer, Version=11.0.0.0. I have an error "'ReportViewer' is ambiguous in the namespace ". Please anybody help me to solve this issue maideen |
| | I have a table which have some records,i need to loop through selected fields(say 10 to 14 with respect to 10).. if it finds any data from 11 to 14(with respect to 10) the value has to append to the field 10 for each corresponding row, sub fi_macr() dim strsql … |
| | Hi freinds i have developed a sync service by using MS sync SDK. It was working fine few days before but its not working. It does not showing any error in log. Please friends let me know if you are having useful suggestios to make the thing working. Thanks in … |
 | Hi to all, I like to start a new discussion after a long gap..Now i have a Question in Sql,I need to Take a difference in Current Month and Previous month,from get the diference i use the trigger to send a sms.. SELECT datepart(mm, dateadd(mm,-1,'2011/1/1') ) or SELECT DATEADD(MONTH,-1,GETDATE()).i need … |
| | Hi, I'm having some issues trying to figure out the way to find the percentage of parents with children inside my database. There is a table where all the parents are stored called XY and there is a table where all the children are listed called table Children. How would … |
 | hi everyBody, Can some one tell me the steps of how to make daily back up database from SQL Server 2008, when i do this Script and job it give me an error cant be completed, any help plz...  |
 | Hi, i want to create a query which select three columns from a table on certain condition now i have got certain with three columns and i can bind this data to a datagridview but before this i want to add a column to dgv say col_new and fill its … |
| | HI All, im working on a project that uses asp.net to send information to a mssql server. The problem im running into is that when i try to debug the page, I get: 'ClickSave' is not a member of 'ASP.default_aspx'. How Do I fix this?? Heres My html code(default.aspx): <html> … |
| | Hi All, I have a table space in which i have eight columns. The first column is Index which i kept as Auto_Increment starting from 1 so that i can see the number of rows of data anytime. The problem is, for example i have one row of data and …  |
| | Ok so what i want to do is break up a string after the lenght of the string is = to 160, then i want to add a line break..but all this needs to be done in the Select...can anyone help me with this thankx in advance select case len(COD_P2_Q1) … |
| | Hello every one i am seeking a user of joomla to help me a little. During joomla webinstaller database mssql is not connected it gives number error, now what to do??? Why mssql is not connected m using xammp server... |
 | Hi All, I am creating a simple query with a not so simple twist, at least it's not simple to me. First, the query: select distinct b.Bank_Mnemonic as [Bank],bd.Demo_Name as [Demography],ei.BEFI_Description[Economic Indicator],bsd.BSD_Year as [Year],bsd.BSD_Data_Value as [Value] from dbo.tblBank_Source_Data as bsd inner join dbo.tblBankDemographics as bd on bsd.Demo_ID=bd.Demo_ID inner join dbo.tblBanks … |
| | I faced to a huge problem when i coding some stored procedure. How to combine some string to sql string in stored procedure??? This is what i did upto now. @WhereCondition = ' WHERE id = 102 ' DECLARE recoredSet CURSOR FOR SELECT SUM(Amount) as AmountSum FROM sale + @WhereCondition …  |
| | Hey everyone, I am trying to create an excel spreadsheet that is populated with data from a table in sql server. I would like to make it so it will update several times a day with out the user having to do so. I have no clue how to go …  |
| | One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run … |
 | I am trying to learn SQL programming in my spare time, but I'm running into some issues. I currently have Visual Basic Studio 2010 installed, as well as Microsoft SQL Server 2008/2012. I've been told that I should be using MySQL to practice the coding. Should I lean towards MySQL … |
| | sir i have three sheet in excel..first sheet i have many colounm with filder option..in second sheet i have same coloum with filder option .IN third sheet also same ..sheet name only varying ..what i want is in first sheet i have one colounm name is form with filder( C,F,S)..IF … |
| | I am working in a dataware house and few things are not clear to me that is why I wanna discus here. For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like **Plz … |
| | Please am trying to create a database table that store image and display the image. I want to use vb.net to design the form for user to add their details and picture. i don't know how to go about it please help.Thanks  |
| | Hi All, I have an SSIS question regarding looping through CSV files with the Foreach Loop Container. What I have: 1. A string variable named fName - Global 2. A Foreach Loop Container 2.1 User::fName mapped to the loop container with an index of 0 3. A Data Flow Task … |
| | Hi All, Hopefully I don't get too scolded here for this question but I can't commit my mind to answer this as I have been ill and am still not fully recovered. In saying that, I have the following set of tables (see pic) and I need to fill in … |
| | I've built a SQL report in MS SQL Server Report builder for our ticketing backend. I want to be able to do custom reporting. I've created this report by using the following query: SELECT SR_Service.Date_Closed ,SR_Service.Date_Entered ,SR_Service_SLA_Workflow.Responded_Minutes ,AVG(SR_Service_SLA_Workflow.Resolved_Minutes) AS Avg_Resolved_Minutes ,SR_Service.Hours_Budget ,SR_Service_SLA_Workflow.SR_Service_RecID AS [SR_Service_SLA_Workflow SR_Service_RecID] ,SR_Service.SR_Service_RecID AS [SR_Service SR_Service_RecID] ,SR_Service.Company_RecID … |
| | I'm trying to delete a couple of rows USING SQL Server management studio, for 2 rows only i get the message No rows were deleted Error message A problem occurred attempting to delete row #X Error Source: .Net SqlClient Data Provider Error Message: String or binary data would be truncated …  |
| | using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication4 { public partial class Form1 : Form { SqlConnection clientConnection; string connString; public Form1() { InitializeComponent(); connString = "Data Source=ASPEE56\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True"; clientConnection = new SqlConnection(); clientConnection.ConnectionString = connString; } … |
| | ## Before You Ask ## - Engage your brain! We understand that running into a problem can turn off the rational centers of the brain, but please sit back and think for a bit about your problem before running off to find help. All too often a little common sense … |
| | Good Afternoon, I'm looking to connect to a MSSQL database on an external windows server, I'm creating a PHP script (on a linux server) which will pull data from the database so I can enter into my new MYSQL database. I would also be looking to specify the port number … |
| | Hi, I have a string formula and I wanted to execute it in sql server 2008 UDF function. Please suggest to proceed. P.S. I have tried with exec () - error occurred.  |
| | |
| | Hi All, This is something I should know but for whatever reason today it is eluding my mind. I'm trying to query our database to provide me with data between March 2012 and March 2013. Initially, I had the following line: where a.IPI_Ref_Date between '2012' and GETDATE() and the output … |
| | Need some help here. I was trying to make a Stored Procedure in MS SQL 2008 which will make use of comma delimited string as Parameter in my WHERE [COLUMN] LIKE [PARAMETER] condition. Somehow, I was able to select rows of data from my DB table that matches the set … |
| | Dear All ! I have a table member_email. i have 4 columns in it. Id Email CellNumber Carrier I want to create constraint who check following conditions, 1-Email can be null if Cellnumber is given , and Cellnumber can be null if email is given. 2-both email and cell number … |
 | i have crated a job to backup automaticly my database , when procees happen failure message appear , anyone can help me ?? thx BACKUP DATABASE [MYDATABASE] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup' |
| | hi. i have a problem in printing the report to printer. Now i can print the php reports, but it will open both printer dialog and page together. But I need only one to printer dialog box. Pls help me Below my code Connection database ` <?php try { $hostname … |
| | Hi I'm a newbie in SQL and for scores whose credit is greater than 2, I want to select students with scores of 10 or more .Here is what I wrote and Im having errors(See table below): SELECT Student,COUNT(Score)>=10 AS NumPasses WHERE Credit>2 GROUP BY Student Student Credit Score Tomy …  |
| | Hi All, With SSIS, upon load, I am receiving the following error: > Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1 I have gone through all of my connections … |
| | This is my SP code SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE SP_Get_Age @name varchar(20) AS BEGIN SET NOCOUNT ON; SELECT Age FROM PersonDetails WHERE Name1 = @name; END GO This is my C# code private void callSP(string name1)//name1 comes properly in button click event { using … |
| | I want to build a voucher system. I am developing an application and want users to login from a database (preferable MS SQL). I want the DB to randomly create codes for users to top up their accounts. The codes will be unique in that they will be based on … |
 | Hello, i want to develop a lan-based software (Enrollment System) using Microsoft Visual Basic 2008 and a Microsoft SQL Server. I am confused on the Microsoft SQL Server that im going to use, anyway, im just a newbie on programming :). Can you guys recommend a microsoft sql server that …  |
| | While trying to connect to MSSQL Server 2012 using pymssql,I get the following error. My server name in Windows Authentication is SARATH,User Name is Sarath\SarathShanker and I did not set a password. >>> mssql_conn=pymssql.connect(host='SARATH',user='Sarath\SarathShanker',password='',database='matrix') Error: Traceback (most recent call last): File "<stdin>", line 1, in <module> File "pymssql.pyx", line 556, … |
| | hi, how to convert db table column datatype from varchar to binary(16) in sql server 2005? thanks |
The End.