ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,271 through 9,285 (of 10,143 total)

RE: Change a Views data types

A Little Help Please (12/5/2008)
Zero....
Is this going to drive you mad as it has done me! :crazy:
Thanks for your time, keep the suggestions coming....lol
You have no data in your bargains...
^{“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

December 5, 2008 at 5:08 am

#908168
RE: Change a Views data types

Try this:
SELECT COUNT(*) FROM dbo.Bargains
^{“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

December 5, 2008 at 5:02 am

#908165
RE: Change a Views data types

Ah, it's a NVARCHAR!
Please run these in QA (or SMS) and post the counts from each statement:
SELECT COUNT(*)
FROM dbo.Bargains b
GROUP BY b.Client, b.CountryCode, CAST(b.ClientID AS NVARCHAR (10))
SELECT COUNT(*)
FROM dbo.Bargains...
^{“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

December 5, 2008 at 4:51 am

#908159
RE: Change a Views data types

pri.amin (12/5/2008)
Same error with this INSERT:
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK_tblClients'.
Cannot insert duplicate key in object 'dbo.tblClients'.
The statement has been terminated.
Can I...
^{“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

December 5, 2008 at 4:14 am

#908139
RE: Change a Views data types

You're not accounting for the trimming of clientid when you extract from the bargains table and insert into clients table. But why all the fuss with views and DTS/SSIS whatever,...
^{“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

December 5, 2008 at 3:54 am

#908134
RE: Change a Views data types

Like this:
[font="Courier New"]SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwImportAllNewClientIDs
AS
SELECT CAST(b.ClientID AS VARCHAR (10)) AS ClientID, b.Client, b.CountryCode
FROM dbo.tblClients c
RIGHT OUTER JOIN dbo.Bargains b ON c.ClientID COLLATE...
^{“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

December 5, 2008 at 3:25 am

#908128
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

rbarryyoung (12/4/2008)
mtassin (12/4/2008)
I'm not sure if it's Business Object's best practice, but my best practices for Crystal Reports are to develop stored procedures to retrieve the data in exactly 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

December 5, 2008 at 2:20 am

#908108
RE: SQL Query not returning records for today

Hi rhubbard
No problem, should be pretty straightforward. But first, can you explain what this chunk of code does? I'm lost...
NVARCHAR1(Topic), NVARCHAR6 (Meeting Room Name), datetime1 (Meeting Start Time), datetime2 (Meeting...
^{“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

December 4, 2008 at 11:58 am

#907836
RE: How to handle "\" in the server name: Incorrect syntax near '\'

gregarobinson (12/4/2008)
Well, I cannot tell you what's different but I just tried this:
INSERT INTO [DEV001\SQL2005DEV].myDatabase.dbo.myTable
and it worked. "dbo" has always been present so that is not a change....
^{“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

December 4, 2008 at 10:56 am

#907802
RE: How to handle "\" in the server name: Incorrect syntax near '\'

Can you post the whole INSERT statement?
INSERT INTO DEV001\SQL2005DEV...........
^{“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

December 4, 2008 at 10:43 am

#907794
RE: How to handle "\" in the server name: Incorrect syntax near '\'

gregarobinson (12/4/2008)
Yes, I have run the insert on it's own without the server name, just the database name, and it works correctly.
Not the INSERT, the SELECT. What does it...
^{“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

December 4, 2008 at 10:42 am

#907793
RE: How to handle "\" in the server name: Incorrect syntax near '\'

Hi Greg
Some of our older servers have similar names and I've worked around it successfully by using square brackets, as you suggest.
Have you ran the SELECT part of your INSERT...
^{“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

December 4, 2008 at 10:36 am

#907785
RE: Error message looking at sysdatabases

What's sp_MSforeachdb running?
^{“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

December 4, 2008 at 9:13 am

#907692
RE: Error message looking at sysdatabases

What do you get when you run this:
select name from sysdatabases
where UPPER(name) LIKE 'ORTUSSEARCH%'
^{“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

December 4, 2008 at 9:04 am

#907674
RE: Error message looking at sysdatabases

Hi Simon
It's a long shot, but could it be case sensitivity? Try 'ortussearch' in your sp_MSforeachdb query.
Cheers
ChrisM
^{“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

December 4, 2008 at 8:43 am

#907644

Viewing 15 posts - 9,271 through 9,285 (of 10,143 total)