2,736 Topics
 | |
| | HI, I have a requirement where I need to compare the data in different database(tables having same structure/schema). I know manually I can execute the queries in each database, compare the results and it is done. As this execution is repetitive in nature, how I can automate this. Thanks In … |
| | Hi there, I have a project created in C# visual studio 2008 standard edition and I am using a Microsoft SQl database file. I took my solution project in a filer and tried to run the application, going to the project folder and to the bin folder -> Debug folder … |
| | Hey using the following sql [code] SELECT DB_SALGSPRIS from pris_interval WHERE DB_INTERVAL_START < '11.78' AND DB_INTERVAL_END >= '11.78' SELECT DB_CUSTOMER from pris_interval WHERE AND DB_INTERVAL_START < '7.19'AND DB_INTERVAL_END >= '7.19' [/code] I get multiple results, 3 from first, and 2 from the second to be precise, what I am wondering … |
| | [CODE]Select CONVERT(VARCHAR,[Last_Edited1],106) As [Date], count([Lead_id]) as [Total Lead] from Avalan_cus Group By CONVERT(VARCHAR,[Last_Edited1],106) - (Select Count([Lead_Id]) from avalan_cus where [Lead_Id] in(Select Leadid from avalan_extract)Group By CONVERT(VARCHAR,[Last_Edited1],106))[/CODE] how can i do like this....i hv to substract  |
| | [code=php]<?php $host = "Localhost"; $user = "User"; $pass = "Pass"; $db = "DB"; echo "<b>This will test your SQL Server connectivity...</b>"; /********** testing connectivity ***************/ echo"<font color = 'green'><br>connecting to Server....<P>"; $link = mssql_connect( $host, $user, $pass); if( !$link ) { die("<font color = 'red'><p>Failed to connect to server: database … |
| | I know, is a very basic question, but I am in the process of re-learning sql stored procedures, and this is what happended: I was practicing with some simple delete / insert routines, when encountered with this: if I ONLY insert records: 1. dog 2. cat 3. t-rex 4. llama … |
| | Hi, select row_number() over(order by b.inv_no) as sl_no,b.fyear_code,b.inv_no,b.inv_date,b.service_nature,b.inv_total,c.bal_amount,b.client_code,b.amt_received from fn_receipt a, trn_invoice_history b, mst_expenditureinvoice c where a.client_id=b.client_code and a.client_name=b.client_name and a.location=b.client_location and a.receiptno=35 and b.fully_recived not in ('Y') and b.amt_balance>0 and (c.fyear_code=b.fyear_code and b.inv_no=c.inv_no) union select row_number() over(order by b.inv_no) as sl_no,b.fyear_code,b.inv_no,b.inv_date,b.service_nature,b.inv_total,c.bal_amount,b.client_code,b.amt_received from fn_receipt a, trn_invoice_history b, mst_invoice c where … |
| | This is a User Defined Function to perform simple encryption on an input string. This is performed by transposing the ASCII value of each character in the string by the increment value (@increment in the parameter list) Pass the function the string you wish encrypted and the increment value, which … |
| | I'm running MSSQL Server 2008 I did this: set CLASSPATH= C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar (I dont know where I can check if this has been executed correctly) Then when approaching this URL: [url]http://localhost:8983/solr/db/dataimport?command=full-import[/url] Using this data-config.xml: [code=xml]<dataConfig> <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost:1433;databaseName=wedding" user="sa" password="r00kw0rst" /> <document name="weddinglocations"> <entity name="location" … |
| | i have procedure like this select count(*),sum(Transaction_Amount),dateadd(hour, datediff(hour, 0, Created_On), 0),convert(nvarchar(10),Created_On ,105) from Collect_Transaction where convert(nvarchar(10),Created_On ,101) between @Date_From and @Date_To group by dateadd(hour, datediff(hour, 0, Created_On), 0),convert(nvarchar(10),Created_On ,105) order by dateadd(hour, datediff(hour, 0, Created_On), 0),convert(nvarchar(10),Created_On ,105) but it displays time when it has an entry . but when it …  |
| | [CODE]declare @Search_String nvarchar(50); set @Search_String =null select * from Punnu1 where Column11 like case when @Search_String is null then '%%' else '%'+@Search_String+'%' end[/CODE] i have a query like this . but this does not take any element in column1 with values null. what should i do to take query with … |
| | Hi. I am new to this forum/community and need help to join multiple result sets in SQL. The last time I used SQL was in 2000. The goal is to provide one single data set result from multiple queries. I have included the code from two queries that I have … |
| | I have some text with Cyrillic and Latin (š, đ, č, ć, ž). How can I store that data in MS SQL 2008. I tried to store word 'Palačinka' but instead of 'č' i get 'c'. |
| | I know this is probably a stupid post but I cannot think of how to accomplish this. How do you do the equivilent to an autonumber in a SQL Server table? Please let me know my project is very close to deadline Thanks in advance |
| | Good Morning, I have inherited a database that I am not happy with the structure of. In the system there are components on the web application it reads as Level1, Level2, Level3. The tables are set up as Component ->Level1 Component ->Level2 Component ->Level3 The component table houses the level … |
| | I have alot of tables in database in one of this contains owner_id and another one have relation many to many with that,and that table have dissent_type how i can select dissent_type where owner_id = "" |
| | Hi All, I have been pulling my hair out over this one. What we are trying to do is pull sum values for the same item out of three different tables in the same DB (MSSQL '05) – Should be quite straight forward however... The result should look a bit … |
| | Hi, Is there any way to do this? I tried using a 'select scope_identity()', but that returns null, apparently because my identity column is not a numeric of any sort. An answer to this would help me a lot! I would love to not have to use an integer or … |
| | Hello Everyone, I need to upload excel sheet in to the database. Which i am doing with the query [CODE] SELECT * INTO temp FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Dokumente und Einstellungen\l.varada\Desktop\BA-Control.xls', 'SELECT * FROM [qry_BA_Controlling (Report)$]')[/CODE] Here C:\Dokumente und Einstellungen\l.varada\Desktop\BA-Control.xls is the path from where the excel file needs to be … |
| | [TEX]Hi, Can anyone tell me how to retrieve an image from mysql along with other columns of different datatype to a jsp page? [/TEX] |
| | Hello So, recently I obtained a horrid assignment from lé boss, and I have yet to figure out how to do this. The idea is to select the ID(db_medlem) of all customers that have purchased for over 1000, in the year 2010. (I know its a funny syntax, but its … |
| | Below are my stored procedure to change password and the VB.net code to call it. The Sored Procedure executes properly and returns correct values when executed from SQL Server directly, but it does not check its conditions and returns -1 when called from VB.net code. please help me in this … |
 | hi, not sure if im posting in the correct section but im working on a site registration for a mate this bit has been completed, however i am wanting to extend this and display a plethora of info but i have hit a bit of a wall. iam wanting to … |
| | hi, I need to update my data in two tables simultaneously,for example if i update product id in one aspx page it should be updated in my sql tables where i use product id in all my pages we can join tables to view data but how to update.. hope … |
| | Question: I just recently had a cut over for a web application using a SQL DB that was previously using xp_sendmail to dispatch messages to the users. In accordance with the cut over, xp_sendmail is no longer usable in Server 2005 and should be replaced with sp_send_dbmail. Previously, the emails … |
| | Okay, so I've got THREE MSSQL Tables. First table is: Eponyms : ID, NAME, DESCRIPTION, CATEGORIES Second table: Categories : ID, CATEGORY Third is the intersecting table: EponymCategory : ID, EponymID<FK>, CategoryID<FK> The "Eponyms" table has the list of Eponyms, and the CATEGORIES column is inserted with data like "PSYCH … |
| | Hi, I'm a recent IT graduate, I want to upgrade my skills from what I learnt at college to the SQL Server 2008 platform. I want to also get certified with Microsoft, it seems a lot of companies are asking for this now. If you have gone through the certification … |
| | I am using a custom made application that is using MSDE 2000 transact SQL. Thing is that I've made a simple batch file in order to save databases automatically every day but it seems I made a mistake... I never expected the server to save in the same file if … |
| | hi any body plz help me I want to create new table from an existing table with data and definition. |
| | Hi I am using SQL express 2005 and I need to be able to take old data (data inputed two weeks ago or older)from a table in data base A and move it to a table in database B. I have very little experience with SQL so any suggestions will … |
The End.