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 ...
Found 95821 threads
-
1 Votes
T-SQL to Update duplicate records
Ok Im not sure this can even be done but I have a table that has a field with duplicates in it, 970 of them to be exact. What Id like to do is within this field, find ...Answered | 3 Replies | 16716 Views | Created by Rustifer44 - Tuesday, May 29, 2012 4:19 PM | Last reply by Sudip_inn - Saturday, August 29, 2020 7:00 PM -
9 Votes
"SELECT * INTO table FROM" a stored procedure? Possible?
I did a search and read a few solutions but they just don't make too much sense to me. Forgive my newbie-ness but I'm still pretty new when it comes to stored procedures. I'm still learning every ...Answered | 40 Replies | 231882 Views | Created by Doua - Monday, March 9, 2009 4:16 PM | Last reply by Naomi N - Friday, August 28, 2020 12:56 PM -
0 Votes
creating tables in a database by using proper ANSI SQL syntax 98-364 database fundamentals
Hi We are working on 98-364 exam guide and one of the requirements is "creating tables in a database by using proper ANSI SQL ...Answered | 10 Replies | 9989 Views | Created by Katie and Emil - Monday, July 9, 2012 2:50 PM | Last reply by tytion - Friday, August 28, 2020 9:10 AM -
0 Votes
One time history load into dimension table
I have a slowly changing dimension table that keeps track record of our current patient from the patients current location. There is also a history table. I want ...Answered | 13 Replies | 11112 Views | Created by Dre01 - Tuesday, August 4, 2020 9:47 PM | Last reply by Dre01 - Friday, August 21, 2020 4:04 PM -
0 Votes
EXEC sp_tables_ex random fail
Hi I installed ACE driver 2010 64 bits on my SQL 2017 64bits I created a Linked Server to an Excel file SELECT * FROM ...Answered | 6 Replies | 5302 Views | Created by mtrudel337 - Monday, September 3, 2018 8:35 PM | Last reply by PabloFranco - Thursday, August 20, 2020 9:32 PM -
8 Votes
Sql Server 2019 Standard 64bit Slow Performance Vs Sql Server 2012 Express (Sp1) High Performance
Hello, I try to migrate my database from Sql Server 2012 Express (Sp1) to Sql Server 2019 Standard 64bit and I getting very bad query performance ...Proposed | 56 Replies | 12654 Views | Created by EREZra - Wednesday, June 24, 2020 6:51 PM | Last reply by Erland Sommarskog - Thursday, August 20, 2020 9:17 PM -
3 Votes
RTRIM Not working
Hi guys, I have a strange issue when trying to trim some trailing spaces off a string. When I do ...Answered | 14 Replies | 26767 Views | Created by wattyjnr - Monday, March 14, 2011 11:59 AM | Last reply by Dan Guzman - Thursday, August 20, 2020 11:13 AM -
2 Votes
T-SQL to convert Datetime and DatetimeOffset to Zulu Format
How to convert datetime and datetimeoffset to zulu format in Sql server 2014 and above How does the function SYSDATETIMEOFFSET() works - Does it calculate the offset of the server ...Proposed | 13 Replies | 8263 Views | Created by SubhadipRoy - Friday, August 14, 2020 3:15 PM | Last reply by Echo Liuz - Thursday, August 20, 2020 5:25 AM -
8 Votes
Row wise Total in Pivot table ,coming wrong
i am trying to calculating total row wise in Pivot,which is coming wrong. CREATE TABLE #SalesOrder (OrderNo INT,Order_Ref_No VARCHAR(50), Order_date date,Status ...Answered | 37 Replies | 10850 Views | Created by Akhterhussain - Friday, August 14, 2020 4:18 AM | Last reply by Akhterhussain - Wednesday, August 19, 2020 6:47 AM -
1 Votes
Can SQL Server graph query d orecursive?
p2) and p1.name = 'John' how to write the query if I want to find all friends and friends of friends ? we can write a recursive query in normal ...Proposed | 2 Replies | 5005 Views | Created by Guostong - Wednesday, July 29, 2020 8:30 PM | Last reply by Guostong - Wednesday, August 19, 2020 2:14 AM -
0 Votes
Best Practice filtering a Datetime Data Column by a provided StartDate and EndDate DATE Parameters
So I'm sure this has been beaten to death...I think even I myself have beaten this to death. We are wondering what the SQL Server Best Practice is when it comes to creating a SQL ...Proposed | 16 Replies | 10956 Views | Created by ITBobbyP - Friday, August 14, 2020 8:24 PM | Last reply by Melissa Ma - Tuesday, August 18, 2020 6:43 AM -
0 Votes
Sales revenue by country
I have three tables motorcyle_model: id, name, pricecountry: id, nameSales: model_id, country_id, quantity, sales_date All the country wise ...Proposed | 6 Replies | 11508 Views | Created by berkynr - Sunday, August 16, 2020 6:41 PM | Last reply by Echo Liuz - Tuesday, August 18, 2020 5:58 AM -
0 Votes
Hello Friends, In below given query i want the Aging column's outputs in DD:HH:MM format. I am unable to get it. Could any of you help?
Select Work_Order_ID,summary,ISNULL(Request_Assignee, 'Unassigned') as Request_Assignee, CAST(DATEADD(s, Submit_Date, 'Jan 1, 1970') as nvarchar) as Submit_Date ...Proposed | 4 Replies | 5435 Views | Created by Abhijit Anil Patil - Saturday, August 15, 2020 4:44 PM | Last reply by Echo Liuz - Tuesday, August 18, 2020 5:57 AM -
0 Votes
Take one cell's value and convert it into a string for display in a label.
Hi, I know this is probably simple but... I want to select one value from a cell in our MSSQL database, and turn it into a string and put it in a label on our ...Unanswered | 5 Replies | 5520 Views | Created by Altabear - Friday, August 14, 2020 8:15 PM | Last reply by Echo Liuz - Tuesday, August 18, 2020 5:57 AM -
1 Votes
I need a field containing 00:00:00 as numeric (not text) in VFP to export dbf files to Sage 300 2020
I am creating a series of .csv files to import records in Sage 300 Payroll using low level file functions. There is one field called Valtime that requires 00:00:00 as a "number" not ...Proposed | 6 Replies | 7352 Views | Created by Steven Starace - Wednesday, August 12, 2020 7:31 PM | Last reply by --CELKO-- - Monday, August 17, 2020 6:20 PM -
1 Votes
Warning: Null value is eliminated by an aggregate or other SET operation ?
I working on SQL server 2012 I face issue I can't solve this warning Warning: Null value is eliminated by an aggregate or other SET operation so How ...Answered | 7 Replies | 8060 Views | Created by engahmedbarbary - Sunday, August 16, 2020 11:26 PM | Last reply by --CELKO-- - Monday, August 17, 2020 5:18 PM -
3 Votes
Scripting
I don't know what the "scripting" means in SQL Server. (I have experience in T-SQL but not familiar with this term) Does it mean general T-SQL ...Answered | 4 Replies | 4614 Views | Created by Jeff0803 - Sunday, August 16, 2020 9:32 AM | Last reply by Melissa Ma - Monday, August 17, 2020 9:39 AM -
0 Votes
add RECOMPILE for specific query server wide
Hi, I've SQL 2017 and i have a query performance problem. i did try to play with all those trace flag (4199,4136,4137,9481)server wide and play with the indexes and stats and the ...Answered | 11 Replies | 8064 Views | Created by Avi.G - Thursday, August 13, 2020 6:51 AM | Last reply by Echo Liuz - Monday, August 17, 2020 8:04 AM -
0 Votes
Extract values from the String filed in SQL server
I have nvarchar field in a SQL server table that contains html string where value need be separated into two additional fields and data can be of varying ...Proposed | 33 Replies | 8867 Views | Created by Red987 - Monday, August 10, 2020 7:47 PM | Last reply by Melissa Ma - Monday, August 17, 2020 6:44 AM -
0 Votes
Cannot call methods on bigint
Hi, I'm getting the error 'Cannot call methods on bigint' when executing a query in Management Studio. It's happened after in a where clause I used a ...Proposed | 4 Replies | 6110 Views | Created by Andrey1973 - Thursday, August 13, 2020 3:39 PM | Last reply by Echo Liuz - Monday, August 17, 2020 6:03 AM - Items 1 to 20 of 95821 Next ›
No announcements
