Msdn forums - Transact-SQL

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 | 20527 Views | Created by Kalman Toth - Monday, March 31, 2014 6:42 AM

0 Votes

want the whole list of repeatable keys from population where two cols might repeat

SQL Server
>
Transact-SQL

1 ) select distinct compositekey from #msdn m join cte1 on m.app = cte1.app and m.appkey = ...

Answered | 6 Replies | 180 Views | Created by db042190 - Friday, March 15, 2019 8:07 PM | Last reply by db042190 - 18 minutes ago
0 Votes

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

SQL Server
>
Transact-SQL

Hi everyone! While executing query in SSMS the query will provide few output then it will throw below error: A transport-level error has occurred when ...

Unanswered | 4 Replies | 54 Views | Created by dydoria - 19 hours 26 minutes ago | Last reply by Stefan Hoffmann - 1 hour 6 minutes ago
0 Votes

Using DB mail to send an Report via T-SQL getting Error Failed to initialize sqlcmd library with error number -2147467259.

SQL Server
>
Transact-SQL

I have an requirement to automate the dashboard report of Always ON via an script , the script is neat but i am planning to schedule the script via an SQL agent job and use SMTP ...

Unanswered | 0 Replies | 17 Views | Created by Eben Raja Earnest - 1 hour 32 minutes ago
0 Votes

how to handle data delimiter in data and also same delimiter for format

SQL Server
>
Transact-SQL

In this example 011916198 is only one column. how to handle this kind of scenario p

Unanswered | 2 Replies | 40 Views | Created by Pravin.c - 11 hours 11 minutes ago | Last reply by Tom Phillips - 1 hour 47 minutes ago
0 Votes

Help with SQL query

SQL Server
>
Transact-SQL

I am trying to calculate the following: We have group bookings held in our system as blocks. Blocks are not considered reservations until they are picked up and ...

Proposed | 4 Replies | 92 Views | Created by Fiotomas - 23 hours 56 minutes ago | Last reply by Fiotomas - 2 hours 24 minutes ago
5 Votes

Incorrect JOIN condition in recursive CTE?

SQL Server
>
Transact-SQL

t.Price ) SELECT * FROM consecutivePrice And sample data: DECLARE @Table TABLE ( ProductName VARCHAR(5), Iteration INT, [Price] ...

Unanswered | 16 Replies | 131 Views | Created by NiceStepUp - Thursday, March 21, 2019 12:25 PM | Last reply by Will_Kong - 4 hours 53 minutes ago
0 Votes

TSQL: Grouping continuous timeslots together

SQL Server
>
Transact-SQL

Dear community, hope you can help me solving this issue: I have to group continuous timeslots ...

Unanswered | 1 Replies | 26 Views | Created by tommired2000 - 5 hours 34 minutes ago | Last reply by Rachel_Wang - 4 hours 55 minutes ago
0 Votes

Update Next nth Business Date for date field in a table with millions of records

SQL Server
>
Transact-SQL

Hi team, Would need help to update next nth business date (excluding week end using datename , public holiday from public holiday table) based on datesample ...

Unanswered | 1 Replies | 37 Views | Created by New Member 101 - 23 hours 49 minutes ago | Last reply by Will_Kong - 5 hours 44 minutes ago
0 Votes

Excluding matching Rows

SQL Server
>
Transact-SQL

Hi, I have 2 table and I would like to join these 2 tables on a common column and then exclude the matching rows from the second table ( but return everything ...

Unanswered | 5 Replies | 140 Views | Created by John_tay - Wednesday, March 20, 2019 10:08 PM | Last reply by Rachel_Wang - 6 hours 8 minutes ago
0 Votes

while loop reverse number in sql server

SQL Server
>
Transact-SQL

Hi ,I have one doubt in sql server how to get reverse of number using while loop in sql ...

Unanswered | 2 Replies | 35 Views | Created by balakrishna324 - 7 hours 49 minutes ago | Last reply by Olaf Helper - 6 hours 21 minutes ago
0 Votes

find percentage

SQL Server
>
Transact-SQL

Hi, I have requirement as below. col A Col b col c ...

Unanswered | 5 Replies | 79 Views | Created by SFatimi - 22 hours 51 minutes ago | Last reply by Rachel_Wang - 7 hours 0 minutes ago
0 Votes

Designing a table for large amount of rows. No relationships

SQL Server
>
Transact-SQL

Id(GUID)(PK), Path(varchar), IsPublic(bit), FileType(int) The files can be accessed via Url by putting the GUID in the url, such ...

Unanswered | 2 Replies | 61 Views | Created by bobekhj_1989 - 15 hours 43 minutes ago | Last reply by André Renato Furtado - 9 hours 37 minutes ago
0 Votes

Common and uncommon problems solved with SQL/T-SQL

SQL Server
>
Transact-SQL

This is my first post on here, and it's not so much a question as it is a request. I started thinking about doing some SQL Projects and after doing a few, the idea of an open source SQL and T-SQL ...

Unanswered | 1 Replies | 90 Views | Created by Chessbrain - 17 hours 13 minutes ago | Last reply by Rachel_Wang - 10 hours 12 minutes ago
0 Votes

12 months data from date

SQL Server
>
Transact-SQL

Hi, I am using below query to get the last 12 months data from Sdate . if its 2019-03 it should give data from 2018-03 to 2019-03 but its not ...

Unanswered | 5 Replies | 75 Views | Created by Papil1 - 17 hours 4 minutes ago | Last reply by Will_Kong - 10 hours 32 minutes ago
0 Votes

Trend Query in SQL Server 2012

SQL Server
>
Transact-SQL

Hi , I want to query which area is on increasing trend of sales over time from following table Area ...

Answered | 11 Replies | 158 Views | Created by BreakItFixIt - Tuesday, March 19, 2019 7:45 PM | Last reply by Rachel_Wang - 11 hours 25 minutes ago
0 Votes

Find previous records that start froma partcular variable or steps.

SQL Server
>
Transact-SQL

Hi, I am working on to get the previous records that start from step 'B' and BW'. from step B and BW I want to know what are the previous 3 steps in a dynamic way. Below is a sample DDL and ...

Answered | 4 Replies | 118 Views | Created by Lenoj - Monday, March 18, 2019 9:32 AM | Last reply by Lenoj - 11 hours 37 minutes ago
1 Votes

How to apply data retention rules to a query using a control table?

SQL Server
>
Transact-SQL

Hello, We have SQL Server 2016 database with a similar design as follows; CREATE SCHEMA [Meta] AUTHORIZATION ...

Answered | 1 Replies | 63 Views | Created by KuzeyI - 18 hours 16 minutes ago | Last reply by Tom Cooper - 13 hours 14 minutes ago
0 Votes

join tables and concatenate strings - SQL 2008

SQL Server
>
Transact-SQL

Hello, Please see the attached two tables - tblMain, tblDetails. I would like to join these two tables such that it gives the result as in tblResult ...

Answered | 10 Replies | 150 Views | Created by arkiboys - Thursday, March 21, 2019 6:27 AM | Last reply by Jingyang Li - 14 hours 36 minutes ago
3 Votes

SQL Server set ansi_null_default off

SQL Server
>
Transact-SQL

Hi All Can someone tell me the difference between having the ANSI_NULL_DEFAULT [ON/OFF] Ive written code below and the both create nullable columns so im very ...

Answered | 8 Replies | 3204 Views | Created by shamas2121 - Tuesday, January 28, 2014 11:36 AM | Last reply by Antigoon - 15 hours 39 minutes ago
0 Votes

Need t-sql to Show header record value to child records

SQL Server
>
Transact-SQL

Hi All, I have a source table with 2 columns.. ID(int) and TxtValue( varchar) ID TxtValue 1 ...

Answered | 2 Replies | 47 Views | Created by sql9 - 16 hours 47 minutes ago | Last reply by sql9 - 16 hours 12 minutes ago
Items 1 to 20 of 92325 Next ›

Forums [ view all ]

Selected forums

POSTING TIPS - Code, Images, Hyperlinks, Details

want the whole list of repeatable keys from population where two cols might repeat

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Using DB mail to send an Report via T-SQL getting Error Failed to initialize sqlcmd library with error number -2147467259.

how to handle data delimiter in data and also same delimiter for format

Help with SQL query

Incorrect JOIN condition in recursive CTE?

TSQL: Grouping continuous timeslots together

Update Next nth Business Date for date field in a table with millions of records

Excluding matching Rows

while loop reverse number in sql server

find percentage

Designing a table for large amount of rows. No relationships

Common and uncommon problems solved with SQL/T-SQL

12 months data from date

Trend Query in SQL Server 2012

Find previous records that start froma partcular variable or steps.

How to apply data retention rules to a query using a control table?

join tables and concatenate strings - SQL 2008

SQL Server set ansi_null_default off

Need t-sql to Show header record value to child records