ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,416 through 5,430 (of 10,143 total)

RE: SQL query statement for copying data from different rows to different rows

zahid_7777 (10/8/2012)
I just like to know the command to copy data (specific range like 10 rows) containing in a COMPANY_CODE and will be copied to another COMPANY_CODE starting with 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 9, 2012 at 1:23 am

#1547039
RE: Count duplicate occurances in relational tables

Welcome to ssc. There's an excellent article linked in my signature block "please read this" - have a read, it will help you get faster, more accurate answers to your...
^{“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 9, 2012 at 1:12 am

#1547034
RE: A severe error occurred on the current command

Grant Morton (10/9/2012)
Thanks for the responses everyone.
I tried the following code which ChrisM@Work suggested:
SELECT dgs.Shift, SUM(dgs.Value) AS ShiftTotal
FROM Reporting.fctDeltaGammaShift dgs
INNER JOIN Reporting.dimLifeLicence LifeLic
ON dgs.LifeLicenceID = LifeLic.ID
AND LifeLic.LifeLicence IN ('LL','LA','CAL')
INNER JOIN...
^{“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 9, 2012 at 1:07 am

#1547033
RE: Need to fill the Gaps with previous value

Jeff Moden (10/8/2012)
dwain.c (10/7/2012)[hrJeff - I don't think this solution works with your test harness.
I did say that I needed to make a change to get it to work and...
^{“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 8, 2012 at 11:31 am

#1546861
RE: Problem (doubt) with an Index on a composite key

Carl0s_ (10/8/2012)
Thanks for reply ChrisM@Work
I have the same structure in my city table, I refer to (state region) with entity cat (federative entity), my doubt here is, is correct to...
^{“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 8, 2012 at 10:35 am

#1546838
RE: SQL Server Conference/Seminar in the UK.

Have a look here: http://sqlserverfaq.com/%5B/url%5D
^{“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 8, 2012 at 10:05 am

#1546819
RE: Stored Procedure to call one by one value - Alphanumeric

Skanda (10/8/2012)
Hi,
Function is working fine,
but when ever i call the function, it should return single value only,
if i call 10 times - 10 alphanumeric values should be written...
^{“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 8, 2012 at 9:48 am

#1546808
RE: Interesting Sql protocol issue around calling stored procedure with select and update

Sean Lange (10/8/2012)
blakmk (10/8/2012)
I have a requirement to return a batch of records and then mark the batch complete. I was thinking to acheive this with a select and the...
^{“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 8, 2012 at 9:40 am

#1546801
RE: Problem (doubt) with an Index on a composite key

ChrisM@Work (10/8/2012)
Carl0s_ (10/8/2012)
Can someone tell me an opinion about this design?, is bad to use composite key in that way, is better to use subrogate? and what is better way...
^{“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 8, 2012 at 9:27 am

#1546793
RE: Problem (doubt) with an Index on a composite key

Carl0s_ (10/8/2012)
Can someone tell me an opinion about this design?, is bad to use composite key in that way, is better to use subrogate? and what is better way to...
^{“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 8, 2012 at 9:25 am

#1546791
RE: Stored Procedure to call one by one value - Alphanumeric

You will need to persist the values which have already been generated, or read them from the table in which they are being used.
Create a table outside of the...
^{“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 8, 2012 at 8:27 am

#1546751
RE: A severe error occurred on the current command

Grant Morton (10/8/2012)
Thanks for the response. I don't think it's related to the link you sent because I'm not using INTERSECT. Here is the query which generates the error:
SELECT Shift,...
^{“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 8, 2012 at 7:58 am

#1546731
RE: Need to fill the Gaps with previous value

dwain.c (10/8/2012)
Chris - I'm gonna keep moanin' until I win one of these performance races against you.
So I'll submit this (stealing your Tally table):
;WITH Tally (n) AS (
...
^{“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 8, 2012 at 7:33 am

#1546719
RE: SQL query statement for copying data from different rows to different rows

You need to replace the SELECT * with actual column names.
^{“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 8, 2012 at 7:11 am

#1546705
RE: Alphanumeric number generation

Skanda (10/8/2012)
Hi,
I need to write a SQL query to print the following aphanumberic sequence in SQL 2008.
0001, 0002, ... , 0009, 000A, ... , 000Z, ... , 0010, 0011, ......
^{“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 8, 2012 at 6:20 am

#1546680

Viewing 15 posts - 5,416 through 5,430 (of 10,143 total)