|
'Invalid object name' for temp table when executing a SP I am getting the message 'Invalid object name' when I am attempting to execute a stored procedure in which there is a temporary table. The message reads: "There is an error in the query. Invalid object name '#UsersEntities'." I do not receive this error when I execute the stored procedure from the query win... 7 Jul 2008 03:17
Need help! Hi All I have a table, Orders table, that has a values for its comments field like e.g 01/02/01: My text with a leading space 01/02/01:My text with no leading space. I want to write a sql statement, that gets rid of the space after the :, so that it would look something like this, because I need only ... 7 Jul 2008 00:14
How to construct check constraint to allow only one 'True' flag per vendor Eric, You can avoid the assumption on VendorToAddressID in one of the following ways, each of which allows VendorUseForMailing_UNIQUE to equal VendorToAddressID for non-mailing addresses by using a value not in the key domain (INT NOT NULL) in the mailing address case. One possibility is to take advantage of ... 6 Jul 2008 20:09
How to execute SP that returns a select set from another SP John Bell wrote: Just to complicate things further how about a function? CREATE FUNCTION AddParams ( @x float, @y float ) RETURNS FLOAT BEGIN RETURN @x + @y END DECLARE @x float, @y float, @z float SELECT @x =1.234, @y =2.123 SET @z = dbo.AddParams ( @x, @y ) SELECT... 6 Jul 2008 16:03
from a stored procedure: how to return datasets and their table names Consider a simple stored procedure that returns multiple result sets: CREATE PROCEDURE MyProcedure @Params ... AS BEGIN ... SELECT columns ... FROM ... ... SELECT columns ... FROM ... END Is there any way to identify each of these result sets with a na... 6 Jul 2008 16:03
mysql file format please help me understand mysql file format or or any related links would also be very helpful ... 6 Jul 2008 16:03
arbeit deutschland stellenangebot mannheim jobangebote spanien Kaufmann Groß- und Außenhandel arbeit deutschland stellenangebot mannheim jobangebote spanien Kaufmann Groß- und Außenhandel + + + ARBEITSANGEBOTE IN DEUTSCHLAND http://WWW.ARBEITSANGEBOT-DEUTSCHLAND.DE http://WWW.ARBEITSANGEBOT-DEUTSCHLAND.DE + + + STELLENANGEBOTE IN DEUTSCHLAND http://WWW.STELLENANGEBOT-DEUTSCHLAND.DE http:/... 6 Jul 2008 09:55
How to construct check constraint to allow only one 'True' flag per vendor Consider following table: CREATE TABLE Vendor_To-Address ( Vendor_To-Address_ID INT, Vendor_ID INT, Address_ID INT, AddressType_ID INT, UseForMailing BIT, UseForPO BIT, UseForChecks BIT ) How do I make a check constraint to allow many of these records for each vendor but make sure o... 6 Jul 2008 19:07
Date Questions Basically, I am trying to get invoices in a specific finacial year. See below. So, if I start with 2008 I will get 2008/2009 between 6th April 2008, and 5th April 2009. declare @targetDate as int; set @targetDate = 2008; select * from Invoice Where InvoiceDate Between cast(cast(@targetDate As nchar) + '... 6 Jul 2008 15:02
THANKS!! select statement - multiple values returned Thanks Plamen!! With your help I've been able to get this to work; and I've learnt a lot too from your postings/comments!! Thank YOU!! "Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message news:FE1FBD08-849A-4E0C-A3BC-7D704BB3ECCC(a)microsoft.com... You changed the requirements. Your initial post had a sin... 5 Jul 2008 13:33
CONMON Database please Where can I download CONMOM database which was used in C# 2005 Appdev video tutorial. Please help Thanks ... 5 Jul 2008 12:31
SELECT * FROM @Table not using Dynamic SQL (if exists) I have asked in some question before about use a select by choosing table you want, this is like: DECLARE @Table VARCHAR(20) SELECT @Table = "tblSome" SELECT * FROM @Table But NOT using Dynamic SQL (if exists) Please, answer me if you have some way or theory to do so. Beforehand, thank you very much. ... 5 Jul 2008 19:40
How can I run big SQL files? Hi, I have a big sql file and I need to run it in management studio. The file size is 248Mb. When I open the file and run it, I receive the following error: Cannot execute script. Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib) What is the easiest way to run such script and track/se... 4 Jul 2008 18:12
Producing data from querying three tables Hi all, I'm trying to run a query that produces data from three tables, in essence these are Location, Category and BannerPeriod, They all have a secondary key of SiteID and are linked by this, really there are two stages to this query, Stage 1 produce a complete combination of all categories and locations wh... 5 Jul 2008 17:38 |