ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 10,143 total)

RE: Help on Update

Lokesh Vij (10/5/2012)
I might be wrong as well. Let jdelorino confirm!
Exactly.
^{“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 5, 2012 at 3:51 am

#1545973
RE: execute a storedprocedure where ever he wants to execute in any database it it possible?

naga.rohitkumar (10/5/2012)
Hi all
one of my application user asking to give access to execute a storedprocedure where ever he wants to execute in any database it it possible? if so how...
^{“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 5, 2012 at 3:50 am

#1545972
RE: script which will give present existing Jobs in the sql server instance

SQLDBA ARJUN (10/5/2012)
hi,
i need a script which will give present existing Job names in the sql server instance.
thanks
Arjun
This article[/url] will help you write your own script.
^{“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 5, 2012 at 3:30 am

#1545963
RE: How to insert records based on Audit Table

sqlstud (10/5/2012)
...
How will we do this using SSIS 2005?
Regards
Sql
SSIS is a bit overkill for this.
INSERT INTO ...
SELECT... FROM ... 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

October 5, 2012 at 3:10 am

#1545951
RE: UPDATE Does Nothing (Executing Query displays in status)

EdA ROC (10/5/2012)
It's known as UPDATE FROM, and it's typically used to update a table with data from another and / or update a table filtered by a join 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 5, 2012 at 2:50 am

#1545943
RE: Help on Update

jdelorino (10/5/2012)
thank you sir for your reply,but the column for totalcount displays only 0 not the actual value of the totalcount column.
It works for me:
CREATE TABLE #SourceTable (
TERMINALID VARCHAR(15),
TERMINALDESC...
^{“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 5, 2012 at 2:44 am

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

What will the table [dbo].[Entity.cat] contain, other than cities?
^{“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 5, 2012 at 2:39 am

#1545934
RE: how convert nvarcar to int

hoseini_akram (10/4/2012)
hello
Sorry, I'm Convert one of the fields of Table Nvarchar(10) to integers
Please help me
If you are having problems doing this, it's because the column contains...
^{“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 5, 2012 at 2:25 am

#1545932
RE: UPDATE Does Nothing (Executing Query displays in status)

kapil190588 (10/5/2012)
Hi,
It should be
UPDATE table_name
SET RefreshDate = '20120822 08:00';
rather than
UPDATE cjs
SET RefreshDate = '20120822 08:00';
else it will throw error
Almost, but not quite. The OP's statement is
UPDATE cjs
SET...
^{“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 5, 2012 at 2:23 am

#1545931
RE: Help on Update

-- CROSSTAB query
SELECT ERRORCODE, ERRORDESC,
Terminal_1 = MAX(CASE WHEN TERMINALID = 'Terminal_1' THEN TOTALCOUNT ELSE 0 END),
Terminal_2 = MAX(CASE WHEN TERMINALID = 'Terminal_2' THEN TOTALCOUNT ELSE 0 END)
FROM #SourceTable
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

October 5, 2012 at 2:17 am

#1545930
RE: Are the posted questions getting worse?

Mark-101232 (10/4/2012)
I've waited five years, but finally I've got a reply!
http://www.sqlservercentral.com/Forums/FindPost1368501.aspx
Shame it's not billable Mark, we could all have gone out for a beer on the interest!
^{“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 5, 2012 at 1:51 am

#1545923
RE: Spiltting columns in sql 2008

Trout (10/2/2012)
hello i have one column that I need split into two, the colum records age value, and the name of the colum is ageatdeath
results for eg are:
51years
62years
45years...
What...
^{“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 5, 2012 at 1:49 am

#1545922
RE: Temp table for Performance Impact

TheSQLGuru (10/4/2012)
>>Working with big tables in DM environments, it's almost always worth putting an index or two on temp tables. Anything over 10k rows and it's likely to make 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 4, 2012 at 9:49 am

#1545640
RE: Multipe letters into one

Eugene Elutin (10/4/2012)
dwain.c (10/4/2012)
...
This is kinda obscure too.
SELECT IDENTITY(INT,1,1) AS N
INTO #t
FROM (VALUES($),($),($),($),($),($),($),($),($),($))a(N)
CROSS JOIN (VALUES($),($),($),($),($),($),($),($),($),($))b(N);
There I go thinking about fortune and glory again! Well fortune anyway. 😛
No way you...
^{“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 4, 2012 at 8:45 am

#1545595
RE: Merge Duplicate values

SELECT
nameid,
telephone1 = MAX(CASE WHEN rn = 1 THEN telephone END),
telephone2 = MAX(CASE WHEN rn = 2 THEN telephone END),
telephone3 = MAX(CASE WHEN rn = 3 THEN...
^{“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 4, 2012 at 8:36 am

#1545587

Viewing 15 posts - 5,461 through 5,475 (of 10,143 total)