No announcements
Found 41690 threads
-
0 VotesSQL Query to Transpose dynamic Rows to Column
User-1641476077 posted Below is a sample of my schema design: <script async="" src="//s.imgur.com/min/embed.js" ...Unanswered | 2 Replies | 72 Views | Created by An0nym0u5User - Tuesday, May 4, 2021 9:41 AM | Last reply by An0nym0u5User - Wednesday, June 16, 2021 8:07 AM
-
0 Votes
SQL Query to Transpose dynamic Rows to Column
User-1641476077 postedBelow is a sample of my schema design: From the design above, different form might have different template id, I am wondering how do I ...Unanswered | 2 Replies | 202 Views | Created by An0nym0u5User - Tuesday, May 4, 2021 9:41 AM | Last reply by An0nym0u5User - Wednesday, June 16, 2021 8:07 AM -
0 Votes
Update table values and persist changes to second table that has same fields and identifier key column.
User1909155429 postedI would like to Update a table column values whilst at same time reflect those changes in another table that has same identity column and common ...Unanswered | 7 Replies | 176 Views | Created by An0nym0u5User - Wednesday, May 26, 2021 7:36 PM | Last reply by An0nym0u5User - Wednesday, June 9, 2021 7:28 AM -
0 Votes
Need most recent record by Date and Time for each item
User-718146471 posted Hello folks, I'm really stumped here trying to figure this out. What I'm looking to do is to grab the most recent record for each item. The query looks like ...Answered | 8 Replies | 42 Views | Created by An0nym0u5User - Friday, May 28, 2021 4:33 PM | Last reply by An0nym0u5User - Tuesday, June 1, 2021 1:24 PM -
0 Votes
Need most recent record by Date and Time for each item
User-718146471 postedHello folks, I'm really stumped here trying to figure this out. What I'm looking to do is to grab the most recent record for each item. The query looks like ...Answered | 8 Replies | 109 Views | Created by An0nym0u5User - Friday, May 28, 2021 4:33 PM | Last reply by An0nym0u5User - Tuesday, June 1, 2021 1:24 PM -
0 Votes
This query is very slow how to enhance it to be more faster?
0 then replace(PO.PortionKey,N'[',N'[[') ELSE Po.PortionKey END)) ,LTRIM(RTRIM(CASE WHEN Po2.PortionKey=N'Blank' THEN '' ...Unanswered | 3 Replies | 158 Views | Created by An0nym0u5User - Monday, May 31, 2021 2:46 PM | Last reply by An0nym0u5User - Tuesday, June 1, 2021 5:54 AM -
0 Votes
This query is very slow how to enhance it to be more faster?
0 then replace(PO.PortionKey,N'[',N'[[') ELSE Po.PortionKey END)) ,LTRIM(RTRIM(CASE WHEN Po2.PortionKey=N'Blank' THEN '' ...Unanswered | 3 Replies | 64 Views | Created by An0nym0u5User - Monday, May 31, 2021 2:46 PM | Last reply by An0nym0u5User - Tuesday, June 1, 2021 5:54 AM -
0 Votes
cant use select into statement
User-583959464 posted my sql server management studio v17.9 version doesn't support the following sql and tableB table structure is same as tableA. select * into ...Unanswered | 2 Replies | 54 Views | Created by An0nym0u5User - Monday, May 31, 2021 3:01 AM | Last reply by An0nym0u5User - Tuesday, June 1, 2021 2:20 AM -
0 Votes
cant use select into statement
User-583959464 postedmy sql server management studio v17.9 version doesn't support the following sql and tableB table structure is same as tableA. select * into tableB from ...Unanswered | 2 Replies | 125 Views | Created by An0nym0u5User - Monday, May 31, 2021 3:01 AM | Last reply by An0nym0u5User - Tuesday, June 1, 2021 2:20 AM -
0 Votes
Show all data from left table either the reference is exists in right table or not.
User1052662409 posted Hello Everyone, I have 2 tables tbl_Employee and tblOCBalance. According to my where clause table tbl_Employee have ...Answered | 4 Replies | 82 Views | Created by An0nym0u5User - Friday, May 28, 2021 7:38 PM | Last reply by An0nym0u5User - Saturday, May 29, 2021 3:28 PM -
0 Votes
Show all data from left table either the reference is exists in right table or not.
User1052662409 postedHello Everyone, I have 2 tables tbl_Employee and tblOCBalance. According to my where clause table tbl_Employee have 89 records and tblOCBalance ...Answered | 4 Replies | 114 Views | Created by An0nym0u5User - Friday, May 28, 2021 7:38 PM | Last reply by An0nym0u5User - Saturday, May 29, 2021 3:28 PM -
0 Votes
Update table values and persist changes to second table that has same fields and identifier key column.
User1909155429 posted I would like to Update a table column values whilst at same time reflect those changes in another table that has same identity column and common ...Unanswered | 7 Replies | 60 Views | Created by An0nym0u5User - Wednesday, May 26, 2021 7:36 PM | Last reply by An0nym0u5User - Wednesday, May 26, 2021 7:53 PM -
0 Votes
loop through a Datalist of image elements and set selected properties on client in javascript
User1909155429 postedI want to be able to select a image, change its property values to disable and opacity level to low while change rest images to both high opacity and enable. In Javascript code ...Unanswered | 11 Replies | 599 Views | Created by An0nym0u5User - Saturday, May 22, 2021 1:26 PM | Last reply by An0nym0u5User - Wednesday, May 26, 2021 7:46 PM -
0 Votes
loop through a Datalist of image elements and set selected properties on client in javascript
User1909155429 posted I want to be able to select a image, change its property values to disable and opacity level to low while change rest images to both high opacity and enable. ...Unanswered | 11 Replies | 64 Views | Created by An0nym0u5User - Saturday, May 22, 2021 1:26 PM | Last reply by An0nym0u5User - Wednesday, May 26, 2021 7:46 PM -
0 Votes
Extract to .csv running a SQL Query Including Headers
User1203305613 postedExtract to .csv running a Query: I have a query select ordr.ordernumber , ordr.Orderdate, customer.customername from ordr,customer where ...Answered | 1 Replies | 84 Views | Created by An0nym0u5User - Wednesday, May 26, 2021 4:44 AM | Last reply by An0nym0u5User - Wednesday, May 26, 2021 10:36 AM -
0 Votes
Extract to .csv running a SQL Query Including Headers
User1203305613 posted Extract to .csv running a Query: I have a query select ordr.ordernumber , ordr.Orderdate, ...Answered | 1 Replies | 71 Views | Created by An0nym0u5User - Wednesday, May 26, 2021 4:44 AM | Last reply by An0nym0u5User - Wednesday, May 26, 2021 10:36 AM -
0 Votes
Query required in with opening and closing?
User-367318540 postedi have data below CREATE TABLE #Probale (Prdno INT,pWeight int,prdqty int,EntryDate date) CREATE TABLE #ConIssuance (CID INT,iWeight int,QTY ...Answered | 3 Replies | 120 Views | Created by An0nym0u5User - Friday, May 21, 2021 10:34 AM | Last reply by An0nym0u5User - Wednesday, May 26, 2021 7:18 AM -
0 Votes
Query required in with opening and closing?
User-367318540 posted i have data below CREATE TABLE #Probale (Prdno INT,pWeight int,prdqty int,EntryDate date) CREATE TABLE ...Answered | 3 Replies | 66 Views | Created by An0nym0u5User - Friday, May 21, 2021 10:34 AM | Last reply by An0nym0u5User - Wednesday, May 26, 2021 7:18 AM -
0 Votes
Cannot get a Output parameter return value from ObjectDataSource ?
User1909155429 posted ObjectDataSource selectparameter<asp:Parameter Name="SubTotal" Type="Decimal" Direction="Output" /> Output from function that does ...Unanswered | 8 Replies | 105 Views | Created by An0nym0u5User - Monday, May 17, 2021 6:50 PM | Last reply by An0nym0u5User - Saturday, May 22, 2021 1:09 PM -
0 Votes
Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to numeric.
'2020-12-31' and c.con_status is null group by C.ContNo,C.Contrackno, C.ConWeight,C.No_Of_Bales,C.entrydate ) select isnull(convert(decimal(10,2), Pending_Weight),0), Pending_Qty ...Answered | 2 Replies | 66 Views | Created by An0nym0u5User - Friday, May 21, 2021 2:20 AM | Last reply by An0nym0u5User - Friday, May 21, 2021 10:31 AM - Items 1 to 20 of 41690 Next ›
No announcements
