No announcements
-
0 VotesPOSTING TIPS - Code, Images, Hyperlinks, Details
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you're asking for ...
-
2 Votes
Need good function to trim all trailing white spaces from string
RTRIM will remove trailing spaces, but it wont remove tabs, carriage returns, line feeds or anything else white. also, this function should remove any and all of these even if they are ...Answered | 13 Replies | 831 Views | Created by moondaddy - Saturday, December 21, 2019 9:19 PM | Last reply by moondaddy - 7 hours 32 minutes ago -
0 Votes
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I am running below query and getting this error. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, ...Unanswered | 7 Replies | 152 Views | Created by Time differnce between rows in sql server - Friday, December 27, 2019 7:33 PM | Last reply by jeffw8713 - 9 hours 39 minutes ago -
0 Votes
How to re-arrange records in columns
Hello community, I hope you're all enjoying the festive season, and having a nice time with your family and friends I have table which currently looks like the ...Answered | 9 Replies | 162 Views | Created by cpatte7372 - Friday, December 27, 2019 11:41 AM | Last reply by cpatte7372 - 15 hours 36 minutes ago -
0 Votes
TSQL logging inside transaction using CLR stored procedure
I'm trying to write a log into another database inside a transaction so that the log will survive even if the transaction is rolled back. I've read this answer which ...Answered | 5 Replies | 139 Views | Created by NiceStepUp - Friday, December 27, 2019 10:20 AM | Last reply by Erland Sommarskog - Friday, December 27, 2019 10:37 PM -
0 Votes
How to incorporate another table in view with having sum?
Department -> Calendar Day. My view is as follows: SELECT SAL.MRP_ORGANIZATION_KEY, SAL.MRP_CALENDAR_KEY, ...Unanswered | 10 Replies | 225 Views | Created by cdtakacs1 - Thursday, December 26, 2019 4:10 PM | Last reply by Erland Sommarskog - Friday, December 27, 2019 10:30 PM -
3 Votes
Repeat rows until the next value is available
Hello, I have a query that will give me the result set as shown in #TestTable. I want the rows to be repeated until next NOT NULL value in any of the ...Answered | 11 Replies | 831 Views | Created by Kiran84 - Saturday, December 21, 2019 4:07 AM | Last reply by 00000000-0000-0000-0000-000000000000 - Friday, December 27, 2019 6:01 PM -
2 Votes
How to write a temp query to get values from a spread sheet and populate a stored proc
So we have this stored proc we call and we pass it 1 parameter (int). I have a spread sheet with over 300 rows and I am trying to find an easy way to loop through this sp and pass it in the ...Unanswered | 4 Replies | 101 Views | Created by ski_freak - Friday, December 27, 2019 4:17 PM | Last reply by Yitzhak Khabinsky - Friday, December 27, 2019 5:37 PM -
1 Votes
Stock Report Required
I am Making product in Probale table ,then i am creating Packs in (PackM,PackD"MasterDetail" ) table ,then i am dispatching Packs in (DispatachM ...Answered | 1 Replies | 90 Views | Created by Akhterhussain - Friday, December 27, 2019 1:32 PM | Last reply by Tom Phillips - Friday, December 27, 2019 2:19 PM -
0 Votes
UPDATE error when merging data
Hello, While executing a merge on a table I'm getting this error: "Cannot insert the value NULL into column ...Unanswered | 7 Replies | 299 Views | Created by Huub Thuijls - Tuesday, December 24, 2019 12:15 PM | Last reply by Huub Thuijls - Friday, December 27, 2019 8:53 AM -
1 Votes
Update Table Trigger error
Hi All I am getting the below error when i update a table Msg 14624, Level 16, State 1, Procedure sp_send_dbmail, Line 242 [Batch Start Line ...Proposed | 26 Replies | 1204 Views | Created by LisaKruger - Tuesday, December 17, 2019 6:43 PM | Last reply by SQLZealots - Friday, December 27, 2019 4:29 AM -
0 Votes
Problems while executing OPENROWSET 'Microsoft.ACE.OLEDB.12.0'
Hello Community, I have a client that is executing the following query: SELECT *INTO #testdata FROM ...Unanswered | 12 Replies | 361 Views | Created by Asolano016 - Tuesday, December 24, 2019 3:30 PM | Last reply by Rachel_Wang - Friday, December 27, 2019 3:36 AM -
0 Votes
How can I convert values in a column into comma delimited values in a field in as a single row?
I'm using SQL Server 2014. I have a table that has ...Unanswered | 14 Replies | 420 Views | Created by Cmagnus - Monday, December 23, 2019 7:34 PM | Last reply by --CELKO-- - Friday, December 27, 2019 3:28 AM -
0 Votes
Identity start increment to 2
Hello, I have a table with an identity. I switch off the identity and I insert 2 lines with a specific code I switch on the ...Proposed | 7 Replies | 783 Views | Created by Joc002 - Thursday, December 19, 2019 3:45 PM | Last reply by --CELKO-- - Friday, December 27, 2019 3:19 AM -
0 Votes
table should allow only few fields unique and rest fields can allow duplicate values through sp while inserting or updation
i have table called "vehicle" in which it should insert/update unique values that means if we have chassis no 'xyz123' and again 'xyz123' should not allow for ...Proposed | 4 Replies | 374 Views | Created by sqlserver-msdn - Wednesday, December 18, 2019 4:45 AM | Last reply by --CELKO-- - Friday, December 27, 2019 12:36 AM -
0 Votes
Assigning sequential values to rows
Hi I have a query as below; SELECT Staff.PayrollReferenceNo FROM Staff WHERE (Staff.PayrollReferenceNo = 0) Or (Staff.PayrollReferenceNo Is ...Answered | 10 Replies | 834 Views | Created by Y a h y a - Tuesday, December 10, 2019 2:23 AM | Last reply by --CELKO-- - Friday, December 27, 2019 12:21 AM -
0 Votes
How to map Security/Logins users?
If I right click on a login userAdmin, Properties, User Mapping, under "User mapped to this login:", I check the myDatabase I wanted and then under the "Database role membership for: ...Proposed | 4 Replies | 1325 Views | Created by Charlie2 - Friday, December 6, 2019 4:37 PM | Last reply by Rachel_Wang - Thursday, December 26, 2019 3:06 AM -
1 Votes
sp_helptext give wrong store procedure
I tried to get a store procedure with sp_helptext. In result it gives me almost same name another store procedure. That suffers me a lot. Is That a Bug?Proposed | 15 Replies | 987 Views | Created by RezaurRahman - Monday, December 9, 2019 7:52 AM | Last reply by Rachel_Wang - Thursday, December 26, 2019 3:04 AM -
0 Votes
upload data from excel file into sql server
Hi Guys, I appreciate it if you can help me with how to upload a dirty excel file into the SQL server table. (I don't want to clean the file manually, I'm ...Proposed | 5 Replies | 1384 Views | Created by ZaraJ - Friday, December 13, 2019 4:34 PM | Last reply by Rachel_Wang - Thursday, December 26, 2019 2:59 AM -
0 Votes
SQL Query Results : Connection through VBA differences with regional settings
Hello, I currently user a reporting tool built in Excel (vba) that connects to a SQL server database and executes queries based on user's options. Recently, our users switched ...Proposed | 3 Replies | 483 Views | Created by DAIPPOD - Tuesday, December 17, 2019 6:36 PM | Last reply by Rachel_Wang - Thursday, December 26, 2019 2:53 AM -
0 Votes
Default value
Hi, why do i need to provide a default value or atlist mark as default in the insert statement? e.g.: create table MyTable ...Proposed | 6 Replies | 748 Views | Created by Octopus02 - Wednesday, December 18, 2019 5:47 PM | Last reply by Rachel_Wang - Thursday, December 26, 2019 2:51 AM - Items 1 to 20 of 94408 Next ›
No announcements
