Msdn forums - Transact-SQL

1 Votes

Who will be announced the next Microsoft TechNet Guru? Read more about July 2017 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 ...

Sticky | 0 Replies | 187 Views | Created by pituach - Monday, July 10, 2017 1:36 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 | 14892 Views | Created by Kalman Toth - Monday, March 31, 2014 6:42 AM

0 Votes

Things that make you go HMMMM.... when 1 is not 1

SQL Server
>
Transact-SQL

Percentage field is a float... any idea why the first query is returning results? Chris Nieboer

Unanswered | 7 Replies | 45 Views | Created by cnieboer222 - 2 hours 1 minutes ago | Last reply by Srini Koduru - 48 minutes ago
0 Votes

Backup sets not dropping out of Backup Device

SQL Server
>
Transact-SQL

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 | 5 Replies | 41 Views | Created by Louisb - 4 hours 42 minutes ago | Last reply by Louisb - 1 hour 48 minutes ago
0 Votes

Ideas to improve performance of this trigger code

SQL Server
>
Transact-SQL

Below is my flat table structure.I have to update or insert into flat table if any changes occur in challenge_activity_extra table select * from ...

Unanswered | 2 Replies | 62 Views | Created by CVBNN - 8 hours 58 minutes ago | Last reply by Erland Sommarskog - 2 hours 43 minutes ago
1 Votes

Delete Query is Performing too slow with around 6 million records to delete

SQL Server
>
Transact-SQL

0 BEGIN DELETE TOP (10000) FROM ion_event_properties WHERE c_event_id IN (SELECT c_id FROM ...

Unanswered | 44 Replies | 366 Views | Created by Pradeep.Korukonda - Tuesday, July 18, 2017 8:13 AM | Last reply by Erland Sommarskog - 2 hours 50 minutes ago
0 Votes

member Eligibility span logic

SQL Server
>
Transact-SQL

Hi All, I need to built below logic to get the data formatted. TABLE: Member ...

Unanswered | 7 Replies | 131 Views | Created by Danaffrod - Monday, July 17, 2017 11:44 AM | Last reply by Erland Sommarskog - 2 hours 51 minutes ago
0 Votes

combine select sta in one query

SQL Server
>
Transact-SQL

hi i have table like this item item no , itemdesc open date ...

Unanswered | 5 Replies | 83 Views | Created by coool_sweet - 21 hours 54 minutes ago | Last reply by coool_sweet - 3 hours 10 minutes ago
0 Votes

Alternative to sum over order by

SQL Server
>
Transact-SQL

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

Unanswered | 4 Replies | 46 Views | Created by KenVilla - 5 hours 14 minutes ago | Last reply by Hunchback - 4 hours 16 minutes ago
0 Votes

SQL HELP

SQL Server
>
Transact-SQL

Hi All, Please check below my source and desire output. Partition columns ID,NBR and order by PT. YEAR ID NBR PT ...

Unanswered | 6 Replies | 83 Views | Created by cmk1 - 8 hours 7 minutes ago | Last reply by Jingyang Li - 4 hours 44 minutes ago
0 Votes

T-SQL load csv file

SQL Server
>
Transact-SQL

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 | 7 Replies | 135 Views | Created by JCEH - Friday, July 21, 2017 5:14 PM | Last reply by JCEH - 5 hours 32 minutes ago
0 Votes

Need to split data as per dates

SQL Server
>
Transact-SQL

Hi, I have a requirement to split data by months derived from the dates when activity occurred. Below is the code snippet DECLARE @Activities ...

Unanswered | 3 Replies | 67 Views | Created by Peter8444 - 17 hours 56 minutes ago | Last reply by Jingyang Li - 7 hours 34 minutes ago
2 Votes

Insert int with spaces in BDD

SQL Server
>
Transact-SQL

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 | 27 Replies | 200 Views | Created by Vissili - Thursday, July 20, 2017 1:00 PM | Last reply by pituach - 7 hours 45 minutes ago
1 Votes

Year, Month and Day between two dates

SQL Server
>
Transact-SQL

a.received_Date THEN 1 ELSE 0 END ) AS VARCHAR(2)) + ' Years '+ cast(MONTH(a.received_Date - DATEADD(YEAR, DATEDIFF(YEAR, ...

Answered | 5 Replies | 112 Views | Created by Easy_DBA - Tuesday, July 18, 2017 7:19 PM | Last reply by Easy_DBA - 8 hours 38 minutes ago
0 Votes

Need help with cross join

SQL Server
>
Transact-SQL

Hi. I don't do much coding so I need your help with something that's probably common and straightforward. I have a table that looks like the following: ProductCategory ...

Unanswered | 3 Replies | 51 Views | Created by District9 - 16 hours 53 minutes ago | Last reply by Jingyang Li - 9 hours 0 minutes ago
0 Votes

Data Mapping when output field is composed from columns of multiple tables in the database

SQL Server
>
Transact-SQL

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 | 3 Replies | 51 Views | Created by BrBa - Monday, July 24, 2017 8:27 PM | Last reply by BrBa - 9 hours 23 minutes ago
0 Votes

User-Defined Table Types in SQL Server 2005

SQL Server
>
Transact-SQL

Hi, I am using SQL Server 2005 for some reasons, I have a requirement to create a User-Defined Table Types in SQL Server 2005. Any ...

Unanswered | 6 Replies | 44 Views | Created by Elmozamil Elamir - 12 hours 26 minutes ago | Last reply by Erland Sommarskog - 10 hours 3 minutes ago
2 Votes

SELECT the highest number in an varchar field with mixed content

SQL Server
>
Transact-SQL

Hi everybody, I'm having a table with various fields. One of the fields is called "Number". The content of the field Number is something like ...

Unanswered | 3 Replies | 58 Views | Created by thyslo - Monday, July 24, 2017 3:06 PM | Last reply by thyslo - 10 hours 7 minutes ago
0 Votes

Output date field formatted differently.

SQL Server
>
Transact-SQL

Hi, I have a table which contains a data column in the format of [2015-06-08 00:00:00.000]. I want to use an insert to copy this date to a new table in the format ...

Answered | 7 Replies | 74 Views | Created by KelvinClark - Monday, July 24, 2017 3:27 PM | Last reply by KelvinClark - 10 hours 9 minutes ago
0 Votes

Cant link tables properly. Msoft Access

SQL Server
>
Transact-SQL

Nz(tbl_Operacao_Pendente.Data_Boletagem, 0), tbl_Operacao_Pendente.Data_Negociacao, tbl_Operacao_Pendente.Data_Boletagem)) WHERE (((tbl_Documento_Pendente.Data_Envio_Documento) ...

Unanswered | 0 Replies | 39 Views | Created by JonathanSD - 11 hours 40 minutes ago
0 Votes

invalid object name

SQL Server
>
Transact-SQL

hi i m getting error : invalid object name : global temp table SET @SQLDROP ='IF ...

Unanswered | 2 Replies | 49 Views | Created by coool_sweet - Monday, July 24, 2017 1:38 PM | Last reply by Will_Kong - 13 hours 32 minutes ago
0 Votes

Copying the Result set of Stored Procedure without Creating a Table

SQL Server
>
Transact-SQL

Hi, I Have a stored procedure sp_procedure1.When I get execute these stored proc, I am a getting a result with 20 columns.Now, I would like to copy the Result ...

Unanswered | 4 Replies | 57 Views | Created by msanthosh178 - 19 hours 29 minutes ago | Last reply by Russ Loski - 14 hours 38 minutes ago
Items 1 to 20 of 86634 Next ›

Forums [ view all ]

Selected forums

Who will be announced the next Microsoft TechNet Guru? Read more about July 2017 competition:

POSTING TIPS - Code, Images, Hyperlinks, Details

Things that make you go HMMMM.... when 1 is not 1

Backup sets not dropping out of Backup Device

Ideas to improve performance of this trigger code

Delete Query is Performing too slow with around 6 million records to delete

member Eligibility span logic

combine select sta in one query

Alternative to sum over order by

SQL HELP

T-SQL load csv file

Need to split data as per dates

Insert int with spaces in BDD

Year, Month and Day between two dates

Need help with cross join

Data Mapping when output field is composed from columns of multiple tables in the database

User-Defined Table Types in SQL Server 2005

SELECT the highest number in an varchar field with mixed content

Output date field formatted differently.

Cant link tables properly. Msoft Access

invalid object name

Copying the Result set of Stored Procedure without Creating a Table