No announcements
-
0 VotesJune 2017 TechNet Guru Competition is open! Read more on how you can win
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is your chance ...
-
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
Show rows as column
I have data in below format, Department Question No of cases ...Unanswered | 2 Replies | 23 Views | Created by h2007 - 45 minutes ago | Last reply by SQLNeophyte - 2 minutes ago -
0 Votes
Search Query
I am trying to build a search query in my windows application and pass those parameters to a stored procedure. Here is part of my sp. It does not return any recors but the table has records in ...Unanswered | 5 Replies | 39 Views | Created by WEnterp - 4 hours 54 minutes ago | Last reply by Ryandell - 4 minutes ago -
0 Votes
What is the best way for Big transaction table..
Hi team, I have a table containing 5 billion records.i want to delete the the 2 billion records.what is the best way in Sql server ...Unanswered | 6 Replies | 51 Views | Created by Sandeepmalik - 3 hours 3 minutes ago | Last reply by Sandeepmalik - 10 minutes ago -
0 Votes
Parameter to search column contents
Hi I have a column in my database which contains up to 10 codes separated by commas e.g. sq1, as2, as3, to5, yu7. I am interested in only codes starting with 'a'. I am ...Proposed | 4 Replies | 63 Views | Created by dev-13 - 10 hours 48 minutes ago | Last reply by Erland Sommarskog - 3 hours 21 minutes ago -
0 Votes
need help in tsql
I have data in my table like Item Vendor activity Start ...Unanswered | 3 Replies | 110 Views | Created by rakesh.1263 - Thursday, June 22, 2017 9:21 AM | Last reply by Xi Jin - 3 hours 46 minutes ago -
0 Votes
How to calculate cost of flight and hotel and transfer per every program ?
How to design database for tourism company to calculate cost of flight and hotel per every program tour based on date ? what i do ...Unanswered | 6 Replies | 186 Views | Created by ahmedbarbary - Sunday, June 25, 2017 6:00 PM | Last reply by Will_Kong - 5 hours 12 minutes ago -
0 Votes
An aggregate may not appear in the set list of an UPDATE statement.
I received this error on the following Update Statement. ArticleNo is a varchar(50). UPDATE Items SET ArticleNo = Concat('KB', ...Proposed | 3 Replies | 73 Views | Created by Paul Bill - 12 hours 50 minutes ago | Last reply by Xi Jin - 7 hours 55 minutes ago -
0 Votes
Calculate 3 previous business days
Hi, I have a holiday table with holidays and weekends. I know how to get 'Next Business day' and 'Previous Business Day'. I do not know how to get date of 3 previous business days. ...Proposed | 2 Replies | 68 Views | Created by Spunny - 16 hours 47 minutes ago | Last reply by Xi Jin - 8 hours 7 minutes ago -
0 Votes
How to update only specific field in a trigger rather than updating all fields.
Hello there, I have a trigger where I am updating fields using dynamic sql. Now I have to modifiy the code to check what field got updated and update only specific field rather than ...Proposed | 8 Replies | 92 Views | Created by CVBNN - Tuesday, June 27, 2017 3:23 AM | Last reply by Erland Sommarskog - 12 hours 35 minutes ago -
0 Votes
How is it possible to use index seek for WHERE Value1 LIKE %abc without any tricks?
Hello, I always believed that SQL Server cannot use index seek for LIKE ‘%abc’ query until you implement some tricks. I know 2 of them. But first let me create a test ...Unanswered | 13 Replies | 125 Views | Created by AlexeyGa - Monday, June 26, 2017 7:47 PM | Last reply by AlexeyGa - 13 hours 35 minutes ago -
0 Votes
Group by Date Range and Select least value for the range - TSQL
Hi, I am trying to come up with a query to group by (or) determine the range from date ranges and find out the lowest value for that range. In the following example A1 is the lowest ...Unanswered | 8 Replies | 95 Views | Created by G vinod - 21 hours 2 minutes ago | Last reply by G vinod - 13 hours 46 minutes ago -
0 Votes
Only Show Results Where Over/Under 25%
= 25% of the Projected Sale Price, OR ActualSalePrice isUnanswered | 2 Replies | 45 Views | Created by IndigoMontoya - 15 hours 15 minutes ago | Last reply by Hilary Cotter - 14 hours 50 minutes ago -
0 Votes
Help in Getting the Balance of Each Order
Hi i have a problem getting the balance of each order in my database. I do have a Project table which can have multiple Orders link to it. I can pay each order ...Answered | 5 Replies | 64 Views | Created by Dikong42 - 17 hours 19 minutes ago | Last reply by Dikong42 - 16 hours 28 minutes ago -
0 Votes
Query by year? Large "Group By"
Hi all. I'm attempting to make a query that will group by a year. I've finished the query, and have figured out a way to get it to show me the data during the year I select (for ...Proposed | 10 Replies | 90 Views | Created by pantherfanrh - 19 hours 42 minutes ago | Last reply by Sarat (SS) - 16 hours 43 minutes ago -
0 Votes
Convert varchar to numeric
Hi, We are using sql server 2012. I get data from excel file using SSIS into a table like this: DECLARE @table1 ...Answered | 4 Replies | 116 Views | Created by Spunny - Monday, June 26, 2017 12:24 AM | Last reply by Spunny - 17 hours 40 minutes ago -
0 Votes
execute a script
Hello, I am having a multiple schema and same database multitenancy architecture and each schema has its own user and he has access to only his objects. Now I am thinking of ...Proposed | 8 Replies | 186 Views | Created by oleolehoohoo - Monday, May 22, 2017 3:06 PM | Last reply by oleolehoohoo - 18 hours 51 minutes ago -
0 Votes
SQL MERGE STATEMENT ERROR
Hi, I have created an SSIS package which uses CDC and loads incremental Data into Target Table. I use merge query as is used for any general ETL of this ...Answered | 4 Replies | 98 Views | Created by AK120684 - Monday, June 26, 2017 7:58 PM | Last reply by AK120684 - 19 hours 9 minutes ago -
0 Votes
SQL Query Help Please
Hello all, I have 2 tables EQ_FAILURE_1 and EQ_FAILURE_2. CREATE TABLE #eq_failure_1 (primo_id int, failure_id ...Answered | 5 Replies | 123 Views | Created by Srik Kotte - Monday, June 26, 2017 6:33 PM | Last reply by Srik Kotte - 20 hours 23 minutes ago -
0 Votes
Error While running Cursor script in production
Hi All, I need to update 2 fields( BLOB and FileExtension) in productions serever. I have wtitten a cursor script for this. ...Unanswered | 3 Replies | 85 Views | Created by Srisai4me - 23 hours 20 minutes ago | Last reply by Tom Phillips - 21 hours 19 minutes ago -
0 Votes
Optimizing Query MS SQL Server 2008
I am executing the following query multiple times. This query takes lot of time to complete on each occurrence, thus increasing the amount of time my concurrent program takes to complete. Please help ...Unanswered | 4 Replies | 122 Views | Created by emilia.mazurkiewicz - Monday, June 26, 2017 1:52 PM | Last reply by emilia.mazurkiewicz - 22 hours 0 minutes ago - Items 1 to 20 of 86362 Next ›
No announcements
