Firstly, the "100% cost" just means that your clustered index scan/seek accounts for 100% of the cost of that query. It doesn't mean that the query is less efficient than it would be without that index. Secondly, you need to design your indexes...

SqlDataSource

SQL-Server

Cluster index taking 100% cost in SQL

27 Feb 2024 by Member 11776570

If i have created cluster index it should work faster than other. But when i check execution plan it show me 100% cost for it. Below is the example Table1 Col1 Col2 Col3 CREATE CLUSTERED INDEX LK_table1 ON Table1 (Col1, Col2, Col3) But i have...

SqlDataSource

SQL-Server

Need to get data from it

8 Jan 2024 by OriginalGriff

Don't do that. Don't store CSV data in a single column, it's wasteful, inefficient, and leaves you with nasty problems whenever you want to use the data or change it. SQL string handling is ... um ... poor, so you have to jump through a lot of...

SqlDataSource

SQLEXPRESS

SQL-Server

Need to get data from it

8 Jan 2024 by Member 11776570

Below is the column data that has data in it. {"",11750,"","","","","","","","","","","","","","","","","","","","","","",""} ...

SqlDataSource

SQLEXPRESS

SQL-Server

Need to fetch notes from next record in SQL table

10 Nov 2023 by Maciej Los

There's few ways to achieve that. I'd like to provide a sample with Common Table Expressions: ;WITH CTE AS ( SELECT 1 Lvl, acctnum, note, srno, note newnote FROM Table1 WHERE acctnum IS NOT NULL UNION ALL SELECT C.Lvl +1, C.acctnum,...

Need to fetch notes from next record in SQL table

10 Nov 2023 by Richard Deeming

You haven't specified which version of SQL Server you're using. Assuming 2017 or later, the simplest solution is to use STRING_AGG[^]: SELECT acctnum, STRING_AGG(note, ' ') WITHIN GROUP (ORDER BY srno) As note FROM YourTable GROUP BY...

Need to fetch notes from next record in SQL table

10 Nov 2023 by Member 11776570

Below is the table t1 in SQL with column like this, srno is the sequence just use to move cursor. acctnum(c1) note (c2) srno 12 abc 1 efd 2 xyz 3 15 pqr ...

How I can fix the following error in SQL statement

27 Oct 2023 by Ahmed Said Oct2023

IF (SELECT T0.[Price] FROM ITM1 T0 INNER JOIN OPLN T1 ON T0.PriceList = T1.ListNum WHERE T1.[ListName] = $[RDR1.U_SBO_PriceList] and T0.[ItemCode] = $[RDR1.ItemCode]) > $[RDR1.PriceBefDi] BEGIN (SELECT T0.[Price] FROM ITM1 T0 INNER JOIN OPLN...

SqlDataSource

How I can fix the following error in SQL statement

26 Oct 2023 by Pete O'Hanlon

Without knowing the data types of the different fields in your query, this is impossible to answer. What we do know is that one of your fields is a string (NVARCHAR), and you are trying to treat it as a number. Take a look at the types of your...

SqlDataSource

How to hide a column name from the table

28 Dec 2022 by Member 12605293

Hi All I need to hide a particular Column Name from the result table but that datas should be stored in the Database.Should not be deleted,but Just it should be Invisible.What I have tried:Since i am new to sql i need proper Guidance from the experts here.Please Solve my query

How to hide a column name from the table

28 Dec 2022 by Member 15878627

I need to declare the column, but I need to hide it.

How would I go about doing this question

19 Oct 2022 by chilly45

create table customer ( CustomerID int primary key, FtName varchar (48), LtName varchar(48), Email varchar (75), Town varchar (75), Parish varchar(75) ); create table Vehicle( LicensePlate varchar(48) primary key, /*Primary key for...

How would I go about doing this question

19 Oct 2022 by OriginalGriff

Use a JOIN instead of SELECT ... FROM Table1, Table2, Table3 The latter combines all rows from all tables, the former returns matching rows based on a relationship between them: SQL Joins[^]

Fatal error: uncaught pdoexception: SQLSTATE[HY093]: invalid parameter number: number of bound variables does not match number of tokens in

19 Jun 2022 by Member 15679248

I dont understand why i get the above error if($_POST['agentdetailsbtn'] && $_POST['propertynum']) { $propnumber = $_POST['propertynum']; echo(''."\n"); $sql = "SELECT Property_number,...

SqlDataSource

PHP

Fatal error: uncaught pdoexception: SQLSTATE[HY093]: invalid parameter number: number of bound variables does not match number of tokens in

19 Jun 2022 by Richard MacCutchan

$sql = "SELECT Property_number, buildingtype, Address, agent_id FROM property WHERE Property_number = ':propertynumber'"; The single quotes around ':propertynumber', means that PHP will treat it as a string literal and not as a parameter...

SqlDataSource

PHP

Unable to cast object of type 'system.int32' to type 'system.byte[]'.

4 Apr 2022 by ahmedbelal

i design desktop application for Customer i coding Edit Form My Error is Unable to cast object of type 'System.Int32' to type 'System.Byte[]'. i clicked f10 to debug my Application My Error Here || || || __ \/ byte[] pa_img =...

Unable to cast object of type 'system.int32' to type 'system.byte[]'.

3 Apr 2022 by M Imran Ansari

In exception, error showing you are converting byte[] to int. Below line of code is throwing this exception Where you are converting byte[] pa_img...

I need solution for system.formatexception: 'the string was not recognized as a valid datetime. There is an unknown word starting at index 0.'

16 Mar 2022 by ahmedbelal

i need to Edit row in database from DataGrid View the Problem is i need solution for System.FormatException: 'The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.' i click f10 and compiler work my...

I need solution for system.formatexception: 'the string was not recognized as a valid datetime. There is an unknown word starting at index 0.'

16 Mar 2022 by Maciej Los

If f_Patient.dateTimeNOW is a DateTimePicker Control[^], you need to pass proper date/time value instead of string! So, this is wrong: f_Patient.dateTimeNOW.Text = this.DGV.CurrentRow.Cells[7].Value.ToString(); try: f_Patient.dateTimeNOW.Value...

I need solution for system.formatexception: 'the string was not recognized as a valid datetime. There is an unknown word starting at index 0.'

16 Mar 2022 by OriginalGriff

We can't help - we have no idea what part of that is working on what value. All we - and presumably you - know is that something is trying to parse a string to a DateTime value, and it's probably the dateTimeNOW.Text property assignment. And we...

I need solution for repeat items in datagridview

14 Mar 2022 by ahmedbelal

i need solution for repeat items in DataGridView i design form for Patients , i try to show Patient List in dataGridView But when i closed form and open DataGridView For Patient Again , Patient List is repeating for Example i have 10 row for...

I need solution for repeat items in datagridview

14 Mar 2022 by Jay Stewart 2021

private void button1_Click(object sender, EventArgs e) { this.Close(); this.DGV.Rows.Clear(); DGV.DataSource = null; }

My search with radio button in C# doesn't work

3 Mar 2022 by Abderrahmane Radiohead

https://pasteboard.co/EQ5pZtyR...

SqlDataSource

My search with radio button in C# doesn't work

3 Mar 2022 by Maciej Los

If you want to filter only DataGridViewRows, use DataView.RowFilter Property (System.Data) | Microsoft Docs[^] // Filter by an expression. var yearOfPublication = 2000; DataGridView1.RowFilter = $"date_publication.Year = {yearOfPublication}"; ...

SqlDataSource

My search with radio button in C# doesn't work

2 Mar 2022 by Luc Pattyn

Hi, one way would be to use a DataTable and a BindingSource. The DataTable is to hold all the books. The BindingSource is a go-between that passes the DataTable to the DataGridView; it has a Filter capability. DataTable dt = new DataTable();...

SqlDataSource

How to hide a column name from the table

28 Apr 2021 by Member 13670411

Microsoft needs to add a native function in T-SQL to exclude columns in a SELECT query when using a wildcard. SELECT *,-t.[RecordID],-t.[Date] FROM dbo.sometable t I'm selling the movie rights to Star Wars for free!

How to delete from trades table when part id not exist on mapping table code type from and code value from?

14 Mar 2021 by ahmed_sa

How to delete from trades table when Part id not exist on mapping table code type from and code value from? How to delete from table trades where Part id not exist on mapping table on code type from and code value from I work on sql server...

How to delete from trades table when part id not exist on mapping table code type from and code value from?

14 Mar 2021 by Maciej Los

I don't know what exaclty you want to delete, because the description of your issue is no clear, but... seems you wnat to join mapping table to trades table. DELETE t FROM trades t INNER JOIN mapping m ON t.CodeTypeId = m.CodeTypeFrom OR...

How to fetch a persons team count based on manager_id relationship in SQL

11 Mar 2021 by Virendra S from Bangalore, Karnataka

SELECT COUNT(*) FROM [dbo].[tblEmployeeMaster] WHERE MGR_ID=@EMPID table tblEmployeeMaster is having key columns emp_no,emp_name,mgr_id. Here I want fetch count of a person's reportees, child reportees(nth level) that means his total team...

How to fetch a persons team count based on manager_id relationship in SQL

11 Mar 2021 by Virendra S from Bangalore, Karnataka

WITH CTEORG AS ( SELECT Emp_No, Emp_Name,MGR_ID,DOL,LEAVING_ACTION_DATE FROM [tblEmployeeMasterLive] WHERE MGR_ID =@EMP_NO AND CONVERT(DATETIME,DOJ,103) =...

How to fetch a persons team count based on manager_id relationship in SQL

10 Mar 2021 by CHill60

Would give you a fully worked example but I'm just about to go into a meeting. I did something similar in my article about loops in SQL Server - see Processing Loops in SQL Server[^] the section about "Traversing a Hierarchy". You can then...

How do I delete an entry in SQL

10 Mar 2021 by DragonChasm

I'm kinda beginner in sql but am getting this error- "The DELETE statement conflicted with the REFERENCE constraint "documents_fk15". The conflict occurred in database "RD_Doc", table "dbo.doc_source", column 'document_id'. The statement has been...

SQL

SqlDataSource

How do I delete an entry in SQL

10 Mar 2021 by k5054

To delete the related records manually, without changing the foreign key to use the CASCADE option, you can do it in two steps: delete from doc_source where document_id = 209965; delete from documents where document_id = 209965; You may want to...

SQL

SqlDataSource

How do I delete an entry in SQL

10 Mar 2021 by Richard Deeming

You are trying to delete a record from the documents table, but you have related records in the doc_source table which depend on the record you are trying to delete. You will need to delete the related records from the doc_source table before...

SQL

SqlDataSource

Crystal report requires logon on every report loading using C#

6 Jan 2021 by Sherif Clemnt

can anybody solve a issue that occurs every time when i loading crystal report, it is asking for logon information What I have tried: private void button1_Click(object sender, EventArgs e) { if (TxtCustomer.Text == "" && TxtSONofrom.Text == "" && TxtSONoto.Text ==...

.NET3.5

SqlDataSource

CrystalReports

Crystal report requires logon on every report loading using C#

6 Jan 2021 by thatraja

You need to pass logon info dynamically in your code to avoid this issue. Agree with others, take a look at SQL Injection. C# Crystal Reports Dynamic Logon parameters[^]

.NET3.5

SqlDataSource

CrystalReports

How to select SQL compact file path by a button?

25 Nov 2020 by Alex Dunlop

Hi, I want to make SQL Compact file path selection dynamic so user would select their own file. I can get user's selected file path using following code: private void FilePath_Click(object sender, EventArgs e) { ...

SqlDataSource

How to select SQL compact file path by a button?

25 Nov 2020 by OriginalGriff

Try: SqlCeConnection myConnection = new SqlCeConnection(); myConnection.ConnectionString = $"Data Source={txtPath.Text}";

SqlDataSource

HOW to GET a RETURN from a STORED PROCEDURE, using C++, THAT HAS NO PARAMETERS, ONLY an OUTPUT

28 Oct 2020 by inlandchris1

I have finally found it reading the docs: After you do a fetch, now, get the data from SQLGetData. Works with the output param or input_output param but SP has only an output. AlarmCount has the data (long). retcode =...

HOW to GET a RETURN from a STORED PROCEDURE, using C++, THAT HAS NO PARAMETERS, ONLY an OUTPUT

28 Oct 2020 by inlandchris1

Here is the basic code taken from Microsoft docs. I had the biggest trouble connecting but found out, as you can see, the length of the DSN, username, and password has to be spot on. I will later put the size in a variable to clean it up. I...

Dear team need to create the edited grid view to store date and auto calculation in last column in ASP.NET

19 Oct 2020 by OriginalGriff

We are more than willing to help those that are stuck: but that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us...

Dear friends I have a task to show the date of working day using SQL.

8 Oct 2020 by Tan Chee Yong

Assuming your table name is TBL_Holidays and saturday, sunday are non-working days You can try this to get the working date: DECLARE @NoOfWorkingDays INT; SET @NoOfWorkingDays = 5; DECLARE @StartDate DATE SET @StartDate = '20201001' DECLARE...

SqlDataSource

SQL-Server-2014

SQL-Server

Dear friends I have a task to show the date of working day using SQL.

7 Oct 2020 by KriShna RaJendra N PraSad

Team, *I have a holiday list in Sql Table. *I have 2 services 1 and 2. *For service 1 need to add 30 days for the created date. *For service 2 need to add 5 days for the created date. Now I need to skip the holiday dates if the dates comes in...

SqlDataSource

SQL-Server-2014

SQL-Server

How do I control the radio button in ASP .NET?

30 Sep 2020 by Member 14935968

#plz help me!! in one radio button 7 list, if I select one radio button it hide some textbox as well as label also & how link the db also I created a stored proc for this in ssms? if (rd.SelectedValue == "Individual") { ...

How do I control the radio button in ASP .NET?

30 Sep 2020 by Gerry Schmitz

You've got the same "if" in both places (i.e. there is no effective "else") if (rd.SelectedValue == "Individual")

System.data.entity.core.entitycommandexecutionexception: 'an error occurred while executing the command definition. See the inner exception for details.'

21 Jul 2020 by gcogco10

Hi Team I have encounter this exception when i had to change the field name from the table on my database. System.Data.Entity.Core.EntityCommandExecutionException HResult=0x8013193C Message=An error occurred while executing the command...

System.data.entity.core.entitycommandexecutionexception: 'an error occurred while executing the command definition. See the inner exception for details.'

21 Jul 2020 by Sandeep Mewara

It could be one of the following: 1. no such table (dbo.TrainingRegForms) 2. table is there, but there is no dbo scheme (it might be in XYZ.TrainingRegForms instead of dbo.TrainingRegForms) 3. the db is case-sensitive, and the thus the table is...

Find all objects (like view, table, functions , parameters and variable , variable values ) in stored procedure

14 Jul 2020 by Member 11276381

Hi Team i am trying to get a query for below ask Find all objects (like View, table, functions ,parameters and variable ,variable values ) in Stored procedure but finding the query ,seems its not possible .anyone could you please help me ...

SQL

SQL-Server-2016

SqlDataSource

Find all objects (like view, table, functions , parameters and variable , variable values ) in stored procedure

14 Jul 2020 by MadMyche

Microsoft has documentation for a few different ways MS Docs: View the Dependencies of a Stored Procedure - SQL Server[^] MS Docs: SP_Depends - SQL Server[^]

SQL

SQL-Server-2016

SqlDataSource

How to save changes in db using multiple models in one view in ASP.NET MVC?

9 Jul 2020 by gcogco10

Hi Team I am struggling to save fields to my DB, at first i was using one model to save them and it was(TbRegistrationForm). Now my form uses multiple models in one View and my submit its not saving these fields to the table definition. What I...

C#5.0

ASP.NET5

SqlDataSource

How to save changes in db using multiple models in one view in ASP.NET MVC?

9 Jul 2020 by F-ES Sitecore

The answer depends on your table structure, but either have a model that comprises data for both tables that you use in your view, then programatically extract the properties from that single model and create the two individual models to save to...

C#5.0

ASP.NET5

SqlDataSource

Subtract from "device" column within the same row SQL (VB.NET)

1 Jun 2020 by OriginalGriff

You don't use a DataReader with an SQL UPDATE command - only with queries that contain a SELECT statement. Instead, use ExecuteNonQuery: Dim query1 As String = " Update verfication SET device = device - 1 WHERE serial=@serial" ...

Subtract from "device" column within the same row SQL (VB.NET)

1 Jun 2020 by Mohammad Abumoosa

I have two columns "serial" & "device".the user should write the serial number in the textbox. if it exists, it will deduct one from devices. my problem is that I am little bit confused and I don't know how I can subtract (1) from the same serial...

The term scaffold-dbcontext not recognized as name of cmdlet

10 May 2020 by Richard MacCutchan

See EF Core tools reference (Package Manager Console) - EF Core | Microsoft Docs[^]

The term scaffold-dbcontext not recognized as name of cmdlet

10 May 2020 by gcogco10

Hi Team My Scoffold-DbContext command does not seem to run and getting an exception. Basically i have an updated table definition on my database. I want my table definition to appear on my Model folder within MVC web application. What I have...

System generated excel import to SQL

2 Apr 2020 by Hemil Gandhi

I am trying to build web application in which I have to upload system generated excel sheet & import data to SQL, I have tried below mentioned code but it only works if I open the excel do save as excel before uploading it. Please help.. Also I...

System generated excel import to SQL

2 Apr 2020 by Richard Deeming

If you need to "save as Excel" before uploading, then the file you're uploading is not a valid Excel file. You need to fix the code that generates the file, rather than the code that processes it. As for deleting "some specific rows" before...

Incorrect column for pivot table

27 Mar 2020 by Richard Deeming

As the error says, the column names in your outer SELECT are incorrect. Try: SELECT sr, [Basic Salary], [Food Allowance], [Tuition Allowance], [Transportation Allowance] FROM ( SELECT sr = CASE when...

Incorrect column for pivot table

27 Mar 2020 by $ultaNn

I was trying to create pivot table from my query when i choose select * from it works fine but when i tries to select columns as shown in below code it gives me error Incorrect column name select sr,PayDescr,PayMonAmt from (select sr= case...

The INSERT statement conflicted with the FOREIGN KEY constraint

25 Mar 2020 by MadMyche

/* Msg 547, Level 16, State 0, Line 109 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Spec". The conflict occurred in database "Uzina", table "Dacia.tSpecializari", column 'codSpec'. The statement has been terminated. */...

SQL

SqlDataSource

database

The INSERT statement conflicted with the FOREIGN KEY constraint

25 Mar 2020 by Member 14782613

Create database Uzina use Uzina if(object_id('tUzina') is not null) drop table tUzina if(object_id('tDepartamente') is not null) drop table tDepartamente if(object_id('tSpecializari') is not null) drop table tSpecializari...

SQL

SqlDataSource

database

The INSERT statement conflicted with the FOREIGN KEY constraint

25 Mar 2020 by CHill60

You get quicker answers if you tell us exactly where the problem occurs. See insert into tSpecializari(codSpec,denumire,codDep) values ('CRS','Caroserii','UDM'), ('MTJ','Montaj','UDM'), ('FAB','Fabricatie','UDM') You have set up a constraint...

SQL

SqlDataSource

database

Get data by month and date from database

5 Mar 2020 by Maciej Los

[EDIT] According to the updated question: Your database design is wrong! You need to use date data type instead of string , because none of database is able to compare string by using [>] and [

SQL

SqlDataSource

PHP

Get data by month and date from database

5 Mar 2020 by Hello Infobekcons

HI, I have a fix date table with from_date and to_date, I want to get data between two dates via %m %d and my search date format is mm-dd. I have tried many thing but no solution. This is my query "select id from monthly_tool where...

SQL

SqlDataSource

PHP

Get data by month and date from database

5 Mar 2020 by CHill60

Hello Infobekcons wrote: I also tried to change column date format to %m %d. but no solution That is impossible. Date columns do not have a "format". See the comments from @maciej-los - you should be storing the data in your table as date NOT...

SQL

SqlDataSource

PHP

How do I update latest mid in nm table based on latest date present for that mid in mbr table.

26 Feb 2020 by Richard Deeming

It's not entirely clear what the relationship is between your tables, or what the conditions are for updating. But something like this should get you started: UPDATE N SET mid = ML.mid FROM nm As N INNER JOIN mbr As M ON...

SQL

SqlDataSource

How do I update latest mid in nm table based on latest date present for that mid in mbr table.

26 Feb 2020 by nithin793

mbr table eid date mid 1 13/01/2019 15 for eid 1,14 is mid for latest date 1 16/02/2019 14 2 22/06/2019 18 for eid 2,18 is mid for latest date 2 25/01/2018 ...

SQL

SqlDataSource

How to convert timestamp data of SQL into datetime or date

17 Feb 2020 by phil.o

You cannot convert a SQL timestamp to a datetime, unfortunately. How to convert SQL Server's timestamp column to datetime format - Stack Overflow[^] gives a deeper insight about it.

SqlDataSource

How to convert timestamp data of SQL into datetime or date

17 Feb 2020 by Member 11776570

I got data from sql source table like this ' 0x000000000EFFE662 '. I have to convert it to datetime or date. What I have tried: select convert(datetime, column_name,103) + CAST(column_name as DATETIME),* from [dbo].[table_name]

SqlDataSource

How to update all the mid to min based on eid present in other table

4 Feb 2020 by Maciej Los

Check this out: DECLARE @mbr TABLE(eid INT, mid INT) INSERT INTO @mbr(eid, mid) VALUES(1, 15), (1, 14), (2, 18), (2, 17), (3, 19), (3, 20) DECLARE @nm TABLE(mid INT, nmid INT) INSERT INTO @nm(mid, nmid) VALUES(15, 100), (14, 104), (18, 109), (17, 108), (19, 999), (20, 110) UPDATE t1 SET...

SQL

SqlDataSource

How to update all the mid to min based on eid present in other table

4 Feb 2020 by nithin793

mbr table eid mid 1 15 for eid 1, mid 14 is the min value 1 14 2 18 for eid 2, mid 17 is the min value 2 17 3 19 for eid 3, mid 19 is the min value 3 20 nm table mid nmid 15 100 14 104 18 109 17 108...

SQL

SqlDataSource

How do I write an update query to update to the min value by taking one id from other table

3 Feb 2020 by Richard Deeming

Your question is not particularly clear, but the following query should produce your expected output: UPDATE nm SET mnum = (SELECT Min(mnum) FROM nm As N2 WHERE N2.name = nm.name) ;

SQL

SqlDataSource

How do I write an update query to update to the min value by taking one id from other table

3 Feb 2020 by nithin793

mbr table mid mnum 1 10 1 11 2 12 2 13 3 14 3 15 nm table mnum name 10 x 11 x 11 x 12 y 13 y 14 z 15 z 14 z expected output nm table mnum name 10 x 10 x 10 x 12 y 12 y 14 z 14 ...

SQL

SqlDataSource

SEVERE: null com.microsoft.sqlserver.jdbc.sqlserverexception: the result set has no current row.

20 Jan 2020 by Kurt Jimenez

try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection("jdbc:sqlserver://;databaseName=Rental;user=MyAdmin;password=123456789"); Statement s = con.createStatement(); ...

SQL-Server-2012

Java8

SqlDataSource

SEVERE: null com.microsoft.sqlserver.jdbc.sqlserverexception: the result set has no current row.

20 Jan 2020 by Richard MacCutchan

ResultSet rs = s.executeQuery("SELECT Car_No FROM CarRegistration"); rs.next(); You are assuming that the resultset contains some data. You need to check first whether any rows are present.

SQL-Server-2012

Java8

SqlDataSource

SEVERE: null com.microsoft.sqlserver.jdbc.sqlserverexception: the result set has no current row.

19 Jan 2020 by Patrice T

Quote: the result set has no current row. May be you should check the number of records in result. Advice: Never calculate a next id by your code because one day or another, 2 users will create a new id at same time anf you will end up with 2 records with same id. Let the server handle it for...

SQL-Server-2012

Java8

SqlDataSource

How to make group by revision_ID and when repeated display last check date separated by stick | ?

17 Jan 2020 by Wendelius

I would advice not to concatenate the dates into a single field when fetching the data. This makes parsing the data unnecessary complex on the client side. Instead, why not just fetch the data in separate columns and add the logic to interpret the result to the calling program. This way the...

How to make group by revision_ID and when repeated display last check date separated by stick | ?

17 Jan 2020 by ahmed_sa

problem How to make group by Revision_ID and when repeated display last check date separated by stick | ? I need to group data by Revision_ID that make count to all zpartid every revision_ID Have group of parts . and when revision id repeated two time then lastcheckdate is firstdate |...

How can I amend the query to show info as per below, please?

20 Dec 2019 by MadMyche

What I would do is to populate a temp table with the original query, and then create a second query with 2 instances of that temp table joined to itself. (13:03 UCT)The query is relatively simple, but I need to get on the road now and don't have time to type it out... I will update this answer...

SqlDataSource

How can I amend the query to show info as per below, please?

20 Dec 2019 by Richard Deeming

Something like this should work: WITH cteSource As ( SELECT BTTLA, JPNUM, MAX(ACTFINISH) as PreLastDone FROM MAXIMO."BTV_ZZZ" WHERE SITEID ='XXXX' AND JPNUM in ('A', 'B') AND WOCLASS = 'ZZZ' AND ...

SqlDataSource

How can I amend the query to show info as per below, please?

20 Dec 2019 by Lu23

Current query: SELECT BTTLA, JPNUM, MAX(ACTFINISH) as PreLastDone FROM MAXIMO."BTV_ZZZ" WHERE SITEID ='XXXX' AND JPNUM in ( 'A’,B’) AND WOCLASS = 'ZZZ' AND ACTFINISH > SYSDATE-3 Group By BTTLA,JPNUM ORDER By BTTLA ASC Which shows this DATA: BTTLA PRELASTDONE JPNUM 103 20/12/2019...

SqlDataSource

How can I amend the query to show info as per below, please?

20 Dec 2019 by OriginalGriff

Run the query twice, once to gather only the A elements, then add a second to gather only the B elements. Then use a JOIN on the BTTLA value to combine the two together and return them as a single row.

SqlDataSource

How to find Birthdays between two Dates regardless of year

20 Dec 2019 by kananagaraj777

WHERE (Month(BDate) >= DATEPART(MONTH,'29-Oct-2019') AND Day(BDate) >= DATEPART(DD,'29-Oct-2019')) or (Month(BDate)

SqlDataSource

SQL-Server-2008R2

ASP.NET

How to find Birthdays between two Dates regardless of year

20 Dec 2019 by Member 12133159

I have list of records from which I have to extract Birthdays between two given dates, regardless of the year.That is, I want the birthdays falls between dates, say 2015-12-01 and 2015-12-31The simple between Query checks whether the Date of Birth fields falls between these two or...

SqlDataSource

SQL-Server-2008R2

ASP.NET

Sum label.text value in repeater ASP.NET C#

4 Dec 2019 by Nilesh Umaretiya

HtmlGenericControl lbBranchname = e.Item.FindControl("lbBranchname") as HtmlGenericControl; BranchName = lbBranchname.InnerText;

SqlDataSource

ASP.NET

Sum label.text value in repeater ASP.NET C#

4 Dec 2019 by nizam qbixx

Hye.. i have 1 problem that related to repeater in ASP.NET. im using repeater because i want my data to show like this:Size : S M L XLQuantity: 10 0 20 20 i have no problem to view like that.. my problem is, now i put one more column after the size/quantity that...

SqlDataSource

ASP.NET

Incorrect syntax near the keyword 'with'

16 Oct 2019 by srko

Hello Guys, I'm trying to create a CTE, but facing this issue while creating. Can anyone please guide me on this. What I have tried: ;WITH myCTE(fname , lname) as( select fname,lname from myTable ) select * from myCTE

Incorrect syntax near the keyword 'with'

11 Oct 2019 by OriginalGriff

Try using the same name in both places: WITH myCTE(fname , lname) AS( SELECT fname,lname FROM myTable ) SELECT * FROM myCTE

How can I add a foreign key reference ?

29 Aug 2019 by Member 11511491

Following is the explanation your query. Hopes this help you to get an idea. According to your requirement OrderItem table is the parent table. Order table is the child table. So Order table is reference with the OrderItem table. Following is the querry for this purpose. Alter table Order add...

SQL

SqlDataSource

How can I add a foreign key reference ?

29 Aug 2019 by Abdalla Ben Omran

How can I add foreign Key reference using Desgin or Query, it doesn't matter just i need to understand it very good . i will be so glad for an explanation about it . I have Order table and has (CustomerFirstName, CustomerLastName,Id,RecivedAt) columns and i have also OrderItem table and has...

SQL

SqlDataSource

How can I add a foreign key reference ?

29 Aug 2019 by CHill60

Please do your own research - this is a quick answers forum. The following free resources will explain Foreign Keys fully: Essential Guide to SQL Server FOREIGN KEY Constraint[^] The Essential Guide To SQL Foreign Key Constraint[^]

SQL

SqlDataSource

How can I add a foreign key reference ?

29 Aug 2019 by #realJSOP

Google is your friend. Goole search for "SQL Server what is a foreign key"[^]

SQL

SqlDataSource

Create Database backup in Solution folder on button click event mvc/asp.net

30 Apr 2019 by itsathere

I want to create my whole database backup just on single button click and inside solution folder.After button click .bak file will be downloaded.Note:-I need C# code to backup database on button click event and inside solution folder or in any folder whatever i need as per...

Connecting a .bak file of SQL server to visual studio

24 Apr 2019 by Member 13864666

Hi, So my problem over here is that, i have done back up on my sql database named 'SDP' then i have restored the sql backup file in another new PC. Now i would like to execute my vb.net program from the new PC. The problem i am facing is that the server name i have written in my codes are the...

SQL

SqlDataSource

SQL-Server

Connecting a .bak file of SQL server to visual studio

24 Apr 2019 by Richard Deeming

This is why you should always store your connection strings in your config file[^], as 0x01AA suggested in the comments. :) You might be able to get away with setting up an alias[^] for the old server. But you would need to set that up on every computer where you application needs to run.

SQL

SqlDataSource

SQL-Server

Connecting a .bak file of SQL server to visual studio

22 Apr 2019 by phil.o

You can try 'localhost' as generic server name on local machine. Make sure SQL services listen to address 127.0.0.1

SQL

SqlDataSource

SQL-Server

What SQL query should I write to extract data from three different columns and at the same time do arithmetics for one of them

9 Apr 2019 by User 14184581

I'm trying to extract some data using SQL queries from different tables I have already created. The tables are as follows: CREATE TABLE Students ( Student_ID INTEGER PRIMARY KEY, Enrollment_Year DATE, Course_Current_Status VARCHAR(18), First_Name TEXT, Last_Name TEXT, Gender TEXT,...

What SQL query should I write to extract data from three different columns and at the same time do arithmetics for one of them

8 Apr 2019 by Steve Grattan

You say you have tried this. I assume this is an attempt at the syntax (rather than it returning incorrect results) as there are errors: 1. Enrollement is not a table name - should be Enrollment 2. Program_Year_When_Enorolled - this is a misspelling isn't it? 3. avg_third_year_marks has been...

How to add multiple row of data to the datagridview which has the same id in database VB.NET SQL server

23 Mar 2019 by Member 13864666

Hi! My input is the invoice id where user refers the invoice id to search their order details. Now if user have made multiple orders under a single invoice id, there will be rows of data for order which has the same invoice id. Problem with my code is that it only reads the first row of data...

SQL

SqlDataSource

SQL-Server

How to add multiple row of data to the datagridview which has the same id in database VB.NET SQL server

23 Mar 2019 by OriginalGriff

We can't tell: we don't have any access to your data. So, it's going to be up to you. Fortunately, you have a tool available to you which will help you find out what is going on: the debugger. Put a breakpoint on the first line in the function, and run your code through the debugger. Then look...

SQL

SqlDataSource

SQL-Server