Microsoft SQL Server Forum

Anyone can help on , How to remove the duplicate records. Anyone has implemented it ?

I have two set of data Table A and Table B Table A Day Catgry Sat Shift Mon Working Tue Leave Wed Working Thur Working Fri Working

Inserting multiple rows with a single INSERT INTO

Is there supposed to be a "null" in this stack trace Login failed for user on NT SYSTEM' ASystem.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +394 ASystem.Data.ProviderBase.DbConnection.GetConnection(DbConnection owningConnection) +215

Hai, i'm a fresher.. now i'm working on datalist control in asp.net, now i want to join query for this purposes.. i have the three table, tblstudent, tbllang, tblstudlang, i want to bind the columns name of firstname and courseoffered from tblstudent and its id is studentid, and languagename from tbllang and first its joining with...

Hi, I am working on SQL 2008 database. In Micosoft SQL server Management studio, i am trying to insert multiple records at a time in a table, using this query insert into test1 values(6,'san6',1),( 7,'san7',1); Error: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ','.

hai, i have a three tables one is tblstudent(uniqueid=studentid), tbllanguage(uniqueid=languageid,),tblstudlang(languageid and studentid) now i want studentname from tblstudent and languagename from tblstudlang how to write a join query of this? help me..

I am rather new to SQL Server management. I use SQL Server Management Studio 2014. I know how to add a user to SQL server and then take the user and give access to the databases. Can you take users group them together and give that group access to a database?

I have a report that I would like to add a column and then take a Material Type from another column and multiple it by a value. The variable is that Material Types change and the multiplier is different for each Material type. Example: Material Type = Paper X by 200 Material Type = Wood X by 300 Material Type = Rock X by...

Can you move a SQL Express database from one PC to another PC using a USB device? If so how?

I have a stored procedure that needs to run on the first day of every quarter. Can someone point me in the right direction? Thanks.

Hello! I have a table in a database where there is a column called DATE (datetime type)that logs the date/time of an event.The first index of the table it represent the start date/time and the last index of the table represent the final date/time. How can i make a query that returns the duration between the start date/time and final date/time?...

Hi alL, I have three dropdownlists for the filters the datagrid, like QUALIFICATION, SKILLSET, STATUS.. now if i have selected on the dropdown of ddlqualification, but ddlstatus and ddlskilsets are in 'ALL' position, and same like that STATUS and SKILLSET.. i wrote the following query eith the if condition Dim sSQL As String = ("...

I have an SQL Query that works very well with one exception... (I guess you could say it doesn't work THAT well). I have it retrieving the information I need, but the data comes back in TWO rows and I need it in one. Here is my query: SELECT AssignmentLink.ItemType, AssignmentLink.UH, AssignmentLink.ItemUH,...

Hi all i want to get the column like wednessday,September 10,2016, i wrote the following query, but still i did not get the day my query is, select (Convert(VARCHAR(11), Worship_date, 106)) as Worship_date from tbl_Worship Thanks in advance

Hello there, can anyone help me out with this problem? How to Query this: https://s13.postimg.org/bbdwjj4jr/Attachment.png My query code: SELECT TOP 1000 ,

Hi everyone, I am looking to get a memo field sent via email using a trigger. I have a table, and when a new line is added, a trigger is setup to send an email alerting a few people. There is a memo field in the table that I would like to include in the email, but when I tried to do that, it would not let me. I did a little bit of...

Private Sub update_Click() Dim intCurrentRecordNum As Integer Dim strCurrentInvoice As String intCurrentRecordNum = Me.CurrentRecord strCurrentInvoice = Me.invoiceNo Dim strUpdateSQL As String strUpdateSQL = "UPDATE invoice Set total =! where invoice.invoiceNo=strCurrentInvoice " DoCmd.RunSQL...

Hi , I would like to convert the datadiff to hours,minutes and second and total up batch time and build time in different column . Can expert show how this can be done in below query? SELECT file_name, org_rcvd_dts, DateDiff(hh, bld_start_dts, bld_end_dts) AS Batch_time, DateDiff(hh, cnv_start_dts, cnv_end_dts) AS...

I've been asked to edit a script. Several of the select statements have date parameters in the where clause. I'm trying to write a simple @Start_date and @End_Date. The fields are DATETIME. I need to get the first of the month in MMYYYY format for the @Start_Date and the last of the month in the same format for @End_Date. I'm new to sql...

I am using SQL Server Management Studio and need to convert all VARCHAR columns to NVARCHAR of a database. Is there a tool or something similar to do the conversion in one or few steps? It should be applied to different databases.

There is a SQL server database used at our company. It is going to be be open to all employees that have an active directory account (approx. 400+). How can I add these employees to the database without having to add then individually into SQL. Thanks in advance.

Background: VS 2015 - VB Windows Form Application SQL Server 2008 Outlook PRO 2016 I want to read my Outlook contacts (global address list) and put them in a datagridview or combo box. I have found some routines on the web but they do no work. I found this one but I get an empty combobox. What is wrong? Thanks in advance for your help.

Background: MS SQL Server 2005 How do check a field for one of two values? I have a field Status in SQL that can a "A" or "I" or "W". I want to check it for a "A" or "I". How can I do that? Thanks.

Hi I have a this Table; +-----------+--------------+------+---------------------+---------+-------+----------+-------+ | StudentID | AcademicYear | Term | StudentName | Class | Marks | Position | Count | +-----------+--------------+------+---------------------+---------+-------+----------+-------+ | 12013 | 2015 | One...