2,935 Topics
 | |
| | if @fromDate = Datetime.MinValue BEGIN set @fromDate = (select MIN(applicant_statuss.created_on) from applicant_statuss) end if @toDate = Datetime.MinValue BEGIN set @toDate =GETDATE(); end the following error is Comeing : Msg 107, Level 16, State 2, Procedure sp_InterviewerPerformance, Line 21 The column prefix 'Datetime' does not match with a table name or …  |
| | - I'm using ms sql and then i export the database and then i save that export DB at desktop.After that i delete the database in ms sql because i want to learn how to import the DB.My problem is cannot import the DB that i export before.Anyone can help …  |
| | Hi Guys, I am using SQL Server 2008 R2 on Windows Server 2008 Standard Edition.I tried to uninstall one of instances in SQL Server and I believe I "Select all the features" to remove from the Select the features windows.After uninstalling, I tried to run SQL server with another existing … |
| | I am using Windows Vista Ultimate. I was getting an error while installing MS SQL server express edition 2008 R2. I use VS 2008. I cannot find any any correct version of power shell on the internet. Please Help ! |
| | Hi everyone, I want to implement an "achievement" system of sorts into one of my projects. Similar to StackOverflow where if you do a certain thing or answer a certain number of questions etc you get a trophy that is linked with your user profile. The membership section of my … |
| | Hi. I'm having a problem with that code. Im getting this error: [I]Warning: mssql_execute() [function.mssql-execute]: message: Error de conversi�n al convertir una cadena de caracteres a datetime. (severity 16) (Translate: error converting string to datetime) Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed[/I] But I dont use datetime in this script! … |
| | Hi all, I need your help. I have an insert query which insert a few rows into the table A. TableA has two primary keys, which are fieldA and fieldB. The SQL is written as follows: INSERT INTO TableA (fieldA , fieldB, fieldC, fieldD) SELECT DISTINCTROW TableB.fieldA, TableB.fieldB, TableB.fieldC, TableB.fieldD … |
 | Hi guys. I know this is a long shot, but does anyone know if parallel computing (multiple simultaneous programmers/developers working on the same file) is possible for SQL databases? What I'm wondering if is possible is working on a local database that updates the mdf file in two computers, which … |
| | Is there a way to exclude column from a table or View or Stored Procedure without specifying all the columns in the Select List Especially with table or View |
| | Hi guys Ive created a piece of software to extract data from 2 fields in an mssql table, and using php translate them into a graph. Im now trying to extract the field names as titles for my axes. I'm using sqlsrv_query s and have retreived data from the table … |
| | I have a table named "Table1" Its schema with data is like this [CODE=text] Id col2 col3 col4 col5 isUnique dbUnique 1 red 3M 1995 UK 1 null 2 red 3M 1995 UK 0 null 2 red 3M 1995 UK 0 null 3 red 3M 1995 UK 0 null 4 … |
| | Hi. Here's my scenario: I have a native Windows service running on a machine. The service is installed under Administrator privileges. Once per day, the service fires, creates a login to SQL (using the administrator account), queries a specific database (read only). The database is stored locally (same machine) and … |
| | The date stored in my db is in the following format: 2011-06-10 17:15:26.000 2011-06-10 17:15:27.000 2011-06-10 17:15:28.000 2011-06-10 17:15:29.000 However I intend to retrieve the date above using the format below: 2011-06-10 How is it done? Your help is kindly appreciated. |
| | I'm trying to import a Visual FoxPro database into SQL. The database is a free table directory data base, and I can import all but 3 of the tables. All three tables that won't import give me the same error message, that the memo file is missing or invalid. I … |
| | hi , i ma using the reporting service in MS SQL express 2008. but in the company i don't have the admin previlages to upload and create reports to the server. if i was to ask from the administrator to grant me the previlages what previlages does he have to … |
| | I am taking a database course and we are required to create some SQL queries. So don't give me the answer if possible. Just let me know what is wrong with this code: [INDENT]SELECT p.pat_id, p.pat_first_name, p.pat_last_name, p.pat_dob, ph.phys_last_name, s.service_desc, v.visit_date FROM Visit as v LEFT OUTER JOIN Visit_Service as … |
| | I would like to auto-generate a column which has a mixture of both numbers and alphabets. Like AA01 or AC24. I want to start at AA00 until AA40. From here i will go to AB00 until AB40, and do likewise for other subsequent alphabets until the last one which will … |
| | Hi I m Having a Problem in retrieving records. I want to get nth maximum value in a column. I have tried it using top select top n ColumnName from tablename where(select top n-1 ColumnName from tablename order by columnName desc) But i m getting all the n records. Any … |
| | We have 4 tables with field types like NVARCHAR and SMALLINT and we have 4 tables in the same database with VARCHAR and SMALLINT. The all reside i the same MSSQL2008R2 database with a database collationtype LATIN_GENERAL_BIN. If we run a simple query on the VARCHAR tables it comes with … |
| | Can i insert data from mssqlserver to oracle using select statement |
| | Hi everyone, Thanks for viewing this post. I have a question about SQL. May i know how to remove rows that have NULL value in one of the colums. SELECT name, grade, age FROM education If let say grade 1 of the rows is NULL, how do i remove that … |
 | Hi In my compnay we use web based application and backend as sqlserver 2005.recently this backend is move into another new server.I restore database backup in new server.Issue is after 4 days I saw transaction logs file size is more that 16GB in new server .In old server transaction log … |
| | i want try to update the value of record from table1 where the value i need is from table2 like: table1 [CODE]Item_id | Quantity 0001 | 100 0002 | 200 0003 | 300[/CODE] [CODE]table2 Item_id | Quantity 0002 | 100 0003 | 50[/CODE] [CODE]when the query run.... i want the … |
| | In my application some stored procedures are not working properly in current database of SQL Server. I have taken backup of database 2 weeks ago and all stored procedures are working in backup database. I have checked the properties of current database and backup database both are same. After restoring … |
| | Can anybody plz help me.. i need to find all the users who are grater than 10 days old. table name users ,fild contain with registration dates.to store date i used DateTime.Today with C#.Can any body give me a sql query to slow this |
| | Here is the condition,i have a table with the records for every months per year. I would like to retrieve the records only for three months per year. Lets make this clear, the records would be around Jan~Mar or Apr~Jun or July~Sept or Oct~Dec. Current date is 1-May-2011, so the … |
| | Hey. i have a table that has the columns of A,B,C,D and another table that one of the coulmns the VALUES of A,B,C,D i am trying to subquery the 2nd table at the coulmn that stores the abcd. and the result act as a column name for the 1st table. … |
| | Hope someone can help [B]I am using Visual Studio 10 Languague VB [/B] It is web based and conects to remote SQL Server If i run a query on database connecting using Sql Server management studio this query give correct results which is to find minimum value in a column … |
 | Good Evening All I want to create a unique value for my User in Silverlight and access this value on the asp.net page that is part of the silverlight website. So i cant use cookies because they wont work and i cant do the client site cookie thing because it … |
| | Hi guys. I am an IT student currently 3 days into my work placement which is the mandatory 3rd year of my degree course. I am working for a charity in England and my first task is to transfer data from excel sheets to a microsoft sql management studio database. …  |
The End.