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
CASE STATEMENT AS A CONDITIONAND ALIAS
01/01/2012 hw to do itDiscussion | 1 Replies | 13 Views | Created by coool_sweet - 26 minutes ago | Last reply by Ferdinand Gaspar - 15 minutes ago -
1 Votes
Entry-Level SQL Developer Resume
From what I have gathered my skill level is nearing the point where I will be ready to apply for an Entry-Level SQL Developer or an internship soon. I have a small amount of prior sql experience job ...Answered | 5 Replies | 748 Views | Created by tria76 - Sunday, July 03, 2016 10:53 PM | Last reply by tria76 - 38 minutes ago -
0 Votes
How to schedule jobs on two different servers
My apologies if i'm posting this question in the wrong forum. This is not related to T SQL but i do not see an option for SQL Server , I had to pick something so i picked the ...Unanswered | 9 Replies | 54 Views | Created by bk6741 - 6 hours 8 minutes ago | Last reply by Erland Sommarskog - 40 minutes ago -
0 Votes
Compare the data in two tables, If Different, Update 1 Column only
Dear All, I have two tables Events and Prodcuts. Both have 2 columns CREATE TABLE EventInfo ...Unanswered | 2 Replies | 25 Views | Created by Sammy Williams - 1 hour 1 minutes ago | Last reply by Erland Sommarskog - 46 minutes ago -
0 Votes
How to remove a duplicate that has a NULL value
I am running the query below: select distinct ou.id_user, display_name, email_address, op.name from [BES12Mgmt-CD].dbo.obj_user ... -
0 Votes
Convert String Variable to Date to Perform Evaluation in Precedence Constraint
I have a variable that is string data type, so we can capture the milliseconds portion of a column. The problem is we need to use this variable in an expression against the current date. The ...Unanswered | 13 Replies | 56 Views | Created by DanHaf - 11 hours 30 minutes ago | Last reply by Erland Sommarskog - 51 minutes ago -
0 Votes
Need to split data as per dates
Hi, I have a requirement to split data by months derived from the dates when activity occurred. Below is the code snippet DECLARE @Activities ...Proposed | 6 Replies | 108 Views | Created by Peter8444 - Tuesday, July 25, 2017 4:54 AM | Last reply by Peter8444 - 52 minutes ago -
0 Votes
-
0 Votes
Linq sub query help
I have a simple sql query and I need to convert to Linq without view to add this query in my c#. Can anyone ... -
4 Votes
Alternative to sum over order by
I have this query which works fine on SQL 2012, but when I try to run it on SQL05, I get a syntax error. How can this be re-written so it will run on SQL05? Changing compatibility modes or stuff like ...Answered | 6 Replies | 88 Views | Created by KenVilla - Tuesday, July 25, 2017 5:35 PM | Last reply by Jingyang Li - 3 hours 10 minutes ago -
0 Votes
Backup sets not dropping out of Backup Device
I have a Backup Device that contains several Backup Sets with all backup sets have an expiration date set to 5 days after creation. In the Backup Device I can see that each backup set has ...Unanswered | 10 Replies | 71 Views | Created by Louisb - Tuesday, July 25, 2017 6:08 PM | Last reply by Jingyang Li - 3 hours 21 minutes ago -
0 Votes
Many to One RelationShip
Hi, I do have two tables that i need to join at the moment. I'm looking in different kind of joins and i saw 3 kinds of it namely: One-to-Many Relationship-One-to-many ...Answered | 1 Replies | 27 Views | Created by Dikong42 - 6 hours 20 minutes ago | Last reply by Tom Cooper - 5 hours 21 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 | 45 Replies | 387 Views | Created by Pradeep.Korukonda - Tuesday, July 18, 2017 8:13 AM | Last reply by Jingyang Li - 6 hours 27 minutes ago -
0 Votes
Things that make you go HMMMM.... when 1 is not 1
Percentage field is a float... any idea why the first query is returning results? Chris NieboerUnanswered | 11 Replies | 110 Views | Created by cnieboer222 - Tuesday, July 25, 2017 8:48 PM | Last reply by --CELKO-- - 6 hours 55 minutes ago -
0 Votes
Insert pre defined values AND counts with conditions from various tables
1 AND EnterpriseCode > 0 OR CompanyCode=1 OR EstablishmentCode=1 OR LocationCode=1) AS LocationCode1_NotEverAliveCount, -- Select counts on ...Answered | 2 Replies | 35 Views | Created by MyleneC - 8 hours 30 minutes ago | Last reply by MyleneC - 7 hours 51 minutes ago -
1 Votes
How to query JSON file in the table of SQL Server 2016?
0 ) /*Query consent - InfoJson column looks ok*/ SELECT * FROM JSON_Import AS t WHERE ISJSON( ...Answered | 2 Replies | 119 Views | Created by Kenny_I - Friday, June 09, 2017 7:53 AM | Last reply by Cool Rachit - 7 hours 57 minutes ago -
0 Votes
delete duplicate (homework)
1 as delete from StudentSource where ID = (select count(id) from StudentSource having count(id) ...Proposed | 2 Replies | 40 Views | Created by Durbslaw - 13 hours 47 minutes ago | Last reply by Jingyang Li - 8 hours 47 minutes ago -
0 Votes
Select from CSV creating NULL bigint values
Hi, I'm currently importing data to a table using a linked server and have noticed that some of the ID values (present in the CSV) are being NULL'd in the destination. These are all ...Unanswered | 2 Replies | 42 Views | Created by TonyS81 - 12 hours 2 minutes ago | Last reply by TonyS81 - 9 hours 22 minutes ago -
0 Votes
Data Mapping when output field is composed from columns of multiple tables in the database
Hi, Our vendor wants an export file of all SKUs but not just 'as is' list, our SKUs should be matched/mapped to their Vendor Code category. We mapped Vendor Code to ...Unanswered | 4 Replies | 67 Views | Created by BrBa - Monday, July 24, 2017 8:27 PM | Last reply by Will_Kong - 9 hours 31 minutes ago - Items 1 to 20 of 86649 Next ›
No announcements
