No announcements
-
1 VotesMicrosoft TechNet Wiki Monthly contest for May 2017 is opened! Apply your article and join the TechNet Guru's family!
May is under way! And the Guru early birds are showing the way! Could this be the month that we see the best ever TechNet article in the ...Sticky | 1 Replies | 278 Views | Created by pituach - Wednesday, May 03, 2017 9:54 AM | Last reply by [Kamlesh Kumar] - Tuesday, May 16, 2017 12:19 AM
-
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
Optimizing SQL Query
Hello There, I have a situation where I need to optimize a SQL code generated from a Java App.Before the Query took more than 10 mins to run.I modified the query to run around 3 ...Unanswered | 3 Replies | 52 Views | Created by CVBNN - 8 hours 13 minutes ago | Last reply by Xi Jin - 5 minutes ago -
0 Votes
Comparing values in same column
Hi, In sample table below, I would like to compare REF values (numeric only vs prefix CM) and indicate Y/N if their DATE column is same ...Answered | 6 Replies | 60 Views | Created by sednitrac - 7 hours 37 minutes ago | Last reply by sednitrac - 2 hours 9 minutes ago -
1 Votes
Handle Julian and Real Times in one query
= 0 AND @JulianTimeAnswered | 6 Replies | 77 Views | Created by SimonKEvans - 17 hours 6 minutes ago | Last reply by --CELKO-- - 3 hours 44 minutes ago -
0 Votes
t-sql 2012 message counts should be combined
In a t-sql 2012 database, I am suppose to count the number of times each 'canned' message is used for Elementary students in the last school year and the current school ... -
0 Votes
Amortization query
Hi, I am going to calculate the amortization using stored procedure and wonder if there is an easy way to achieve my calculation below. Amortization Amount: $10, ...Unanswered | 1 Replies | 46 Views | Created by wkpli - 8 hours 17 minutes ago | Last reply by Jason A Long - 3 hours 59 minutes ago -
0 Votes
update line price if multiple invoice\item
I have a Invoice table where I'm taking the value from a Price table and applying that at the Invoice\Item level. If there are multiple lines ...Answered | 5 Replies | 79 Views | Created by hart60 - Thursday, May 25, 2017 1:33 AM | Last reply by Hilary Cotter - 4 hours 56 minutes ago -
0 Votes
Scan free text field
Hi All I have an interesting query, in a database I have a free text field which end users paste a supposedly block of free text they filled in from a template. An example of it ...Proposed | 13 Replies | 142 Views | Created by James OHara - Wednesday, May 24, 2017 9:50 AM | Last reply by Jason A Long - 5 hours 27 minutes ago -
0 Votes
Parse XML string using t-sql
Hi All, I want to parse below XML string which is currently stored in a table with 2 columns - RecID and XMLDATA First XML ...Unanswered | 1 Replies | 46 Views | Created by sql9 - 6 hours 57 minutes ago | Last reply by Hilary Cotter - 5 hours 50 minutes ago -
0 Votes
Need help with Update SQL script
I am writing a Powershell script to gather info on PCs in our corporate environment and I am having an issue with my SQL script. I got an INSERT statement to work fine on SQL Server 2014, but I can't ...Proposed | 4 Replies | 97 Views | Created by BrianEmbree - Thursday, May 18, 2017 3:20 PM | Last reply by BrianEmbree - 10 hours 25 minutes ago -
0 Votes
Multiple queries into one using group by and cte
USE HealthBI declare @Keyword1 VARCHAR(100) = '%smok%' ;With search as ( select LEFT(o.name,3) CoreTable, o.name ...Proposed | 7 Replies | 125 Views | Created by SimonKEvans - Wednesday, May 24, 2017 10:10 AM | Last reply by SimonKEvans - 11 hours 44 minutes ago -
0 Votes
Get previous value of a key based on condition.
hi , I need to figure out a query to find all travelers who have booked a hotel with +/- 10 % of previously booked nightly rates. Given Data ...Unanswered | 4 Replies | 91 Views | Created by vishal.... _ - Wednesday, May 24, 2017 9:27 PM | Last reply by Guoxiong - 12 hours 26 minutes ago -
0 Votes
Compare And genarete Synchronize SQL Server Schemas by using TSQL SCRIT
COuld you please provide the Compare And genarete Synchronize SQL Server Schemas by using TSQL SCRIT . without toolsProposed | 4 Replies | 85 Views | Created by SQLHELP007 - Wednesday, May 24, 2017 7:41 AM | Last reply by SQLHELP007 - 13 hours 34 minutes ago -
0 Votes
\
I know, I'm asking very simple question to SQL world. But I'm very new to SQL Server or I'm beginners. \Proposed | 10 Replies | 184 Views | Created by JinalContractor - Wednesday, May 24, 2017 4:21 AM | Last reply by SQLNeophyte - 15 hours 10 minutes ago -
0 Votes
How to delete the slicer items and change the choice item .
11 June - 14 June 2015 data ? how to delete the 20Jan-22Jan this 3 date icon. USE [DW_PURE01] GO ---Drop View ...Unanswered | 2 Replies | 82 Views | Created by how to delete the items choice in slicer - 19 hours 46 minutes ago | Last reply by Sam Zha - 16 hours 2 minutes ago -
0 Votes
Incorrect syntax near @ID
0 BEGIN PRINT 'SELECTING INTO CORE_FACT_DIMENSION'; INSERT INTO CORE_FACT_DIMENSION SELECT * FROM ...Proposed | 1 Replies | 49 Views | Created by _kashi_ - 16 hours 43 minutes ago | Last reply by Uri Dimant - 16 hours 15 minutes ago -
0 Votes
LCK_M_RS_U wait type for DELETE command
Hi Team, Can you please provide me details when LCK_M_RS_U lock occurred? Thanks in ...Proposed | 4 Replies | 60 Views | Created by R987654 - 20 hours 9 minutes ago | Last reply by Xi Jin - 17 hours 18 minutes ago -
0 Votes
Arithmetic overflow error converting expression to data type money.
0 , (((sum(A.td_profit)) / sum(A.saletarget) ) *100),0) as td_pcnt_profit_tgt, sum(A.saletarget) as td_profit_target, sum(A.td_profit_required) as ...Proposed | 6 Replies | 99 Views | Created by polachan - Wednesday, May 24, 2017 10:45 AM | Last reply by SQLNeophyte - 17 hours 25 minutes ago -
0 Votes
Transactions isolation levels. Business cases
Hello All, Now I try to enhance my knowledge and understanding of different transaction isolation levels in MS SQL Server, so I am looking for different "real-world" ...Unanswered | 5 Replies | 84 Views | Created by pateykin - Wednesday, May 24, 2017 8:24 PM | Last reply by Xi Jin - 19 hours 13 minutes ago -
0 Votes
t-sql 2012 parsing out values in one column
In a t-sql 2012 database, I am suppose to count the number of times each 'canned' message is used for Elementary students in the last school year and the current school ...Answered | 19 Replies | 276 Views | Created by wendy elizabeth - Friday, May 19, 2017 9:20 PM | Last reply by Xi Jin - 20 hours 37 minutes ago -
1 Votes
Sorting dynamic columns in a matrix
I have a matrix in an SSRS report that is being used to create a pivot table. I need to get the number of calls per agent per day over a range of dates (startDate & endDate passed in). I can get ...Answered | 4 Replies | 67 Views | Created by Contracting1978 - Wednesday, May 24, 2017 2:29 PM | Last reply by Xi Jin - 23 hours 3 minutes ago - Items 1 to 20 of 86046 Next ›
No announcements
