No announcements
-
0 VotesDo you want to be acknowledged as Microsoft Transact-SQL Guru? Join June 2019 competition!
What is TechNet Guru Competition? Each month Microsoft TechNet Wiki council organizes a contest of the best articles posted that month. This is your ...
-
0 Votes
POSTING 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 ...
-
0 Votes
How do I update a DATETIME data column with today's date at Midnight?
Our web apps are very sensitive to a DATETIME data column and the time has to be expressed as Midnight. How can I do that for may row updates in a T-SQL Script?Proposed | 2 Replies | 54 Views | Created by ITBobbyP - 9 hours 3 minutes ago | Last reply by Zoe Zhi - 19 minutes ago -
0 Votes
Calculating the RATE as the similar financial function in Excel - SQL Server 2014-2016
Hi, does it exist a native T-SQL function or another efficient manner to calcutate the RATE Excel function? Any suggests to me, please? ThanksUnanswered | 5 Replies | 76 Views | Created by pscorca - 14 hours 8 minutes ago | Last reply by Sabrina.ZH - 23 minutes ago -
0 Votes
strange case no idea need help
Hi All I am facing a strange case. I have a view . when i look up a personid and associated date i get a value in this case select *from ...Unanswered | 2 Replies | 59 Views | Created by LordofthePlains - 4 hours 6 minutes ago | Last reply by Rachel_Wang - 3 hours 37 minutes ago -
0 Votes
Issue with data conversion due to collation change
we have recently migrated SQL database from 2005 to 2016. Collation has been changed from "SQL_Latin1_General_Pref_CP1_CI_AS" to "Latin1_General_ ...Unanswered | 1 Replies | 55 Views | Created by Gugan.t - 4 hours 6 minutes ago | Last reply by scott_morris-ga - 3 hours 44 minutes ago -
0 Votes
How to get list of SP by search text along with DB
Hi, I have multiple databases in my sql server and I need to get the list of SP/Functions along with db name for the given text search (containing text). Please help me with ...Proposed | 7 Replies | 107 Views | Created by Rangasamy - 13 hours 37 minutes ago | Last reply by Hari VS_Kid - 4 hours 31 minutes ago -
0 Votes
Schema's - How to be granted access to use other schema's?
Can the end user add other schema's to their account (login)? Could a schema limit the results returned from a query?Unanswered | 5 Replies | 73 Views | Created by Zieke - 14 hours 32 minutes ago | Last reply by Hari VS_Kid - 4 hours 31 minutes ago -
0 Votes
Sending an email with an embedded image
Hi guys, I want to send an email using he sp_send_dbmail task in MSSQL and I will like to embed the company's signature to the mail. The signature is currently in an image ...Unanswered | 2 Replies | 82 Views | Created by lilutchay - 13 hours 25 minutes ago | Last reply by pituach - 6 hours 27 minutes ago -
0 Votes
Type conversion warning
I get this error in execution plan: Type conversion in expression (CONVERT(varchar(10),[l].[Code],0)) may affect "CardinalityEstimate" in query plan choice; Type ...Proposed | 4 Replies | 236 Views | Created by simonxy - Friday, June 14, 2019 9:24 AM | Last reply by Erland Sommarskog - 7 hours 36 minutes ago -
0 Votes
sqljob with python script
Is there an easy way to see all jobs that has python scripts on sqlagent job. - please mark correct answersUnanswered | 1 Replies | 69 Views | Created by Murali dhar - 11 hours 20 minutes ago | Last reply by Lokesh Vij - 10 hours 4 minutes ago -
0 Votes
How to call one stored procedure from other stored procedure
I have two stored procedure 1. InsertUpdateEmployee 2. InsertUpdateAttendance. I want to call the procedure 'InsertUpdateAttendanceLog' from 'InsertUpdateEmployee' ...Unanswered | 2 Replies | 59 Views | Created by polachan - 14 hours 23 minutes ago | Last reply by Guoxiong - 13 hours 59 minutes ago -
0 Votes
Performance impact of temporal tables in SQL Server 2016 ENT edition
Hi All, We are looking to enable Temporal tables (without system versioning and history tables) on one of our most used table. This is required to capture ...Unanswered | 4 Replies | 102 Views | Created by Asif_DBA - 18 hours 10 minutes ago | Last reply by pituach - 14 hours 12 minutes ago -
0 Votes
Need help with SQL script
Can any one of you help with me with the below. I have table which is having 120million records and this table is an audit table and two columns (Last modified ...Unanswered | 4 Replies | 119 Views | Created by Lakshmi Kiran Reddy Vennapusa - 23 hours 49 minutes ago | Last reply by Lakshmi Kiran Reddy Vennapusa - 16 hours 50 minutes ago -
0 Votes
Mail when value of field < or > paramater%
Hello, I've a question about a report (or message) when the value in a sql table changed under or above a value. Detail information ...Unanswered | 8 Replies | 221 Views | Created by Brussel100 - Friday, June 14, 2019 6:48 AM | Last reply by Brussel100 - 17 hours 32 minutes ago -
0 Votes
The fractional part of the provided time value overflows the scale of the corresponding SQL Server parameter or column. Increase bScale in DBPARAMBINDINFO or column scale to correct this error
Hello, We try to call the below stored procedure with the SQL Server Native Client 11 and also OLEDB Driver 18. Create PROCEDURE ...Proposed | 4 Replies | 293 Views | Created by kesava pindi - Thursday, March 14, 2019 8:13 AM | Last reply by Sathish Guru - 19 hours 56 minutes ago -
0 Votes
Unclosed quotation mark after the character string )
I have the following query, executed with OPENQUERY : DECLARE @DOMAIN NVARCHAR = N'XXX'; DECLARE @QUERY NVARCHAR(MAX)= ' SELECT * FROM OPENQUERY( ...Proposed | 4 Replies | 84 Views | Created by Amira Bedhiafi - 21 hours 24 minutes ago | Last reply by Uri Dimant - 20 hours 55 minutes ago -
1 Votes
Filtering Categories
Hello, I am having trouble figuring out how to filter plans from a list of clients. For example. John Doe has two plans: Healthplus and NY ...Answered | 4 Replies | 254 Views | Created by Alchulo - Wednesday, June 12, 2019 4:04 PM | Last reply by Rachel_Wang - 23 hours 6 minutes ago -
0 Votes
How to merge the rows into single line
I have a table where data will be like below.. Here all transaction starts with '03' and 4th position in all lines that is 00,01,02,04 contains same transaction's data. where as 00 have set of data,01 ...Proposed | 5 Replies | 233 Views | Created by SanthanaKumar04 - Friday, June 14, 2019 7:28 AM | Last reply by Rachel_Wang - 23 hours 18 minutes ago -
0 Votes
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
I am seeking to delete data on database with complex foreign key relationships. The script I'm using, from mssqltips, a script that works on the parent tables with a small number of child ...Answered | 2 Replies | 188 Views | Created by Circle1One - Friday, June 14, 2019 2:52 PM | Last reply by Rachel_Wang - 23 hours 30 minutes ago -
1 Votes
Get data based on date conditions
Hi Friends, I have a table say Patient. The first the patient comes, i enter patient details in it. updated date[the date patient comes] is recorded whenever ...Proposed | 2 Replies | 160 Views | Created by SFatimi - Friday, June 14, 2019 1:21 PM | Last reply by Sabrina.ZH - 23 hours 37 minutes ago -
0 Votes
T SQL CTE Previous Row Calculation
I'm using SQL Server 2016. I have the below table: SKU Shop ...Unanswered | 2 Replies | 166 Views | Created by ChairmanMichael - Friday, June 14, 2019 10:38 AM | Last reply by Zoe Zhi - 23 hours 46 minutes ago - Items 1 to 20 of 93017 Next ›
No announcements
