ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,911 through 5,925 (of 10,143 total)

RE: The multi-part identifier could not be bound.

kgillispie (8/13/2012)
I've read some suggestions on this forum, but none were able to help.. so am posting a new question.
I am running the below query but I end up 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

August 14, 2012 at 2:20 am

#1525388
RE: Today's Random Word!

L' Eomot Inversé (8/13/2012)
ChrisM@Work (8/13/2012)
Ray K (8/13/2012)
meh
Meths
Wood alcohol
Possibly, depends on how much.
^{“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

August 13, 2012 at 9:37 am

#1525133
RE: Best Strategy to Create a Million Files using SSIS

sradez_DBA (8/13/2012)
They are not searching the Database from the UI.The search is on the files.
It will be very interesting to see how this approach compares with the more conventional one,...
^{“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

August 13, 2012 at 9:35 am

#1525131
RE: unique constraint

Eugene Elutin (8/13/2012)
...
Same here. Experience takes precedence over theory.
...
Actually, you wouldn't even need a lot of experience to choose surrogate PK over natural key. Use common sense or apply...
^{“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

August 13, 2012 at 9:24 am

#1525119
RE: Best Strategy to Create a Million Files using SSIS

sradez_DBA (8/13/2012)
Hey Phil,
Thanks for the reply.
Our project involves storing the every detail of a product(example).When the users search for the product from the UI, they get this file which has...
^{“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

August 13, 2012 at 9:04 am

#1525097
RE: SELECT - CASE - GROUP BY

carl6885 (8/12/2012)
Thanks for the help! Got it working with:
SELECT tblErrors_ER.ErrorID, CASE WHEN Count(tblPolicyNumbers_ER.PolicyNumber) = 1 THEN MIN(tblPolicyNumbers_ER.PolicyNumber) ELSE 'Multiple' END
FROM tblErrors_ER
INNER JOIN tblPolicyNumbers_ER ON
tblErrors_ER.ErrorID = tblPolicyNumbers_ER.ErrorID
GROUP BY...
^{“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

August 13, 2012 at 8:08 am

#1525061
RE: unique constraint

Lynn Pettis (8/10/2012)
...
I like the idea of having a sid (a surrogate id) on my tables, even if I do have a natural key that can serve as a primary...
^{“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

August 13, 2012 at 7:42 am

#1525048
RE: Intresting Query

Jeff Moden (8/10/2012)
...My favorite question is becoming "Discuss the differences between a Clustered and Non-Clustered Index". 95% of the time I'm told "The Clustered index is always the PK...
^{“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

August 13, 2012 at 7:11 am

#1525035
RE: Today's Random Word!

Ray K (8/13/2012)
meh
Meths
^{“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

August 13, 2012 at 6:22 am

#1525020
RE: Calculating average for 3 consecutive years

SELECT *
FROM #Temp t
CROSS APPLY (
SELECT AVGfield3 = AVG(field3*1.00) FROM #Temp s
WHERE s.field2 = t.field2
AND s.field1 IN ( t.field1, DATEADD(YY, -1, t.field1), DATEADD(YY, -2, t.field1) )
) x
^{“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

August 13, 2012 at 4:10 am

#1524979
RE: how to write a select query by passing @cattyp as parameter for this tables and here i am trying for rand() in this select query ?

Here's another way:
declare @cattyp varchar(3) = 'cri'
SELECT a.alid,
a.cattyp,
a.altitle,
...
^{“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

August 13, 2012 at 3:32 am

#1524969
RE: Crazy Interviews

Lowell (8/7/2012)
I had a similar interview like laurie had years ago; they were interested in whether I knew vb6, ADO and whether i knew javascript; the questions had a couple...
^{“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

August 13, 2012 at 2:46 am

#1524952
RE: Reverse Of Number without Using reverse()

Cadavre (8/3/2012)
shahsn11 (8/3/2012)
Hi,
How will i reverse the number in SQL Server with out using reverse()
Is this an intellectual challenge? Because otherwise, use reverse().
I guess you could do something like...
^{“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

August 3, 2012 at 5:27 am

#1521319
RE: Reverse Of Number without Using reverse()

shahsn11 (8/3/2012)
Hi,
How will i reverse the number in SQL Server with out using reverse()
Why don't you want to use reverse() ?
^{“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

August 3, 2012 at 5:04 am

#1521308
RE: how to write a function to separate or split function to separate comma separated value in this table?

No functions...
-- sample data
declare @test1 table(
id int,
telephone varchar(4000)
)
insert into @test1
select 1,'004-26487,004-84576,9845678682' union all
select 2,'99942078682,002-2687,002-84576,99945678682' UNION ALL
SELECT 3,'002-2687' UNION ALL
SELECT 4,'' UNION ALL
SELECT 5, NULL
-- solution
SELECT
id,
NumberList =...
^{“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

August 3, 2012 at 4:25 am

#1521304

Viewing 15 posts - 5,911 through 5,925 (of 10,143 total)