Msdn forums - Transact-SQL

0 Votes

Who will be announced as the next Transact-SQL Guru? Read more about June 2018 competition!!

SQL Server
>
Transact-SQL

What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ...

Sticky | 0 Replies | 126 Views | Created by SYEDSHANU - MVP - Friday, June 01, 2018 12:27 PM
0 Votes

POSTING TIPS - Code, Images, Hyperlinks, Details

SQL Server
>
Transact-SQL

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 ...

Sticky | 0 Replies | 17297 Views | Created by Kalman Toth - Monday, March 31, 2014 6:42 AM

0 Votes

delete from multiple tables at once..

SQL Server
>
Transact-SQL

so its not possible to delete from multiple tables at once right like my statement below ? delete t1,t2,t3,t4 from contact t1 inner join ACTIVITY as ...

Unanswered | 4 Replies | 34 Views | Created by ilikefondue - 1 hour 48 minutes ago | Last reply by Ashish Kumar Tiwari - 5 minutes ago
1 Votes

WHERE IN outer table column can be used without error

SQL Server
>
Transact-SQL

Hello everyone, I have just found bug in our t-sql statement and I wish to share it. CREATE TABLE MAINTABLE (ID BIGINT, SOURCEID BIGINT, NAME ...

Discussion | 7 Replies | 33 Views | Created by Tomasz Kuczyński - Wednesday, June 06, 2018 11:57 AM | Last reply by pituach - 25 minutes ago
0 Votes

Need to rotate a table without a key

SQL Server
>
Transact-SQL

I am pulling data from a file that looks like the ...

Unanswered | 3 Replies | 50 Views | Created by GlobalVillage28 - Wednesday, June 06, 2018 12:01 PM | Last reply by SaravanaC - 32 minutes ago
0 Votes

Q on the Count Function

SQL Server
>
Transact-SQL

these 2 queries return the count of CaseID column ...

Answered | 4 Replies | 32 Views | Created by Carlo L - 1 hour 47 minutes ago | Last reply by .theDBguy - 1 hour 16 minutes ago
3 Votes

Sql Query through ComboBox does not return any record

SQL Server
>
Transact-SQL

HI I am using Sqlconnection and SqlDataAdapter wizard to make a simple query following the Query Builders in Visual Basic 2015. DsQuery1 is the DataSet. My SQL Statement looks ...

Unanswered | 7 Replies | 66 Views | Created by Tariq Hasan - 8 hours 4 minutes ago | Last reply by Olaf Helper - 1 hour 43 minutes ago
0 Votes

Pivot Query for in sql server

SQL Server
>
Transact-SQL

Hi All, We have a requirement in sql server (stored procedure), we have two tables, these two tables output need to pivot data. I tried in ...

Unanswered | 6 Replies | 135 Views | Created by BHVS - Saturday, June 23, 2018 12:30 PM | Last reply by Jingyang Li - 2 hours 21 minutes ago
0 Votes

Pivot table (I think)

SQL Server
>
Transact-SQL

I have a table as follows: table history int player1 pk int player 2 pk int count Every time player 1 ...

Unanswered | 16 Replies | 293 Views | Created by AlessiJax - Wednesday, March 28, 2018 4:05 PM | Last reply by AlessiJax - 2 hours 57 minutes ago
0 Votes

SQL Stored Procedure: Insert Dynamic SQL Data into Temp table

SQL Server
>
Transact-SQL

Hello Everyone, I am building an SSRS Report but I need the below Stored Procedure to be modified for the fields to show up. I have this Stored Procedure ...

Proposed | 3 Replies | 116 Views | Created by kkran - Friday, June 22, 2018 3:49 PM | Last reply by kkran - 3 hours 15 minutes ago
0 Votes

How to get a list of SQL Agent jobs that exist on 1 node of an always On Cluster, but not on other ones?

SQL Server
>
Transact-SQL

Hi!, I have a problem wherby users create SQL Agent jobs on the primary node of one of many Always On Clusters, but neglect to create them on the replicas. I want to create a report ...

Unanswered | 0 Replies | 25 Views | Created by Zoe.Ohara - 3 hours 20 minutes ago
0 Votes

how to trimming the column value before doing bulkcopy in sql server to avoid "Received an invalid column length from the bcp client for colid" error.

SQL Server
>
Transact-SQL

Hi, Actually I have to store the any kind of excel data into sql server table. So I have created the sql table dynamically based on the excel columns and give fixed size ...

Unanswered | 1 Replies | 25 Views | Created by Arivazhagan K - 3 hours 40 minutes ago | Last reply by Visakh16 - 3 hours 25 minutes ago
0 Votes

How to get rid of Warning: Null value is eliminated by an aggregate or other SET operation.

SQL Server
>
Transact-SQL

I am trying to write the trigger declare @clokedDate as Date; declare @Empid as int; SELECT @Empid = ...

Unanswered | 3 Replies | 34 Views | Created by polachan - 4 hours 16 minutes ago | Last reply by Visakh16 - 4 hours 7 minutes ago
0 Votes

Unable to get Time properly while importing data from excel to SqlServer

SQL Server
>
Transact-SQL

Hi All, I have exported the data from SqlServer2008R2 to Excel 2007. I have changed the Time in excel sheet. Saved it and imported that excel sheet into SqlServer. ...

Unanswered | 4 Replies | 33 Views | Created by Sai Pranav - 6 hours 6 minutes ago | Last reply by Sai Pranav - 4 hours 23 minutes ago
3 Votes

How to OR 2 LIKE's

SQL Server
>
Transact-SQL

I want to: SELECT COUNT(*) FROM someTable AS St WHERE St.Name LIKE '%' + 'xml' + '%' OR LIKE '%' + 'xml' I want ...

Answered | 5 Replies | 54 Views | Created by CuriousCoder15 - 5 hours 36 minutes ago | Last reply by SaravanaC - 5 hours 4 minutes ago
0 Votes

how to sum up the each day time stored as Nvarchar

SQL Server
>
Transact-SQL

How to sum up total time for each day My data is as follows CREATE TABLE HrsDay( [EmpCode] Int, ...

Answered | 4 Replies | 60 Views | Created by polachan - 11 hours 20 minutes ago | Last reply by Mak_1404 - 6 hours 18 minutes ago
1 Votes

Pass Parameters to Store Procedure from Batch File

SQL Server
>
Transact-SQL

Hi, I've a store proce which takes 3 parameters and update the product details in database accordingly. I want to capture the parameters from Batch file. does anyone has any idea ...

Answered | 2 Replies | 58 Views | Created by MalikJaved - 7 hours 16 minutes ago | Last reply by MalikJaved - 6 hours 36 minutes ago
0 Votes

Insert fails with FK reference issue in SQL 2016 .Same insert ran successfully for Same data (Table schema also remains same) in sql 2008

SQL Server
>
Transact-SQL

We were recently migrating from sql 2008 to sql 2016 . We have one job which use below Scripts to wipe out and repopulate the data in Company Table in reporting DB by selecting the values ...

Unanswered | 15 Replies | 198 Views | Created by Santhegeeek - Saturday, June 23, 2018 4:23 AM | Last reply by Erland Sommarskog - 6 hours 53 minutes ago
1 Votes

I want to highlight the rows having Invalid status using SQL HTML

SQL Server
>
Transact-SQL

Hi All, I have one requirement, where I want to highlight the rows having Invalid status. I want to have <g class="gr_ gr_89 gr-alert gr_spell gr_run_anim ...

Proposed | 9 Replies | 320 Views | Created by Vipin jha - Thursday, February 09, 2017 4:15 PM | Last reply by JohnJames55 - 7 hours 2 minutes ago
1 Votes

Stored Procedure, UPDATE, if is NULL, INSERT INTO

SQL Server
>
Transact-SQL

0 BEGIN INSERT INTO ...

Answered | 3 Replies | 51 Views | Created by CuriousCoder15 - 9 hours 7 minutes ago | Last reply by CuriousCoder15 - 8 hours 23 minutes ago
1 Votes

Generate multiple rows from 1 row in a table

SQL Server
>
Transact-SQL

Dear members, I have a situation which i would explain through an eg below- Account SerialBegin SerialEnd ...

Answered | 5 Replies | 126 Views | Created by Avhilash - Wednesday, June 20, 2018 3:23 PM | Last reply by Avhilash - 8 hours 38 minutes ago
0 Votes

How to find the net hours clocked each day for each employee to find net working hrs

SQL Server
>
Transact-SQL

From my clocking device , I am getting the data is as follows. In each day first row would be IN and another row would be OUT and so on , for each employee. Now I am trying to find the net hrs worked ...

Unanswered | 3 Replies | 91 Views | Created by polachan - Friday, June 22, 2018 8:33 AM | Last reply by Will_Kong - 9 hours 5 minutes ago
Items 1 to 20 of 89998 Next ›

Forums [ view all ]

Selected forums

Who will be announced as the next Transact-SQL Guru? Read more about June 2018 competition!!

POSTING TIPS - Code, Images, Hyperlinks, Details

delete from multiple tables at once..

WHERE IN outer table column can be used without error

Need to rotate a table without a key

Q on the Count Function

Sql Query through ComboBox does not return any record

Pivot Query for in sql server

Pivot table (I think)

SQL Stored Procedure: Insert Dynamic SQL Data into Temp table

How to get a list of SQL Agent jobs that exist on 1 node of an always On Cluster, but not on other ones?

how to trimming the column value before doing bulkcopy in sql server to avoid "Received an invalid column length from the bcp client for colid" error.

How to get rid of Warning: Null value is eliminated by an aggregate or other SET operation.

Unable to get Time properly while importing data from excel to SqlServer

How to OR 2 LIKE's

how to sum up the each day time stored as Nvarchar

Pass Parameters to Store Procedure from Batch File

Insert fails with FK reference issue in SQL 2016 .Same insert ran successfully for Same data (Table schema also remains same) in sql 2008

I want to highlight the rows having Invalid status using SQL HTML

Stored Procedure, UPDATE, if is NULL, INSERT INTO

Generate multiple rows from 1 row in a table

How to find the net hours clocked each day for each employee to find net working hrs