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)