No announcements
-
1 VotesWho will be announced the next Microsoft TechNet Guru? Read more about July 2017 competition:
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...
-
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
help with distinct query
hi, i have this table NUmber | CustName | Name | QtyCust | ...Unanswered | 1 Replies | 26 Views | Created by GMS-Tech - 49 minutes ago | Last reply by Russ Loski - 4 minutes ago -
0 Votes
Row_number() over partition - Assistance
I am trying to see how often a customer has requested Re-Activation of their Internet account. So my data set is below. I am trying to Count from the first time a ...Answered | 17 Replies | 240 Views | Created by DANII_PINK - Thursday, July 20, 2017 1:05 AM | Last reply by DANII_PINK - 1 hour 34 minutes ago -
0 Votes
T-SQL load csv file
Bit of an odd one this. I apologise for the messiness but this is very much a work in progress. Jeff Moden might like this one. This kind of problem has his name written all over ...Answered | 4 Replies | 68 Views | Created by JCEH - 17 hours 34 minutes ago | Last reply by Erland Sommarskog - 2 hours 1 minutes ago -
1 Votes
Proposing new Data Access Standard: Load/Store/Delete
All data access must go through Load, Store, or Delete. ...Unanswered | 1 Replies | 82 Views | Created by andrewbbrown - 9 hours 4 minutes ago | Last reply by Olaf Helper - 4 hours 19 minutes ago -
0 Votes
drop global temp table
i need to drop my global temp table even if it has 0 rows . i need to make this statement in dynamic sql . please ...Unanswered | 1 Replies | 42 Views | Created by coool_sweet - 10 hours 17 minutes ago | Last reply by Olaf Helper - 4 hours 42 minutes ago -
2 Votes
dynamic sql if condition
hi I have dynamic sql which has select * from table a minus select * from table b,which is working fine. what I need is I ...Unanswered | 6 Replies | 57 Views | Created by coool_sweet - 15 hours 55 minutes ago | Last reply by Erland Sommarskog - 12 hours 57 minutes ago -
2 Votes
daily report for orders being delivered the next day
GETDATE() ANDAnswered | 15 Replies | 253 Views | Created by Louie E - Wednesday, July 05, 2017 8:29 PM | Last reply by Louie E - 13 hours 2 minutes ago -
0 Votes
update trigger : only when specific field (column) is updated
Hello, I have this trigger that updates a sequence status ALTER trigger [dbo].[tupdate_seq_status] on [dbo].[wo_seq] after ...Unanswered | 3 Replies | 45 Views | Created by MigrationUser 1 - 14 hours 23 minutes ago | Last reply by Stefan Hoffmann - 13 hours 3 minutes ago -
0 Votes
Partitioning Other Than By Date
I am use to partitioning a table by date. I am being requested to partition a table in this manner, using two columns. Can it be done this ...Answered | 9 Replies | 200 Views | Created by lcerni - Monday, July 10, 2017 7:44 PM | Last reply by lcerni - 17 hours 18 minutes ago -
1 Votes
Delete Query is Performing too slow with around 6 million records to delete
0 BEGIN DELETE TOP (10000) FROM ion_event_properties WHERE c_event_id IN (SELECT c_id FROM ...Unanswered | 29 Replies | 256 Views | Created by Pradeep.Korukonda - Tuesday, July 18, 2017 8:13 AM | Last reply by Erland Sommarskog - 18 hours 6 minutes ago -
0 Votes
how to copy a row changed some value
hi ; I have one table like below ID CODE NAME ...Answered | 35 Replies | 183 Views | Created by Aly14 - Tuesday, July 18, 2017 4:50 PM | Last reply by Aly14 - 19 hours 49 minutes ago -
0 Votes
data conversion failed
hi I am loading my data from stg to final table . getting error; [Data Conversion [2]] Error: Data ...Unanswered | 1 Replies | 42 Views | Created by coool_sweet - 21 hours 12 minutes ago | Last reply by Russ Loski - 20 hours 56 minutes ago -
2 Votes
Insert int with spaces in BDD
Hi, I have an excel file wich is contaning data that contains spaces like " 365 " when I import the data to my SQL table it gives me error that he can't convert string in int because the ...Proposed | 21 Replies | 109 Views | Created by Vissili - Thursday, July 20, 2017 1:00 PM | Last reply by Vissili - 22 hours 14 minutes ago -
6 Votes
Script to find currently what job are currently running on SQL Server
Hi there, I'm looking for script that returns what job are currently running on SQL Server. I know I can get this information by Job Activity Monitor but I need this ...Answered | 8 Replies | 14514 Views | Created by Ray Ben - Monday, August 13, 2012 9:38 AM | Last reply by Bipin Singh - Friday, July 21, 2017 9:20 AM -
0 Votes
Comapre differnce in consecutive versions
Hi Guys I have a requirement wherein my : due to the securtiy reasons i cannot reveal the actual requirement and details related but i 'll try to be as clear as ...Unanswered | 2 Replies | 59 Views | Created by cse_supriya - Friday, July 21, 2017 4:26 AM | Last reply by Will_Kong - Friday, July 21, 2017 9:04 AM -
0 Votes
member Eligibility span logic
Hi All, I need to built below logic to get the data formatted. TABLE: Member ...Unanswered | 4 Replies | 100 Views | Created by Danaffrod - Monday, July 17, 2017 11:44 AM | Last reply by Xi Jin - Friday, July 21, 2017 8:41 AM -
0 Votes
How to get correct hotel cost after grouping in sql query?
Problem I need to get correct hotel cost in sql queryaccording to following sample data ? the wrong is value red line below ...Unanswered | 7 Replies | 90 Views | Created by ahmedbarbary - Thursday, July 20, 2017 8:20 PM | Last reply by Erland Sommarskog - Friday, July 21, 2017 8:35 AM -
1 Votes
Can I use Dynamic SQL to Pivot a CTE
Hi, forget the code, just wondered if possible to Dynamically select the TEST_FINAL_VALUE2 columns using a PIVOT. As it stands below all the data is stored ROW BY ROW, what I need to is to ...Proposed | 4 Replies | 65 Views | Created by SimonKEvans - Thursday, July 20, 2017 2:49 PM | Last reply by Tom Cooper - Friday, July 21, 2017 7:31 AM -
1 Votes
Read file from Network Drive
Hi Experts, I require to apply the below business rules using TSQL no SSIS/Powershell. Kindly support. Requirement 1. A Csv file ...Proposed | 8 Replies | 97 Views | Created by Priya Bange - Thursday, July 20, 2017 7:00 AM | Last reply by Xi Jin - Friday, July 21, 2017 6:02 AM -
0 Votes
convert fail
I ma getting date like this : table (string ...Answered | 6 Replies | 77 Views | Created by coool_sweet - Thursday, July 20, 2017 5:21 PM | Last reply by Will_Kong - Friday, July 21, 2017 2:47 AM - Items 1 to 20 of 86605 Next ›
No announcements
