No announcements
Found 95821 threads
-
0 VotesOPENROWSET EXCEL WITH AZURE FILE SHARE EXAMPLE
hi, Can anyone please give me a example to read specific range of data of excel which is stored in FILE share specific folder. I have tried to search online but i ...Proposed | 2 Replies | 2468 Views | Created by Aminesh - Wednesday, August 12, 2020 2:04 PM | Last reply by Echo Liuz - Monday, August 17, 2020 5:51 AM
-
0 Votes
Send Email when a new order is entered
0 Begin SET @JobNumber=( Select Top 1 jobnumber From orderheader Where CustAccount = '000403' AND ...Unanswered | 6 Replies | 2649 Views | Created by Ruthless Roth - Wednesday, August 12, 2020 1:26 PM | Last reply by Echo Liuz - Monday, August 17, 2020 5:50 AM -
0 Votes
How to update status where portion key charterer not match charterer on signature key?
I work on SQL server 2012 I face issue I cannot update status with not match character where portion key not equal signature key character based on group id ...Answered | 5 Replies | 2417 Views | Created by engahmedbarbary - Friday, August 14, 2020 2:30 PM | Last reply by Melissa Ma - Monday, August 17, 2020 3:12 AM -
0 Votes
Replace a value having enter key included as blank
Hi, I loaded data from excel to sql server table. Data is like below in excel and sql ...Proposed | 2 Replies | 1793 Views | Created by sivaramasqlserver - Friday, August 14, 2020 4:37 PM | Last reply by Melissa Ma - Monday, August 17, 2020 2:58 AM -
0 Votes
Parse data from a table row and output the values formatted
I have a table that has multiple values (and sometimes no values) in the column: ReptDesc. I want to extract those values in the following way: If a value is followed by a colon : that is to be ...Answered | 4 Replies | 2300 Views | Created by vsla - Friday, August 14, 2020 10:27 PM | Last reply by vsla - Sunday, August 16, 2020 12:02 AM -
2 Votes
How to write SQL Query and running in parallel within stored procedure ?
I read a bunch of articles and still, can't really know how optimizer determine to run in parallel or not. Here is my simple story, I have a stored procedure used to calculate ...Answered | 3 Replies | 7138 Views | Created by Chjquest - Friday, April 20, 2012 1:36 PM | Last reply by Erland Sommarskog - Saturday, August 15, 2020 9:32 PM -
0 Votes
How to update status to wrong numeric if at least on character exist ?
I work on SQL server 2012 I have keyValue field I need when user write on it any character except 0 to 9 then update status to Not valid number ...Answered | 2 Replies | 1900 Views | Created by engahmedbarbary - Friday, August 14, 2020 7:57 PM | Last reply by Jingyang Li - Friday, August 14, 2020 9:06 PM -
0 Votes
Updating a uniqueidenfier column
Hi everyone, I have a SQL table with a column of a uniqueideitifer data type, this field allows NULL. I have a couple of records in the table that is ...Answered | 8 Replies | 3094 Views | Created by lilutchay - Friday, August 14, 2020 7:44 PM | Last reply by lilutchay - Friday, August 14, 2020 8:55 PM -
0 Votes
Masking Numeric with spaecial charater
The Data looks like. 123456789 8765434511 7568792311134 how can i replace first 3 and last 3 numbers ...Answered | 11 Replies | 3177 Views | Created by umamsb5 - Friday, August 14, 2020 7:09 AM | Last reply by Jingyang Li - Friday, August 14, 2020 2:41 PM -
0 Votes
How to update status with wrong length where length after $ not equal length of portion Key ?
problem How to update status with wrong length where length after $ on Signature Key not equal length of portion Key depend on groupid ? I work on SQL ...Answered | 2 Replies | 1699 Views | Created by engahmedbarbary - Friday, August 14, 2020 5:26 AM | Last reply by engahmedbarbary - Friday, August 14, 2020 12:59 PM -
1 Votes
How to find closes match based on a numerical value
Working on assessing some testing data and trying to match up test and control candidates. In the data I have there is a table with 3 columns (ID1, ID2, Score). ID1 and ID2 are integer ...Proposed | 17 Replies | 4093 Views | Created by JasonDWilson77 - Wednesday, August 12, 2020 1:40 PM | Last reply by Melissa Ma - Friday, August 14, 2020 1:50 AM -
3 Votes
Replace 0 with Null
i want to replace null with zero declare @fromdate date='2020-01-15' declare @todate date='2020-01-15' declare @columns varchar(max) declare @convert ...Answered | 3 Replies | 3047 Views | Created by Akhterhussain - Thursday, August 13, 2020 6:13 PM | Last reply by Melissa Ma - Friday, August 14, 2020 1:42 AM -
0 Votes
DATE CALC: Operand type clash: date is incompatible with int
Okay, so I'm stumped. Why does my code keep erroring out? What am I missing here in my WHERE clause? My desired results is to return only the last record of the ...Answered | 6 Replies | 3316 Views | Created by BrianJohn - Thursday, August 13, 2020 6:19 PM | Last reply by Erland Sommarskog - Thursday, August 13, 2020 10:01 PM -
0 Votes
Run sqlcmd on sql server from a different non-sql server machine
I have two servers, A and B. "A" has sql server installed and running on it. "B" does not have sql server installed on ...Answered | 7 Replies | 3418 Views | Created by moondaddy - Thursday, August 13, 2020 9:15 PM | Last reply by moondaddy - Thursday, August 13, 2020 9:42 PM -
1 Votes
SQL script that would identify duplicates and skip in a row
Hi All, I hope everyone is safe . . . I have kind of weird question. . . Please look at the below two tables Table ...Answered | 20 Replies | 2746 Views | Created by kiruman - Thursday, August 13, 2020 2:50 PM | Last reply by Yitzhak Khabinsky - Thursday, August 13, 2020 6:49 PM -
4 Votes
Date filter is not working
below is my query ,i want to fetch record between two date ,but data is not getting filter as per date parameter declare @fromdate date='2020-01-01' declare @todate ...Answered | 17 Replies | 2988 Views | Created by Akhterhussain - Wednesday, August 12, 2020 7:04 AM | Last reply by Tom Phillips - Thursday, August 13, 2020 3:47 PM -
0 Votes
Normalization vs De-Normalization
Hello, Is this statement correct? "De-normalising the table is another way to describe breaking out a single table into multiple tables to create a model ...Answered | 4 Replies | 2533 Views | Created by arkiboys - Thursday, August 13, 2020 6:56 AM | Last reply by arkiboys - Thursday, August 13, 2020 9:38 AM -
0 Votes
T-SQL - ODSOLE Extended Procedure The source data specified for this string or binary column or parameter is too long
I goal is to connect to a webapi and request data. I am quite sure that I am connected and I am getting data back because the error message indicated that there ...Proposed | 4 Replies | 3213 Views | Created by Phyxius7 - Tuesday, August 4, 2020 12:07 PM | Last reply by Erland Sommarskog - Thursday, August 13, 2020 8:53 AM -
0 Votes
SQL Query With Cross Apply Slow performance
Hello I'm trying rewrite the SQL below to get better performance. the query runs about 5 min and return 5000 records. any suggestions how to do ...Unanswered | 14 Replies | 4404 Views | Created by shaykgm - Tuesday, August 11, 2020 2:08 PM | Last reply by Echo Liuz - Thursday, August 13, 2020 7:56 AM -
2 Votes
Remove multiple special characters and alphabets from column data without using UDF
Hi All, How to remove multiple special char and alphabets to get only numeric values from column in SELECT query? CREATE TABLE #x (PH ...Answered | 6 Replies | 3290 Views | Created by papillon28 - Wednesday, August 12, 2020 4:28 PM | Last reply by papillon28 - Thursday, August 13, 2020 6:27 AM
No announcements
