ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,431 through 8,445 (of 10,143 total)

RE: cannot insert duplicate key row in object 'tablename' with unique index 'indexname'

Hi Venki
Can you post the script for the table please? This will allow future posters to evaluate the problem.
^{“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

April 22, 2009 at 6:19 am

#982127
RE: Help required in SQL 2005

Syed Aun Shah (4/22/2009)
sample data is as:
table name: Student
Field Name: Stuent ID
Data in the field looks like:
1*10
11*12
1212*11
1234*11
12345*12
433444*10
Please read the link below, and provide table scripts and sample data, which...
^{“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

April 22, 2009 at 6:16 am

#982123
RE: CASE not recognizing nulls on outer joins with no corresponding record

No problem - what syntax did you settle for?
^{“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

April 22, 2009 at 5:59 am

#982108
RE: Error between unicode and non-unicode string data types!

A Little Help Please (4/22/2009)
Thanks,
I have checked the csv file, i do not have any rows with " or '
If there are definitely no rows with embedded single or double...
^{“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

April 22, 2009 at 5:58 am

#982105
RE: Help required in SQL 2005

Check out LEFT() and CHARINDEX() in Books Online.
^{“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

April 22, 2009 at 5:41 am

#982087
RE: Error between unicode and non-unicode string data types!

A Little Help Please (4/22/2009)
Thanks Chris,
Im a bit lost now...
You say I got an embedded single or double quotes in an input string which I'v designated as an output column....
^{“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

April 22, 2009 at 5:16 am

#982074
RE: CASE not recognizing nulls on outer joins with no corresponding record

Use a searched case, otherwise you're using a comparison operator which won't work with NULLs:
DROP TABLE #NullSample
CREATE TABLE #NullSample (ID INT, Something VARCHAR(15))
--
INSERT INTO #NullSample (ID, Something)
SELECT 1, 'a value'...
^{“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

April 22, 2009 at 4:37 am

#982055
RE: Error between unicode and non-unicode string data types!

A Little Help Please (4/22/2009)
What does the following error mean?
TITLE: Microsoft Visual Studio
------------------------------
The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers...
^{“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

April 22, 2009 at 3:11 am

#982023
RE: Remove Unwanted Char From Record Details

ubeauty (4/22/2009)
The script to update the assignment code with the newly updated LC157790 without the tab chars is just not working
Have you tested the SELECT part on its own?
SELECT 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

April 22, 2009 at 3:07 am

#982022
RE: DML in Functions

You're welcome - and I'm no 'sir', just a common working person, like yourself 😀
^{“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

April 22, 2009 at 2:55 am

#982013
RE: Remove Unwanted Char From Record Details

So there are embedded tab chars in strings which look like this: 'LC157790 /TCP'
In which case Flo's function will truncate from the first tab found...
First things first - do 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

April 22, 2009 at 2:53 am

#982011
RE: Remove Unwanted Char From Record Details

ubeauty (4/22/2009)
I won't be able to drop the table due to keys in place (1 primary and 13 foreign) but when using the update section of the code above:
UPDATE clientsupplier...
^{“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

April 22, 2009 at 2:32 am

#982003
RE: Error between unicode and non-unicode string data types!

Check out the NVARCHAR datatype in BOL. You will need to change the size of your VARCHAR receiving column.
^{“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

April 22, 2009 at 2:29 am

#982000
RE: DML in Functions

From BOL, the first few sentences for CREATE FUNCTION:
Creates a user-defined function. This is a saved Transact-SQL or common language runtime (CLR) routine that returns a value. User-defined functions cannot...
^{“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

April 22, 2009 at 2:26 am

#981999
RE: Remove Unwanted Char From Record Details

ubeauty (4/22/2009)
It doesn't look like they are tab characters as when running the script above the following error message gets returned:
Conversion failed when converting the varchar value 'LC157790' to data...
^{“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

April 22, 2009 at 2:04 am

#981987

Viewing 15 posts - 8,431 through 8,445 (of 10,143 total)