Forum Replies Created
Viewing 15 posts - 316 through 330 (of 530 total)
-
RE: Arithmetic overflow error
Sorry, I can't see a pattern. Maybe someone else could help?
-
RE: Query Help .NET
Well, with correlation I meant just that your query was not using your table
And I didn't understand entirely your...
-
RE: Query Help .NET
Seems nice but I see no correlation between the procedure and the table DDL you have posted...
It is also considered to be best practice to avoid using the space character...
-
RE: Query Help .NET
That you havn't specified WHICH of the two CompanyID columns you intend with your WHERE clause. Remember that you have two. One in each table. (You need this even if...
-
RE: Pulling data from Oracle tables to SQL Server
One easy way of getting as few rows as possible could be to retrieve just the rows you absolutely need into a temporary table. Thus you know no more work...
-
RE: Query Help .NET
Did the examples help you?
I would suggest creating your SPs through SQL Query Analyzer
Wizards can be good, but they are not so...
-
RE: Query Help .NET
Hmm.. Well, for example:
ALTER PROCEDURE GetBlindCompany
AS
SELECT DISTINCT
Company.CompanyID, Company.CompanyName, Product.ModelName, Product.ProductImage,
-
RE: Query Help .NET
...but if you do include all columns in your GROUP BY, there is not much point to the query. You could be better off doing a DISTINCT as it would not...
-
RE: Problem retrieving XML from Sql server.
True, but taking the string and removing the LineFeeds (which usually are not outputted in XML) you have:
<edition number="1 ">Scie </edition><edition number="2 ">Math </edition><edition number="3 ">Litt </edition><edition number="4 ">Litt </edition><edition...
-
RE: Problem retrieving XML from Sql server.
Haha
Juste to clarify Remi Gregoire, I was directing my answer to
-
RE: Problem retrieving XML from Sql server.
Hmm. Are you executing this query in query analyzer? Are you aware of the default 256 char column limit in that application?
Try to direct your query into a file...
-
RE: Query Help .NET
Well. Are you sure that SP runs?
Semantically it is incorrect...
..and maybe this question would have been better off if it appeared in the T-SQL section?
//Hanslindgren
-
RE: How2get rows relation between same table - Need Solution
How do you mean, pass parameter? What kind of solution are you looking for?Maybe SELECT * FROM UNITCONVERTION WHERE 38 IN ( IDFrom , IDto )is enough? //Hanslindgren -
RE: Arithmetic overflow error
Hello!
Have you checked if the two schemas (On publisher and on subscriber) are still the same? Could it have been modified at the publisher ant not in the subscriber? Watch...
-
RE: Moving user roles to another server/database
Hmm. Just by connecting them with 'sa' capabilities I am not sure has to be considered to be bad practice. Althrough I would connect a specific user (I.e A user would...
Viewing 15 posts - 316 through 330 (of 530 total)