Relability? [part 2, 0xC0202093 Error]
Feb 1, 2007
In my previous thread, we established that my system does not have SP1 applied. Apparently packaging of SQL Server SP1 is not so easy and while SQL Engine was updated SSIS is still in RTM.
Anyway, after months(!) of running we hit following:
An error occurred while initializing the flat file parser.
The PrimeOutput method on component "Flat File Source" (27679) returned error code 0xC0202093. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Thread "SourceThread0" has exited with error code 0xC0047038.
Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Thread "WorkThread0" has exited with error code 0xC0047039.
I could not find anything regarding 0xC0202093, but re-starting SQL & IS services cured the problem. I am putting it here, so others learn from our experience. Probably re-starting IS engine would be enough.
Someone may say that re-starting of the service is a piece of cake. In the developers enviroment - it is. In the enterprise production system, where corporate rules are applied - it is a nightmare: it has to be approved, it has to be documented ("Can you prove that re-starting will cure the problem?") and it has to be done by a DBA - and that together cost real money.
View 2 Replies
ADVERTISEMENT
Oct 29, 2007
I have SSRS 2005 SP2 configured to work in Sharepoint integration. Everything works fine except that I am not able to programmatically change any property of report viewer web part (instance) that I have added on on home page of my sharepoint site.
I can do same thing via sharepoint UI but not through program. When my programs runs it fetches all web parts been added on home page, then I need to iterate through each one and find report viewer web part.
While iterating, as soon as I arrive to report viewer web part it is named as "Error web part" with error message as
"Windows SharePoint Services cannot deserialize the Web Part. Check the format of the properties and try again"
If someone has a solution, please respond at your earlist.
Thanks
Shankar
View 1 Replies
View Related
Feb 2, 2007
Hello again,
It seems that we are pushing IS to the limits :). And again - still SSIS engine version RTM, so my comment may have been addressed in SP1 or HF1. A package is executed by SQL Agent once every day. Once in a fortnight it stalls - goes to the zombie mode. The status of the package in the SQL Agent monitor is "Executing", while log file reports nothing.
Now, I believe it is caused by sorting component in the data flow task. I have three reasons for doing so: the log file shows that data sources were read; I think I have seen it once in MS Studio and finally - previous version of the package without sorting worked fine for several months.
In our case, we used sorting for merging datasets - we decided to use staging (temporary) tables and lookups to the same task. Going live today, so hopefully it will be a valid work around.
View 2 Replies
View Related
Dec 7, 2007
I have a table with a column named measurement decimal(18,1). If the value is 2.0, I want the stored proc to return 2 but if the value is 2.5 I want the stored proc to return 2.5. So if the value after the decimal point is 0, I only want the stored proc to return the integer portion. Is there a sql function that I can use to determine what the fraction part of the decimal value is? In c#, I can use
dr["measurement "].ToString().Split(".".ToCharArray())[1] to see what the value after the decimal is.
View 3 Replies
View Related
Jan 28, 2015
I have made the following Scalar-valued function:
CREATE FUNCTION [dbo].[TimeCalc]
(
@OriginalTime AS INTEGER
, @TenthsOrHundredths AS INTEGER -- code 2: 1/10, code 4: 1/100
)
RETURNS NVARCHAR(8)
[Code] ....
What it does is convert numbers to times
E.g.: 81230 gets divided by 10 (times in seconds: 8123). This 1 1 full minute, and the remainder = 2123 making it 1.21.23 mins)
So far so good (function works perfectly)
My question: sometimes times are in 1/100 (like above sample), sometimes in 1/10.
This means that, e.g. with a time like 3.23.40 the last zero must be deleted.
My thoughts are to use the results from the Return Case part, and as the code = 4: leave it as it is,
is the code 2 the use LEFT(... result Return Case ..., Len(..result Return Case.. - 1))
There are 5 codes: 0 1 2 3 and 4
View 9 Replies
View Related
Sep 7, 2007
Hi,
I have the following statement with multi-part identifier error :-
SELECT #t.vno,transact.vdesc,transact.acctno,transact.camt,transact.damt,transact.ccamt,transact.cdamt
into #main
FROM transact,(
SELECT VNO,VTYPE,TDATE,SUM(CAMT) AS SCAMT,SUM(DAMT) AS SDAMT
FROM TRANSACT
WHERE YEAR = 2007 and batchno = 5
GROUP BY VNO,VTYPE,TDATE
having sum(camt) <> sum(damt)
)as #t
WHERE (transact.YEAR = 2007)
thanks
View 4 Replies
View Related
May 16, 2008
Hi i am finding difficulty in adding updating the Last transaction Date of Materials Loaded Out.
The Master table has LoadID, LastLoadDate.
Child Table has MaterialID, LoadID, Weight1, Weight1DateTime, Weight2, Weight2DateTime
My Requirement is to update the Master.LastLoadDate field with the Highest date of the materials loaded out on different days.
I wrote the following query and it is getting me
" The multi-part identifier "#tblTemp.Mydate" could not be bound "
update table Tbl_LoadMaster set LastTransDate=(Select MAX(#tblTemp1.Mydate) as MaxDate from (
Select * from(
select Distinct Weight1DateTime as MyDate from Tbl_LoadMaterialDetails where LoadID=1 Union
select Distinct Weight2DateTime as MyDate from Tbl_LoadMaterialDetails where LoadInID=1
) #tblTemp1) #TblTemp2)
Please help me o find a solution for this situation. I am in a real hurry.
Thanks in Advance
Vineesh
View 3 Replies
View Related
Jan 26, 2007
I am trying to integrate reports that I have built with VS 2005 and deployed to my report server locally.
The path to the report is
http://SERVERNAME/Reports/Pages/Report.aspx?ItemPath=%2fBilling+System+Reports%2fBasic+Financial+Reports%2fBasic+Financial+Statistics+-+TimeKeeper+YTD
When I put that into the "Report" parameter the web part display an error:
The report server has encountered a configuration error. See the report server log files for more information
And when I click on the ellipses, I get a pop up with the same error.
I installed SQL2005 SP2 and the RS Add on for MS sharepoint CTP
Any help would be great!
Thanks,
Erik
View 2 Replies
View Related
Nov 25, 2007
I have created the following temp table.
--DROP TABLE #temp_Table
--select 0 as Populated, c.Table_name, Column_name, Ordinal_position, Value, Data_type, Character_maximum_length
-- INTO #temp_Table
-- from
--(SELECT 'lists' AS 'TABLE_NAME', *
-- FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'Lists', 'column', default))c
--INNER JOIN
-- (SELECT * FROM INFORMATION_SCHEMA.columns)d
-- ON c.objname = d.column_name COLLATE Latin1_General_CI_AI
-- AND c.TABLE_NAME = d.TABLE_NAME
--ORDER BY d.Ordinal_Position
--select * from #Temp_Table
The temp table above #Temp_Table has these 2 columns among others.
Table_Name, Column_name
Lists.......ListID
Lists.......ItemName
Lists.......ItemAbbreviation
Lists.......ItemDescription
From the table named in the Table_Name column I want to populate a new column named "Populated" with the count of rows based on this select:
SELECT COUNT(*) FROM Lists WHERE Len(Notes)<> 0
So that I will end up with:
Table_Name ...Column_name ........Populated
Lists...............ListID......................22
Lists...............ItemName...............10
Lists...............ItemAbbreviation......20
Lists...............ItemDescription.......5
My attempt at writing this select is as follows.
select *, populated from #Temp_Table #t
--loop through table for getting count of all columns.
WHILE #t.Ordinal_position IS NOT NULL
begin
Update #t
set populated = (SELECT COUNT(*) FROM Lists WHERE Len(Notes)<> 0)
end
And get this error
Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "#t.Ordinal_position" could not be bound.
How do i correct this?
View 1 Replies
View Related
Mar 24, 2008
I am trying to run a Common Table Expression (CTE) in SQL Server 2005 but I receive the error
'Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "ep.ProjectUID" could not be bound'.
What does this error mean?
My SQL is:
Code Snippet
WITH Tasks (TaskParentUID, TaskUID, ProjectName, TaskName, Level)
AS
(
SELECT et.TaskParentUID, TaskUID, ProjectName, TaskName,
0 AS Level
FROM dbo.MSP_EpmProject as ep
INNER JOIN dbo.MSP_EpmTask as et
ON ep.ProjectUID = et.ProjectUID
WHERE et.TaskParentUID = et.TaskUID
UNION ALL
SELECT et.TaskParentUID, et.TaskUID, ep.ProjectName, et.TaskName,
Level + 1
FROM dbo.MSP_EpmProject as ep
INNER JOIN dbo.MSP_EpmTask as et
ON ep.ProjectUID = et.ProjectUID
INNER JOIN Tasks AS t
ON et.TaskParentUID = t.TaskUID
)
SELECT t.TaskParentUID, t.TaskUID, ProjectName, t.TaskName, Level
FROM Tasks as t
INNER JOIN dbo.MSP_EpmTask as et
ON Tasks.TaskParentUID = et.TaskParentUID
WHERE Level = 0
The TaskParentUID has data-type of UniqueIdentifier and it's child is TaskUID which is also a UniqueIdentifier type. My goal of this CTE is to list all child TaskUIDs for each TaskParentUID in a recursive fashion.
View 7 Replies
View Related
Mar 15, 2008
this error messages appear when i execute this trigger
please help me
i make my graduation project
CREATE TRIGGER Insert_Contribution
ON Contributions
AFTER INSERT
AS
BEGIN
declare @error1 int,@error2 inT
BEGIN TRANSACTION
if(select Cash_OR_Account from Services,Contributions
where Services.S_ID=Inserted.S_ID)='A'
BEGIN
UPDATE Regular_Customers
SET Balance=Balance-inserted.amount
WHERE Services.Account_NO=Regular_Customers.Account_NO
AND Services.S_ID=Inserted.S_ID
SET @error1=@@ERROR
END
UPDATE Regular_Customers
SET Balance=Balance+inserted.amount
WHERE inserted.Account_NO=Regular_Customers.Account_NO
SET @error2=@@ERROR
IF @error1=0 AND @error2=0
BEGIN
COMMIT TRANSACTION
PRINT'Transaction Completed successfully'
END
ELSE
ROLLBACK TRANSACTION
SET NOCOUNT ON;
-- Insert statements for trigger here
END
GO
message
Msg 4104, Level 16, State 1, Procedure Insert_Contribution, Line 13
The multi-part identifier "Inserted.S_ID" could not be bound.
Msg 4104, Level 16, State 1, Procedure Insert_Contribution, Line 16
The multi-part identifier "Services.Account_NO" could not be bound.
Msg 4104, Level 16, State 1, Procedure Insert_Contribution, Line 16
The multi-part identifier "Services.S_ID" could not be bound.
Msg 4104, Level 16, State 1, Procedure Insert_Contribution, Line 16
The multi-part identifier "Inserted.S_ID" could not be bound.
View 2 Replies
View Related
Mar 11, 2008
Hi,We moved our stored procedure from sql 2000 to sql 2005 and we're getting few weird errors:Msg 4104. multi-part identifier /table.column/ could not be bound.Do we have to change anything in the stored procedure in order to make it work for sql 2005? Errors point to lines 25 and 68:25: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GC_Contacts_Table]') AND type in (N'U'))68: ELSEBelow is the code. Thanks in advance.set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[sp_refresh_GC_Contacts]ASDECLARE@dropSQL varchar(2000)BEGINSET NOCOUNT ON;--SET IDENTITY_INSERT GC_Contacts_Table ON-- drop the fulltext indexIF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[GC_Contacts]') AND name = N'pk_gc_contacts')DROP FULLTEXT INDEX ON [dbo].[GC_Contacts] -- drop the unique indexIF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[GC_Contacts]') AND name = N'pk_gc_contacts')DROP INDEX [pk_gc_contacts] ON [dbo].[GC_Contacts] WITH ( ONLINE = OFF )-- If table exists truncate itIF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GC_Contacts_Table]') AND type in (N'U'))BEGIN TRUNCATE TABLE [dbo].[GC_Contacts_Table]INSERT INTO [dbo].[GC_Contacts_Table] --insert sql next lineSELECT Title, FirstName AS First_Name, MiddleName AS Middle_Name, LastName AS Last_Name,Suffix, Company, JobTitle AS Job_Title, Email, PrimaryPhoneNumber AS Primary_Phone_Number, PrimaryAddress1 AS Primary_Address_1, PrimaryAddress2 AS Primary_Address_2, PrimaryAddress3 AS Primary_Address_3, PrimaryCity AS Primary_City, PrimaryState AS Primary_State,PrimaryZip AS Primary_Zip, PrimaryCountry AS CPrimary_ountry, Notes, Alias, FullName AS Full_Name,dbo.Addresses.Type AS AddressType, dbo.Addresses.Address1 AS Address1,dbo.Addresses.Address2 AS Address2,dbo.Addresses.Address3 AS Address3, dbo.Addresses.City AS City, dbo.Addresses.State AS State,dbo.Addresses.Zip as Zipcode, dbo.Addresses.Country AS Country, dbo.Addresses.PhoneNumber AS PhoneNumber,dbo.Addresses.FaxNumber AS FaxNumber, SubAward_Only = CASE SubAwardOnlyWHEN 0 THEN 'No'WHEN 1 THEN 'Yes'END,dbo.ContactsSTUDF.*-- IDENTITY(int, 1,1) AS GC_Contact_ID-- INTO dbo.GC_Contacts_TableFROM dbo.Contacts LEFT OUTER JOIN dbo.ContactAddresses ON dboContacts.ID = dboContactAddresses.ContactIDLEFT OUTER JOIN dbo.Addresses ON dbo.Addresses.ID = dboContactAddresses.AddressIDLEFT OUTER JOIN dbo.ContactsSTUDF ON dbo.Contacts.ID = dbo.ContactsSTUDF.EntityIDENDELSE BEGIN-- create the table from the querySELECT Title, FirstName AS First_Name, MiddleName AS Middle_Name, LastName AS Last_Name, Suffix, Company,JobTitle AS Job_Title, Email, PrimaryPhoneNumber AS Primary_Phone_Number, PrimaryAddress1 AS Primary_Address_1, PrimaryAddress2 AS Primary_Address_2, PrimaryAddress3 AS Primary_Address_3, PrimaryCity AS Primary_City, PrimaryState AS Primary_State, PrimaryZip AS Primary_Zip, PrimaryCountry AS CPrimary_ountry, Notes, Alias, FullName AS Full_Name,dbo.Addresses.Type AS AddressType, dbo.Addresses.Address2 AS Address2,dbo.Addresses.Address3 AS Address3, dbo.Addresses.City AS City, dbo.Addresses.State AS State,dbo.Addresses.Zip as Zipcode, dbo.Addresses.Country AS Country, dbo.Addresses.PhoneNumber AS PhoneNumber,dbo.Addresses.FaxNumber AS FaxNumber, SubAward_Only = CASE SubAwardOnlyWHEN 0 THEN 'No'WHEN 1 THEN 'Yes'END,dbo.ContactsSTUDF.*,IDENTITY(int, 1,1) AS GC_Contact_IDINTO dbo.GC_Contacts_TableFROM dbo.Contacts LEFT OUTER JOIN dbo.ContactAddresses ON dboContacts.ID = dboContactAddresses.ContactIDLEFT OUTER JOIN dbo.Addresses ON dbo.Addresses.ID = dboContactAddresses.AddressIDLEFT OUTER JOIN dbo.ContactsSTUDF ON dbo.Contacts.ID = dbo.ContactsSTUDF.EntityIDEND SET IDENTITY_INSERT GC_Contacts_table OFFSET ARITHABORT ONSET CONCAT_NULL_YIELDS_NULL ONSET QUOTED_IDENTIFIER ONSET ANSI_NULLS ONSET ANSI_PADDING ONSET ANSI_WARNINGS ONSET NUMERIC_ROUNDABORT OFF/****** Object: Index [pk_gc_contacts] Script Date: 10/11/2007 15:34:28 ******/CREATE UNIQUE CLUSTERED INDEX [pk_gc_contacts] ON [dbo].[GC_Contacts] ([GC_contact_id] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]-- add the fulltext indexCREATE FULLTEXT INDEX ON GC_Contacts([Title],[First_Name],[Middle_Name],[Last_Name],[Suffix],[Company],[Job_Title],[Email],[Primary_Phone_Number],[Primary_Address_1],[Primary_Address_2],[Primary_Address_3],[Primary_City],[Primary_State],[CPrimary_ountry],[Notes],[Alias],[Full_Name],[AddressType],[Address1],[Address2],[Address3],[City],[State],[Country],[PhoneNumber],[FaxNumber],[SubAward_Only])KEY INDEX pk_gc_contacts ON GCInquiryCatalogWITH CHANGE_TRACKING AUTOEND
View 3 Replies
View Related
Nov 12, 2006
I am new to SQL 2005. I have setup and new maintanaince plan of making backup on to different paths but i encountered an error saying
Executing the query "BACKUP DATABASE [promis_05] TO DISK = N'E:\ERP Database\ERP Backup\Promis_05', DISK = N'\\backupsrv\ERP Backup\Promis_05' WITH NOFORMAT, INIT, NAME = N'promis_05_backup_20061111181236', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "The volume on device 'E:\ERP Database\ERP Backup\Promis_05' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
We did not know what to make of this.
1) Is it bcoz i am backing up the database on 2 locations same time.
2) What is BACKUP WITH FORMAT?
3) Why won't it let me add a new file that is not part of the 'family' ?
4) How does it get to be part of the family?
Thought and ideas are highly appreciated!
View 3 Replies
View Related
Feb 20, 2007
HI,
I have downloaded and was trying to install the Reporting Services Sharepoint web part. As mentioned in the installation instructions I have uninstalled the previous version and then started the install. After starting to install the installation Rolls back and fails.
I have checked the logs and i get the error
The web configration file, C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12configwebconfig.dlc.xml, does not have element "configuration/configSections/sectionGroup[@name='SharePoint']" or it is invalid.
Install error: C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12instsadm.exe return error code: -1
Any suggestions/ help to resolve the problem would be most welcome.
Thanks in advance
PMN
View 1 Replies
View Related
Jul 22, 2014
I'm writing a query where I have multiple left-outer joins but I keep getting multi-part identifier error. See the query below?
SELECT gl.seg5 Natural
,gl.seg2 Office
,gl.seg3 Dept
,gl.seg4 Team
,gl.seg6 Sub
,gl.seg7 Tkpr
,gl.seg1 Comp
,'CHK' Source
[Code] ....
Errors
Msg 4104, Level 16, State 1, Line 68
The multi-part identifier "csddt.baid" could not be bound.
Msg 4104, Level 16, State 1, Line 68
The multi-part identifier "csddt.cknum" could not be bound.
Msg 4104, Level 16, State 1, Line 68
The multi-part identifier "csddt.ckline" could not be bound.
View 5 Replies
View Related
Jan 17, 2007
Im trying to execute following update SQL:
UPDATE Property SET ImageList = U.ImageList
FROM Property M
INNER JOIN RETS.dbo._Updates U ON M.ListingID = U.ListingID AND M.FeedID
= U.FeedID
WHERE M.FeedID = ?
But following error:
[Execute SQL Task] Error: Executing the query " UPDATE Property SET
ImageList = U.ImageList FROM Property
M INNER JOIN RETS.dbo._Updates U ON M.ListingID = U.ListingID
AND M.FeedID = U.FeedID WHERE M.FeedID = ?" failed with
the following error: "The multi-part identifier "M.FeedID" could
not be bound.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly,
or connection not established correctly.
ByPassPrepare is set to TRUE and ParameterName = 0 to variable User::Feed_ID
HOWEVER - following query executes fine:
UPDATE Property SET
ImageList = U.ImageList
FROM Property M
INNER JOIN RETS.dbo._Updates U ON M.ListingID = U.ListingID AND M.FeedID
= U.FeedID
WHERE M.FeedID = 11
Beats me - any help with explaining this to me
please?
View 7 Replies
View Related
Jun 2, 2006
I was trying to copy child records of one parent record into another, and wanted to report back new child record id and corresponding child record id that was used to create it. I ran into run-time error with OUTPUT clause. Following is a script that will duplicate the situation I ran into:
CREATE TABLE Parent(
ParentID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
ParentName VARCHAR(50) NOT NULL)
GO
CREATE TABLE Child(
ChildID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
ParentID INT NOT NULL REFERENCES Parent(ParentID),
ChildName VARCHAR(50) NOT NULL)
GO
INSERT INTO Parent(ParentName) VALUES('Parent 1')
INSERT INTO Parent(ParentName) VALUES('Parent 2')
GO
INSERT INTO Child(ParentID, ChildName) VALUES(1, 'Child 1')
INSERT INTO Child(ParentID, ChildName) VALUES(1, 'Child 2')
GO
At this stage, there Child table looks like:
ChildID
ParentID
ChildName
1
1
Child 1
2
1
Child 2
What I want to do is copy Parent 1€™s children to Parent 2, and report back which source ChildID that was used to create the new child records. So I wrote the query:
DECLARE @LinkTable TABLE (FromChildID INT, ToChildID INT)
INSERT INTO Child(ParentID, ChildName)
OUTPUT c.ChildID, inserted.ChildID INTO @LinkTable
SELECT 2, c.ChildName
FROM Child c
WHERE c.ParentID = 1
SELECT * FROM @LinkTable
In the end I was expecting Child table to look like:
ChildID
ParentID
ChildName
1
1
Child 1
2
1
Child 2
3
2
Child 1
4
2
Child 2
and OUTPUT clause to return me:
FromChildID
ToChildID
1
3
Child record with ID 3 was created using ID of 1.
2
4
Child record with ID 4 was created using ID of 2.
But infact I€™m getting following error:
Msg 4104, Level 16, State 1, Line 9
The multi-part identifier "c.ChildID" could not be bound.
Any ideas on how to fix the OUTPUT clause in the query to return me the expected output?
Thanks
Yogesh
View 7 Replies
View Related
Sep 7, 2006
Hi chaps,
I have the following SQL query (SQL 2005).
Its basically retrieving some values using simple joins.
However there appears to be a problem with the LEFT OUTER JOIN:
"LEFT OUTER JOIN DDDispatchedOrder ON (OrderLineItemTransaction.OrderLineItemTransaction ID = DDDispatchedOrder.OrderItemTransactionID)
"
When I try to compile the code i Get :
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "OrderLineItemTransaction.OrderLineItemTransactionI D" could not be bound.
Any help would be appreciated.
Cheers
Bal
SELECT
ord.orderDate,
cc.forename + ' ' + cc.surname person,
prod.description,
oli.noofitems,
deladdr.housenameno + ' ' + deladdr.addressLine1 + ' ' + deladdr.addressLine2 + ' ' + deladdr.city + ' ' + deladdr.postcode + ' ' + deladdr.county + ' ' + deladdr.country deladdress
FROM
product prod,
OrderLineItem oli,
[Order] ord,
OrderTransaction ordT,
OrderLineItemTransaction oliT,
CustomerContact cc,
Customer cust,
DDDispatchedOrder dd,
address deladdr,
address invaddr
LEFT OUTER JOIN DDDispatchedOrder ON (OrderLineItemTransaction.OrderLineItemTransaction ID = DDDispatchedOrder.OrderItemTransactionID)
WHERE
prod.productID = oli.productID:eek:
AND ord.orderID = oli.orderID
AND ord.orderID = ordT.orderID
AND oliT.orderlineitemID = oli.orderlineitemID
AND cc.customercontactID = ord.customercontactID
AND cc.customerID = cust.customerID
AND ord.invoiceaddressID = invaddr.addressID
AND ord.deliveryaddressID = deladdr.addressID
AND ordT.dispatchTypeID = 2
View 7 Replies
View Related
Jan 25, 2008
Hello,
I am passing the partameters to MS Report Viewer control to view the report. It is working fine with normal parameters like 'abc', 'Jon' etc.
But fails with parameters having special characters like 'abc+', 'Version 1.1 Part 1', 'R1.8 RC' throws error "
The parameter is missing a value"
Could anyone please help on this.
Thanks,
Chandroday
View 1 Replies
View Related
Mar 22, 2006
Hello,
we have automated build on every night. In our solution is SSIS project, where each package is encrypted per password. We call build process per command line like this..
C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (c:DevelopmentX3\X3.sln /build Release)' in 'c:DevelopmentProjectsDailyBuild
Through build process we get a error:
External Program Failed: C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (return code was 1):
We think a reason is, that on build of SSIS project must be entered a password. You can wonder for what we need that SSIS packages are part of our build. We hope that on build process is also created Deployment Utility, if so set in dtproject.user. Is it so? Is there any way to create Deployment utility on automated build process? Can be a password provided pre command line?
with best regards
Anton Kalcik
View 5 Replies
View Related
Apr 12, 2006
What different are there between connectionString (Part 1) and connectionString (Part 2) in web.config
The CCWW is my PC's name, normally I can connect to the database ASPNETDB.MDF correctly either Part 1 or Part 2 in a web page,After I open Database Explorer panel and browse ASPNETDB.MDF, I can't connect to database using Part 2 when I open a webpage in Microsoft Visual Web Developer 2005 Express Edition,but I can correctly open a webpage using Part 1 after I open Database Explorer panel.
What different are there between connectionString (Part 1) and connectionString (Part 2) in web.config?
I guess while I use Part 1 to connect, maybe it will be cancel exclusive method of the database ASPNETDB.MDF first, but when I connect to database using Part 2, maybe two programms both Part 2 and Database Explorer visit ASPNETDB.MDF at the same time!
--------------------------------------Part 1------------------------------------------------------------------------<add name="MyConnect" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|ASPNETDB.MDF" providerName="System.Data.SqlClient" /> --------------------------------------Part 1------------------------------------------------------------------------
--------------------------------------Part 2------------------------------------------------------------------------<add name="MyConnect" connectionString="Data Source=CCWWSQLEXPRESS;Initial Catalog=ASPNETDB.MDF;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|ASPNETDB.MDF" providerName="System.Data.SqlClient" />--------------------------------------Part 2------------------------------------------------------------------------
View 2 Replies
View Related
Jun 23, 2006
In a recent post, I've read that Jet Provider is only provided with 32-bit.
I wonder, is there any problem if you run a SSIS package 32-bit which read from Access and then call another SSIS package 64 bit?? We've got quite 2000 dts which pulling data from MDB and within a time it'll disappear in favour 2005 environment .
Another question, what sort of Providers don't offer us 64-bit versions???
Any link or thought will be as usual welcomed
View 4 Replies
View Related
Dec 7, 2006
Getting back way too many records with this on - over 4500 and should only be about 350.....
Here's the sql that's not working right:
SELECT c.Name, a.ID, a.Description, s.Status, b.Location, a.scheduleBegin, a.scheduleEnd
from tblEquipments a
inner join tblEquipments_Group U on u.categoryID = a.EquipmentType
inner join tblStatus S on a.status = S.statusID
and u.subCategoryID = @type
inner join tblLocation b on a.status = b.locationID
inner join tblSubCategories c on u.subCategoryID = @type
and c.Parent = @type
The table tblSubCategories has a field Name that I need.
tblSubCategories has a field, Parent, that will = @type
See this post for the other table fields if needed.
http://forums.asp.net/thread/1489880.aspx
If I omit the last inner join, all is ok, but I need that last bit of info - the c.Name.
Suggestions?
Thanks,
Zath
View 1 Replies
View Related
Jan 31, 2008
ok, following up on my previous post that I marked as answered a little premature. The query below works fine in sql studio:
SELECT id, CONVERT(NVARCHAR(10), arrdate,101) as formatedDate
FROM guest
but when I try to use it in a c# code behind file:
comm = new SqlCommand("SELECT id, CONVERT(NVARCHAR(10), arrdate,101) as formatedDate FROM guest WHERE id = @id", conn);
it bombs??
View 5 Replies
View Related
Mar 5, 2008
hi friends..... i want to get part of the database field value in stored procedure.. ex : select reason from reasontable where rid=1 output : reason-------------------------------telephone is not working properly. but i want the output as : reason--------------------------------telephone is n.............
View 3 Replies
View Related
Nov 17, 2000
Which database do you point it at when you're executing the script?
The Master database?
View 1 Replies
View Related
Aug 13, 2004
Hi all,
Is there a difference between the DBA and the SA or are they one in the same. I was reading a previous thead and came across that the SA is the powerful God almighty and the DBA is the just God.
Thanks
Lystra
View 3 Replies
View Related
Nov 25, 2004
Need help..
I need to select from a text field (lastname, firstname) the first part which is the last name. The format is exactly like the parenthesis. Any ideas?
Thanx
View 3 Replies
View Related
Jun 19, 2008
Thanks everyone for being helpful. I am new to SQL Server and don't have many coworkers so I am relying heavily on this forum's help.
It seems the previous poster on this issue was able to work it out but I am still not able to get it to work.
I have tried using the server URL, the server machine name, the ipaddress with alias, but still cannot connect with the replication over vpn. Any ideas?
Also, how can I set the subscriber from the server? How do I refer to the subscriber machine? Let's say it is my pc that I want to make changes in and have them replicate to the server? When I specify a pull subscription I am not show how to refer to my computer.
View 4 Replies
View Related
Jan 30, 2007
I have a tabkle that I want to use for NT authnetication. It was a list of domain lan usernames. I want to use NT authentication in ASP but in order to do so I need to add the domain to each of the lan ds. So my username, kssensalo needs to be DOMAINkssensalo. I need to do this for 5,000+ plus records. What SQL fucntion would I use? I know I can use LTRIM to remove, but I need to add or append.
Any suggesttions?
View 2 Replies
View Related
Sep 3, 2007
Hi,
i am trying to write a query the pulls out a table which has date information stored as dd/mm/yyy but all i want is the month and the year.
So i tried
select datepart(mm, dtinsertdate)
from incident
which only gives me month and also used
select datepart(year,dtinsertdate) [year], datepart(month, dtinsertdate)[month],
Which works but i want both in the same column.
But when trying to get both mm, yyyy it looks like it only supports one datepart. Is there any way aroung this?
Many Thanks
John
View 8 Replies
View Related
Feb 9, 2006
Hi allPlease read my previous post here if this interests you:http://groups.google.co.uk/group/co...pu+usage&hl=en&I have (or rather a colleague has) found the situation that appears tobe causing this problem but I am still no further to finding asolution.It appears that if we execute a query against one particular table inthe database and that query requests data that is not indexed, or acolumn in the where clause is not indexed then this is when problemsoccur.The table cannot be copied using DTS reporting the error:"Error occurred copying row 3 - unspecified error".However, we can query using:"SELECT TOP n FROM <Table>"where n so far has been between 3 and 100000.However we cannot do SELECT * FROM <Table>.All we can guess at for now is that the problem occurs when a query isperformed to try and fetch data that is not indexed, using an index inthe where clause.i.e. SELECT <Non-indexed column> FROM <Table> WHERE <Indexed Column> =nCould it be possible that we have one 'rogue' row in the table somehowthat is causing the problem?The only thing to dispel this is that we can do the following:SELECT * FROM <Table> WHERE ID < 1which returns 1 row with ID = -1.We cannot do:SELECT * FROM <Table> WHERE ID < 200 even though we know that the onlyrecord matching this criteria is the record with ID = -1.Therefore the exact same data should be returned yet one query failsand one works.The actual problem that we see is that memory usage climbsdramatically, then once all memory is used, the CPU usage climbs to100% and stays there until we have to restart SQL Server.Any suggestions on this would be hugely appreciated.Thanks,Paul
View 4 Replies
View Related
Oct 13, 2006
I think I'm having problems because I don't really understand "Windows Authentication".
I've looked on the web and haven't seen any real explinations.
As an example, If I have 3 computers
1.ServerBox (xp pro) with SQL express (using Workgroups not Domains)
2 Laptop1
3 Laptop2
ServerBox and Laptop1 connected with cat5 or Wirless..Works fine.
Laptop2 connected with wirless. I see laptop2 in the serverbox "Network Places-Workgroup" on the serverbox
Laptop 1 has xp pro and uses sql authentication for "instance, db, usernane and password". Logging in is no problem (I use SQL authentication in connection string)
Laptop 2 has xp home edition and dosn't have to log in. I have the machine name, default user with no password and try Windows authentication. Does not work. error show:
Cannot open database "db1" requested by the login. I use Windows authentication connection string.
I've tested both connection strings in Laptop1 and they both work.
Does Windows Authentication read the clients login to his Windows Home Edition, and if so, does in need a password (I know its a good idea)..
So Laptop2 login to his Windows Home edition is Username=Jim and no password (shows administrator rights in his box.
View 2 Replies
View Related
