Viewing 15 posts - 1 through 15 (of 16 total)
I just figured out that If I give a page size of 29cm width then I am able to print that out in Landscape view, but the issue comes when...
May 1, 2009 at 1:42 pm
ALTER PROCEDURE [dbo].[usp_InsItem]
@Part_Num varchar(50)=NULL
AS
BEGIN
SET NOCOUNT OFF;
INSERT INTO Items
( [PartNum], [ItemOrder] )
VALUES( @Part_Num,
,(SELECT MAX(ItemOrder)
FROM Items
WHERE Part_Num =@Part_Num)
)
I am getting the Error if I do the above:
Subqueries are not allowed in this...
April 10, 2009 at 1:53 pm
Thanks for your reply. How Can I mark your reply as the Answer?
Do we do that like we do on asp.net forums?
April 6, 2009 at 1:52 pm
Thanks for your reply.
It is an Intranet app and I am using Windows Authentication.
How Can I pass parameters from ASP.NET To Report?
April 3, 2009 at 8:46 am
When I run the Command I get the following Error:
Use master
GO
RESTORE DATABASE MSR
FROM DISK= 'C:\MSR.bak'
GO
The backup set holds a backup of a database other than the existing 'MSR' database.
March 27, 2009 at 11:11 am
The Problem is when I try to restore it from the backup file (.bak)
From the Screen:
Specify the source and location of backup sets to restore:
I click on the radio button...
March 25, 2009 at 4:24 pm
thanks a lot DAN
February 27, 2009 at 7:12 am
Let me ask this - what is WebOALineItems? Is that a table or a view? - TABLE Is that column a calculation or a "true" column? - TRUE...
February 5, 2009 at 1:11 pm
Thanks again Roy but I am getting the same error.
when i run your query. The management studio comes up with an error.
Column or expression 'linPartNum' cannot be updated.
and also adds...
February 5, 2009 at 11:39 am
yes sql server 2005 management studio
February 5, 2009 at 11:32 am
yes that's what I am using. SQL Server 2005 Management studio
February 5, 2009 at 11:27 am
Actually when I tried it.
UPDATE WLI
SET WLI.linPartNum = replace(WLI.linPartNum, 'ST', 'PL')
FROM ...
February 5, 2009 at 11:16 am
Thanks a lot ROY. You guys were a great help.
February 5, 2009 at 11:01 am
Thanks Roy.
The tables weboalineitems and weboaheader have an inner join on webOaLineItems.linHeaId = webOaHeader.heaId
The column I want to update is in webOaLineItems table and the column name is linPartNum
February 5, 2009 at 10:34 am
Thanks Matt. now I understood it.
March 24, 2008 at 1:22 pm
Viewing 15 posts - 1 through 15 (of 16 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy