ChrisM@Work

Forum Replies Created

Viewing 15 posts - 2,131 through 2,145 (of 10,143 total)

RE: Are the posted questions getting worse?

BWFC (10/1/2015)
ChrisM@Work (10/1/2015)
BWFC (10/1/2015)
I got a bacon making kit for my birthday on Sunday. I can't wait to give it a go. Hopefully next month there'll be a...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 1, 2015 at 4:10 am

#1830684
RE: Are the posted questions getting worse?

BWFC (10/1/2015)
I got a bacon making kit for my birthday on Sunday. I can't wait to give it a go. Hopefully next month there'll be a butty with...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 1, 2015 at 2:51 am

#1830669
RE: How to tune this query

Grace09 (9/30/2015)
I have a simple query, Select Max(Substring(nd_num, 12,3) from NDE where datepart(dd, nd_adate)=2. The query plan is attached. How should I tune this query? It comes to the top...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 1, 2015 at 2:14 am

#1830659
RE: Are the posted questions getting worse?

dwain.c (10/1/2015)
BL0B_EATER (10/1/2015)
ChrisM@Work (10/1/2015)
Lynn Pettis (9/30/2015)
Jack Corbett (9/30/2015)
SQLRNNR (9/30/2015)
Ed Wagner (9/30/2015)
Brandie Tarvin (9/30/2015)
SQLRNNR (9/30/2015)
Eirikur Eiriksson (9/30/2015)
WayneS (9/30/2015)
Luis Cazares (9/30/2015)
ChrisM@Work (9/30/2015)
Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/2015)
An unsolicited email has just dropped...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 1, 2015 at 1:50 am

#1830653
RE: Are the posted questions getting worse?

BL0B_EATER (10/1/2015)
ChrisM@Work (10/1/2015)
Lynn Pettis (9/30/2015)
Jack Corbett (9/30/2015)
SQLRNNR (9/30/2015)
Ed Wagner (9/30/2015)
Brandie Tarvin (9/30/2015)
SQLRNNR (9/30/2015)
Eirikur Eiriksson (9/30/2015)
WayneS (9/30/2015)
Luis Cazares (9/30/2015)
ChrisM@Work (9/30/2015)
Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/2015)
An unsolicited email has just dropped into...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 1, 2015 at 1:27 am

#1830643
RE: Are the posted questions getting worse?

Lynn Pettis (9/30/2015)
Jack Corbett (9/30/2015)
SQLRNNR (9/30/2015)
Ed Wagner (9/30/2015)
Brandie Tarvin (9/30/2015)
SQLRNNR (9/30/2015)
Eirikur Eiriksson (9/30/2015)
WayneS (9/30/2015)
Luis Cazares (9/30/2015)
ChrisM@Work (9/30/2015)
Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/2015)
An unsolicited email has just dropped into my Hotmail...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

October 1, 2015 at 1:23 am

#1830641
RE: Are the posted questions getting worse?

Alvin Ramard (9/30/2015)
Brandie Tarvin (9/30/2015)
Alvin Ramard (9/30/2015)
HARD: Another 4 letter word. 😉
Hush, you! 😛
Oh wait! Not all four letter words are bad!
Cold Beer: Two four letter words together...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 8:13 am

#1830459
RE: Syntax help please in creating an index

mw112009 (9/30/2015)
Table Name: Denominator
Already has the following constraint:
PK_Denominatorclustered, unique, primary key located on PRIMARY DenominatorID
How can I add a unique key that will cover the 3 fields --> MemberID,MeasureID,TimePeriodID
I also...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 7:52 am

#1830442
RE: Are the posted questions getting worse?

Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/2015)
An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a permy dev DBA role in Soho (London) paying £50k to £90k....
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 7:42 am

#1830433
RE: Are the posted questions getting worse?

Brandie Tarvin (9/30/2015)
Ugh. SQL Server is HARD.
whimper
An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a permy dev DBA role in Soho (London) paying...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 7:27 am

#1830418
RE: How to trim sql query

elmnas (9/30/2015)
Hello people I have made following query,
How do I trim my result without replace anything in the current DB?
here is my query
SELECT
tt.bestdatum as 'Year',
FROM
[myDB].dbo.myTable as tt INNER JOIN
WHERE...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 6:49 am

#1830389
RE: Are the posted questions getting worse?

Phil Parkin (9/30/2015)
Brandie Tarvin (9/30/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
This made me giggle
*cough*:cool:
Grrr. The way he phrased his thank you. Yes, I piled on. But believe me, what I posted was far...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 5:05 am

#1830380
RE: Sum with ID

girl_bj (9/30/2015)
IDCode Amount
999 07032.00
999 21187.00
888 226200.00
999 125829.00
If code is 1 means discount.
I would like to pull all column but the amount I get is different.
26200.00-(7032+1187+25829.00)
i did this:
select id,discount-amount total
from(
select id,sum(case...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 5:02 am

#1830379
RE: convert rows to columns in query

elham_azizi_62 (9/30/2015)
hello.
thanks for your reply.
I already need this out put:
1188 Ali Ahmadi BaseSalary 1213232323 ExtraSalary 54585 SpecialSalary 245832
1245 ahmad Alipour Null Null ExtraSalary 2526961 Null Null
1478 sara Emami BaseSalary...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 4:52 am

#1830377
RE: Getting related records setbased results

ps_vbdev (9/29/2015)
ok try this link to my skydrive.
https://onedrive.live.com/redir?resid=F16A00370CA83923!60116&authkey=!ABYu99It012qkds&ithint=folder%2ctxt
Local policy prevents me from accessing this at work. I'll try at home.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 30, 2015 at 1:27 am

#1830346

Viewing 15 posts - 2,131 through 2,145 (of 10,143 total)