Viewing 15 posts - 9,076 through 9,090 (of 10,143 total)
[font="Courier New"]DROP TABLE #SOC_CARE_DATA_QUALITY_EXTRACT_ALIAS_DUPS_ONLY
CREATE TABLE #SOC_CARE_DATA_QUALITY_EXTRACT_ALIAS_DUPS_ONLY
([fi pin] INT, Alias VARCHAR(100))
INSERT INTO #SOC_CARE_DATA_QUALITY_EXTRACT_ALIAS_DUPS_ONLY
([fi pin], Alias)
SELECT 118007, 'Sara Jane smith'UNION ALL
SELECT 118007, 'Sarah Smith'UNION ALL
SELECT 118007, 'Sara Jayne Smith'UNION ALL
SELECT...
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
December 19, 2008 at 4:30 am
CREATE PROCEDURE [dbo].[MakeNumbersTable]
-- Courtesy of Jeff Moden, SSC
AS
IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[Numbers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE dbo.Numbers
--===== Create and populate the Tally...
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
December 19, 2008 at 4:21 am
swapna.katare (12/19/2008)
thx but the query did not work. it is showing the error Invalid object name 'numbers'.what if i have 500 rows how to insert the values
Click on the highlighted...
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
December 19, 2008 at 3:49 am
Can you post the code for the function?
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
December 19, 2008 at 3:39 am
bhushanhegde (12/18/2008)
Hi,I dont have rights to create any objects in the data base since that is in production.
I want to do with any sys defined functions....is it possible?
So...does it work?
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
December 19, 2008 at 3:26 am
Here's a tally-table solution which will run fast.
[font="Courier New"]DROP TABLE #Indus
CREATE TABLE #Indus (serial INT, qh11 VARCHAR(255), qh21 VARCHAR(255))
INSERT INTO #Indus (serial, qh11, qh21)
SELECT 1, '234567890', '45890' UNION ALL
SELECT 2,...
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
December 19, 2008 at 3:22 am
Richard Hayes (12/19/2008)
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
December 19, 2008 at 2:49 am
r.hensbergen (12/18/2008)
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
December 19, 2008 at 2:35 am
WHEN NoEMail = '' THEN '0'
I'm getting confused now between NoMail, which is bit, and Email, which is some kinda string. But whichever, you're trying to match one to...
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
December 18, 2008 at 10:43 am
What is the datatype of the column NoMail in the customer table? If it's bit, then that's the source of your error message.
Do any of the values of EMail not...
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
December 18, 2008 at 10:20 am
p.nagaravikumar (12/18/2008)
Thanks for response,Yes,i am looking the same.Ex customer table is having the customer names.I want to give the report in french language.
Regards
Ravi
Can you help us with a few samples...
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
December 18, 2008 at 9:28 am
Jack Corbett (12/18/2008)
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
December 18, 2008 at 9:14 am
Jeff Moden (12/18/2008)
bnordberg (12/18/2008)
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
December 18, 2008 at 9:12 am
What have you tried so far, ALI?
Thanks for providing the sample data and table creation scripts, top work.
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
December 18, 2008 at 9:04 am
GilaMonster (12/18/2008)
Ah. I thought that the end of the dynamic SQL would mean that the last reference to the global temp table was gone.
BOL doesn't make it clear - at...
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
December 18, 2008 at 8:30 am
Viewing 15 posts - 9,076 through 9,090 (of 10,143 total)