Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,961 through 12,975 (of 59,062 total)

RE: How to use dynamic pivot on this data

NineIron - Friday, February 2, 2018 8:38 AM
I've tried to understand dynamic sql but, to no avail. Could you tell me how...

February 4, 2018 at 3:41 pm

#1978479
RE: How to use dynamic pivot on this data

John Mitchell-245523 - Friday, February 2, 2018 8:52 AM
Step by step dynamic pivot script? Your wish is my command. It's...

February 4, 2018 at 3:23 pm

#1978478
RE: SQL Server 3rd party Backup tool

ALIF-662928 - Thursday, February 1, 2018 12:42 PM
hi,
we have a DB of 20 TB in 2 files, got lot of unused space...

February 4, 2018 at 1:47 pm

#1978476
RE: Assign incrementing letters to same value

Talvin Singh - Sunday, February 4, 2018 12:15 PM
to be honest, it could be a numberCode rather than letterCode, i just need...

February 4, 2018 at 1:17 pm

#1978474
RE: Huge Latency in TempDB

RandomStream - Sunday, February 4, 2018 11:36 AM
Jeff Moden - Sunday, February 4, 2018 9:53 AM

February 4, 2018 at 12:22 pm

#1978472
RE: Send HTML Mail Using T-SQL

dudik - Sunday, February 4, 2018 8:55 AM
Hello,
I'm trying to create a SP that will take a Temp Table and will send...

February 4, 2018 at 11:59 am

#1978470
RE: Assign incrementing letters to same value

Talvin Singh - Sunday, February 4, 2018 11:12 AM
not quite.
what the above code does is links the point ON the id in...

February 4, 2018 at 11:22 am

#1978467
RE: Today's Random Word!

triquetra

February 4, 2018 at 10:05 am

#1978464
RE: Huge Latency in TempDB

RandomStream - Friday, February 2, 2018 5:37 PM
Jeff Moden - Friday, February 2, 2018 6:36 AM

February 4, 2018 at 9:53 am

#1978463
RE: Need counts of orders per week grouped by week

jcelko212 32090 - Saturday, February 3, 2018 9:11 PM
Bad manners and ignorance are not a good way to go through a...

February 4, 2018 at 8:32 am

#1978462
RE: Need counts of orders per week grouped by week

meichmann - Friday, February 2, 2018 9:27 AM
Jeff Moden - Thursday, February 1, 2018 4:53 PM

February 2, 2018 at 3:40 pm

#1978422
RE: Calendar table

Darko Martinovic - Friday, February 2, 2018 7:13 AM
Jeff Moden - Friday, February 2, 2018 6:39 AM

February 2, 2018 at 8:48 am

#1978361
RE: Calendar table

Darko Martinovic - Friday, February 2, 2018 12:51 AM
Jeff Moden - Thursday, February 1, 2018 1:12 PM

February 2, 2018 at 6:39 am

#1978336
RE: Huge Latency in TempDB

kevaburg - Friday, February 2, 2018 5:06 AM
Have you looked at your wait stats? Although you haven't provided any detail I can guess...

February 2, 2018 at 6:36 am

#1978335
RE: $LASTDAYOFMONTH

Sergiy - Thursday, February 1, 2018 7:52 PM
If DeliveryDt contains (will possibly ever contain) a time portion (the data type DATETIME would...

February 1, 2018 at 9:29 pm

#1978294

Viewing 15 posts - 12,961 through 12,975 (of 59,062 total)