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

0 Votes

Homework: Nested While loops

SQL Server
>
Transact-SQL

Hi forum, I am trying to create a set of nested loops that will execute the inner loop based on values from the outer loop. My effort thus far ...

Unanswered | 1 Replies | 18 Views | Created by Durbslaw - 30 minutes ago | Last reply by Aung Mon Chit Htwe - 12 minutes ago
1 Votes

How to get total cost per hotel and transfer per 8 days ?

SQL Server
>
Transact-SQL

Problem How to get total cost per hotel and transfer per 8 days ? Details 8 days = 7 nights meaning 8 days = 7 days ...

Unanswered | 10 Replies | 144 Views | Created by ahmedbarbary - Saturday, July 22, 2017 5:48 PM | Last reply by Erland Sommarskog - 56 minutes ago
0 Votes

Joining on a Calendar

SQL Server
>
Transact-SQL

Hi All. I've been trying to figure out how to fix this, and any help would be wonderful. I attached a picture containing two example tables, and what I'd like the final query to ...

Proposed | 4 Replies | 140 Views | Created by pantherfanrh - Thursday, July 06, 2017 12:06 PM | Last reply by Xi Jin - 1 hour 2 minutes ago
2 Votes

dynamic sql if condition

SQL Server
>
Transact-SQL

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

Proposed | 6 Replies | 93 Views | Created by coool_sweet - Friday, July 21, 2017 6:54 PM | Last reply by Will_Kong - 1 hour 24 minutes ago
0 Votes

data conversion failed

SQL Server
>
Transact-SQL

hi I am loading my data from stg to final table . getting error; [Data Conversion [2]] Error: Data ...

Unanswered | 2 Replies | 79 Views | Created by coool_sweet - Friday, July 21, 2017 1:37 PM | Last reply by Xi Jin - 1 hour 55 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 | 39 Replies | 326 Views | Created by Pradeep.Korukonda - Tuesday, July 18, 2017 8:13 AM | Last reply by Pradeep.Korukonda - 2 hours 25 minutes ago
1 Votes

help with distinct query

SQL Server
>
Transact-SQL

hi, i have this table NUmber | CustName | Name | QtyCust | ...

Unanswered | 3 Replies | 97 Views | Created by GMS-Tech - Saturday, July 22, 2017 9:59 AM | Last reply by Aung Mon Chit Htwe - 2 hours 38 minutes ago
0 Votes

update trigger : only when specific field (column) is updated

SQL Server
>
Transact-SQL

Hello, I have this trigger that updates a sequence status ALTER trigger [dbo].[tupdate_seq_status] on [dbo].[wo_seq] after ...

Unanswered | 4 Replies | 82 Views | Created by MigrationUser 1 - Friday, July 21, 2017 8:25 PM | Last reply by Xi Jin - 6 hours 7 minutes ago
1 Votes

Non related table updates

SQL Server
>
Transact-SQL

Hi. Looking for a way of updating non related tables according to below: Source table has X rows with different values ...

Proposed | 6 Replies | 77 Views | Created by SysGreg - 15 hours 53 minutes ago | Last reply by Aung Mon Chit Htwe - 6 hours 24 minutes ago
1 Votes

Proposing new Data Access Standard: Load/Store/Delete

SQL Server
>
Transact-SQL

All data access must go through Load, Store, or Delete. ...

Unanswered | 2 Replies | 136 Views | Created by andrewbbrown - Saturday, July 22, 2017 1:44 AM | Last reply by Xi Jin - 6 hours 32 minutes ago
0 Votes

Row_number() over partition - Assistance

SQL Server
>
Transact-SQL

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 | 24 Replies | 354 Views | Created by DANII_PINK - Thursday, July 20, 2017 1:05 AM | Last reply by Jingyang Li - 6 hours 46 minutes ago
4 Votes

Date is showing 1900-01-01 instead of blank

SQL Server
>
Transact-SQL

getdate() then '' else Elastdate End as "Last_Date" from #t1 where EBegindate

Answered | 5 Replies | 63 Views | Created by SmithDy - 11 hours 21 minutes ago | Last reply by SmithDy - 10 hours 28 minutes ago
0 Votes

Using nested query instead of join, but need to select from within the subquery

SQL Server
>
Transact-SQL

select p.ID, p.Name, s.Format from s where s.subID in (select p.subID from ...

Proposed | 7 Replies | 112 Views | Created by braveheart0707 - Saturday, July 22, 2017 8:17 PM | Last reply by EitanBlumin - 20 hours 7 minutes ago
2 Votes

drop global temp table

SQL Server
>
Transact-SQL

i need to drop my global temp table even if it has 0 rows . i need to make this statement in dynamic sql . please ...

Proposed | 4 Replies | 91 Views | Created by coool_sweet - Saturday, July 22, 2017 12:31 AM | Last reply by Erland Sommarskog - 22 hours 46 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 | 6 Replies | 109 Views | Created by JCEH - Friday, July 21, 2017 5:14 PM | Last reply by Erland Sommarskog - Saturday, July 22, 2017 9:34 PM
0 Votes

ARGH IN WINDOW

SQL Server
>
Transact-SQL

I was recently editing a procedure in SSMS 2005 and I hit some keystrokes that I don't remember and suddenly the screen displayed the ...

Answered | 6 Replies | 3965 Views | Created by SQLKing - Wednesday, June 27, 2012 1:21 PM | Last reply by Harvey Myers - Saturday, July 22, 2017 8:37 PM
2 Votes

daily report for orders being delivered the next day

SQL Server
>
Transact-SQL

GETDATE() AND

Answered | 15 Replies | 274 Views | Created by Louie E - Wednesday, July 05, 2017 8:29 PM | Last reply by Louie E - Friday, July 21, 2017 9:46 PM
0 Votes

Partitioning Other Than By Date

SQL Server
>
Transact-SQL

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 | 220 Views | Created by lcerni - Monday, July 10, 2017 7:44 PM | Last reply by lcerni - Friday, July 21, 2017 5:30 PM
0 Votes

how to copy a row changed some value

SQL Server
>
Transact-SQL

hi ; I have one table like below ID CODE NAME ...

Answered | 35 Replies | 216 Views | Created by Aly14 - Tuesday, July 18, 2017 4:50 PM | Last reply by Aly14 - Friday, July 21, 2017 2:59 PM
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 | 21 Replies | 144 Views | Created by Vissili - Thursday, July 20, 2017 1:00 PM | Last reply by Vissili - Friday, July 21, 2017 12:34 PM
Items 1 to 20 of 86610 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

Homework: Nested While loops

How to get total cost per hotel and transfer per 8 days ?

Joining on a Calendar

dynamic sql if condition

data conversion failed

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

help with distinct query

update trigger : only when specific field (column) is updated

Non related table updates

Proposing new Data Access Standard: Load/Store/Delete

Row_number() over partition - Assistance

Date is showing 1900-01-01 instead of blank

Using nested query instead of join, but need to select from within the subquery

drop global temp table

T-SQL load csv file

ARGH IN WINDOW

daily report for orders being delivered the next day

Partitioning Other Than By Date

how to copy a row changed some value

Insert int with spaces in BDD