2,935 Topics
 | |
| | 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, 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 … |
| | 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'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 … |
The End.