Viewing 15 posts - 10,981 through 10,995 (of 15,381 total)
There are several ways to do this but I prefer to use INTERSECT/EXCEPT for this type of thing.
August 21, 2012 at 11:14 am
a_ud (8/21/2012)
August 21, 2012 at 10:39 am
newbieuser (8/21/2012)
I need to create a stored procedure to refresh a few fields from an Oracle table(via linked server)..The application would run the procedure whenever the table has...
August 21, 2012 at 10:20 am
a_ud (8/21/2012)
Basically it takes a number 'ID'...
August 21, 2012 at 10:16 am
Not really sure what your question is but you can read about substring here. http://msdn.microsoft.com/en-us/library/ms187748.aspx
What are the business rules for this? This looks pretty strange.
August 21, 2012 at 7:49 am
rahul_yerramareddy (8/20/2012)
In my project there are two servers local and central. My central server is in Network1 and local server are in any network(like Network1,Network2 etc). I wrote a procedure...
August 21, 2012 at 7:39 am
KEVHOUSTON740 (8/20/2012)
Yes, just as you wrote it.<HappyDANCE>
Dance_Jig()
</HappyDANCE>
LOL 😀 Glad that worked for you.
August 21, 2012 at 7:05 am
KEVHOUSTON740 (8/20/2012)
August 20, 2012 at 3:07 pm
KEVHOUSTON740 (8/20/2012)
August 20, 2012 at 2:45 pm
This seems to be the same thing as your loop.
ALTER PROCEDURE [dbo].[uspNHistory]
-- Add the parameters for the stored procedure here
@NH_ID INT
,@N_ID INT
AS
DECLARE @CNID INT
,@CID INT
,@CA NVARCHAR(50)
BEGIN
-- SET NOCOUNT ON added...
August 20, 2012 at 2:33 pm
KEVHOUSTON740 (8/20/2012)
August 20, 2012 at 2:27 pm
Sean Lange (8/20/2012)
ben cohen (8/20/2012)
Is this a SQL Server 2008 bug? It parses fine. Note that the [] are unbalanced.CREATE TABLE [dbo].[abc](
[a] [int] NULL,
[transaction[0]].status] [nchar](10) NULL
)
What do you mean they...
August 20, 2012 at 2:14 pm
ben cohen (8/20/2012)
Is this a SQL Server 2008 bug? It parses fine. Note that the [] are unbalanced.CREATE TABLE [dbo].[abc](
[a] [int] NULL,
[transaction[0]].status] [nchar](10) NULL
)
What do you mean they are unbalanced?...
August 20, 2012 at 2:13 pm
Rainmaker097 (8/20/2012)
Output to file or text doesn't work. But I will dig some more. Thanks a lot for explaining this to me. Much appreciated.
What do you mean it doesn't work?...
August 20, 2012 at 2:09 pm
SQLKnowItAll (8/20/2012)
Rainmaker097 (8/20/2012)
But is there any way I can...
August 20, 2012 at 2:00 pm
Viewing 15 posts - 10,981 through 10,995 (of 15,381 total)