[SQL Server 2008 issues] Where is Left table in Left Join ??? |
- Where is Left table in Left Join ???
- Data Masking
- ?? on xp_cmdshell not writing to file
- Transactional replication fails with no meaningful error message
- Need help with query
| Where is Left table in Left Join ??? Posted: 22 Jun 2013 05:45 PM PDT Hi all, I did my home work but just want to confirm where is that Left table on Left SQL :a. Very Firs mentioned in Selectb. on the Left side of equation in ON statement.Is this the same:Select T1.C1, T2.C2 From T1 Left join T2 on T1.C1 =. T2.C2vs.Select T1.C1, T2.C2 From T1 Left join T2 on T2.C2 = T1.C1. ------ note t2 first hereWhat if I do lef5 join on tables which are not on main select? In this case order could be determined from "=" line ?TxMario |
| Posted: 23 Mar 2011 08:28 PM PDT Dear All,I want to mask the data in development server and same need to get back in to production server. how can i done ?please help me. |
| ?? on xp_cmdshell not writing to file Posted: 13 Jun 2013 11:40 PM PDT Hi,Below will not write to file. I did a similar test on a more basic query and it worked.I'm assuming it's the " somewhere, but can't find it..any ideas would be appreciated...ThanksJoedeclare @sql varchar(8000)set @sql='bcp"select CAD19 as ContractNumber, CAD65 as ClientID, client.LName + ", " + CLIENT.FName as Name, convert(varchar, client.BDate, 101)as DOB, CAD300 as HSTSentDate, CAD302 as MemberStartDate, CAD18 as IntakeNotCompletedID, CAD301 as IntakeNotEnrDate, CAD754 as IntakeOtherReason FroM test.dbo.USER_DEFINED_DATA INNER JOIN test.dbo.ASSESSMENT ON test.dbo.USER_DEFINED_DATA.ASSESSMENT_MONIKER = test.dbo.ASSESSMENT.OID INNER JOIN test.dbo.Client ON test.dbo.USER_DEFINED_DATA.ATTACHED_TO_OID = test.dbo.Client.OIDWHERE (test.dbo.ASSESSMENT.Code = "CH1") AND (test.dbo.USER_DEFINED_DATA.CAD750 = "Final") AND (test.dbo.USER_DEFINED_DATA.Expdate IS NULL) and CAD700 = "Processed" FOR XML PATH("REFERRAL"), root("CLUB"),type" queryout "c:\temp\' + REPLACE(CONVERT(VARCHAR,GETDATE(),101),'/','')+'Clubhouse.xml' + '" -c -T -SUCDB01 -Usa -Ppas'exec master..xp_cmdshell @sql |
| Transactional replication fails with no meaningful error message Posted: 20 Jun 2013 11:58 AM PDT Hi,I am trying to setup replication between two clustered instances belonging to the same 3 node cluster. The distributor is a separate instance from publisher and subscriber.When I re-initialise a publication I get this error message:The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed.Neither job history nor SQL Server logs provide any other meaningful messages.When I try to run the snapshot from command prompt it just works fine:"C:\Program Files\Microsoft SQL Server\100\COM\SNAPSHOT.EXE" -Publisher [sqlcluster1\publisher] -PublisherDB [MyDB] -Distributor [sqlcluster2\distributor] -Publication [MyPublication] -DistributorSecurityMode 1 Log reader and distributor agent fail with the same generic message.SQL Server agent account is a local admin on each cluster node and a member of sysadmin role on each instance.I am running SQL Server 2008R2 SP2.Any ideas?Thanks. |
| Posted: 22 Jun 2013 12:09 AM PDT Please help, I've been searching for days but could not find any useful info. to resolve the below query.[img]http://i42.tinypic.com/9ibklh.jpg[/img][img]http://i41.tinypic.com/30iu6u9.jpg[/img] |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment