Open the desktop, and then tap or click the Internet Explorer icon on the taskbar.
, and then tap or click Compatibility View settings.Under Add this website, enter the URL of the site you want to add to the list, and then tap or click Add.
declare
@bu varchar(300)set
@bu=',0100000011,0100000050,0100000051,0100000026,'create
table #tempmaintable( inpbu varchar(12))DECLARE
@Str NVARCHAR(MAX)SET
@Str = @buDECLARE
@Part NVARCHAR(MAX)DECLARE
@IND INTSET
@IND = CHARINDEX(',',@Str)DECLARE
@EIND INT set @EIND = 0WHILE
(@IND != LEN(@STR))BEGIN
SET @EIND = ISNULL(((CHARINDEX(',', @Str, @IND + 1)) - @IND - 1), 0) insert into #tempmaintable SELECT (SUBSTRING(@Str, (@IND + 1), @EIND)) SELECT @IND = ISNULL(CHARINDEX(',', @STR, @IND + 1), 0)END
select
* from #tempmaintable<asp:boundfield datafield="Your_Date_Column" dataformatstring="{0:MMMM d, yyyy}" htmlencode="false" />
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
solution
Error 53 sql server 2008 r2
To enable a server network protocol
1.
In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.
2.
In the console pane, click Protocols for <instance name>.
3.
In the details pane, right-click the protocol you want to change, and then click Enable or Disable.
4.
In the console pane, click SQL Server Services.
5.
In the details pane, right-click SQL Server (<instance name>), and then click Restart, to stop and restart the SQL Server service.
http://msdn.microsoft.com/en-us/library/ms191294.aspx
ActiveSheet.Cells(5, 4).Select
http://support.microsoft.com/kb/291308ActiveSheet.Range("D5").Select
Dim cnt As ADODB.Connection
Dim rst As ADODB.Recordset
Dim stSQL As String
Dim wbBook As Workbook
Dim wsSheet As Worksheet
Dim rnStart As Range
Const stADO As String = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=xxxxx;Data Source=devDB;User ID=myuser;Password=mypass; Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=myPC;Use Encryption for Data=False;Tag with column collation when possible=False"
Set wbBook = ActiveWorkbook
Set wsSheet = wbBook.Worksheets(5)
With wsSheet
Set rnStart = .Range("A7")
End With
'Report Name
Cells(1, 10).Value = "Interco Report"
stSQL = "SELECT top 100 * FROM tbl_intercoRep"
'stSQL = "SP_Int_DeleteThis"
' stSQL = "SP_IntercoReport"
Set cnt = New ADODB.Connection
With cnt
.CursorLocation = adUseClient
.Open stADO
.CommandTimeout = 0
Set rst = .Execute(stSQL)
End With
'Worksheets("sheet5").Activate
Dim ii As Integer
For ii = 0 To rst.Fields.Count - 1
Cells(6, ii + 1).Value = rst.Fields(ii).Name
Next ii
With Range("A1:ZZ1").Font
.Bold = True
.Size = 15
End With
With Range("A6:ZZ6").Font
.Bold = True
End With
'Here we add the Recordset to the sheet from A1
rnStart.CopyFromRecordset rst
'Cleaning up.
rst.Close
cnt.Close
Set rst = Nothing
Set cnt = Nothing
End Sub
-->
drop table #temp2
select yaan8,a.ABALPH ChildName, yaanpa,b.ABALPH ParentName into #temp2 from proddta.F060116
left outer join PRODDTA.F0101 a on yaan8=a.aban8
left outer join PRODDTA.F0101 b on yaanpa=b.aban8
where yapast in('1','0','6') order by 2
go
WITH Recursive_CTE AS (
SELECT
child.YAAN8,
CAST(child.ChildName as varchar(100)) ChildName,
child.yaanpa yaanpa,
CAST(NULL as varchar(100)) ParentUnit,
CAST('>> ' as varchar(100)) LVL,
CAST(child.YAAN8 as varchar(100)) Hierarchy,
1 AS RecursionLevel
FROM #temp2 child
WHERE YAAN8 = 123456
UNION ALL
SELECT
child.YAAN8,
CAST(LVL + child.ChildName as varchar(100)) AS ChildName,
child.yaanpa,
parent.ChildName ParentUnit,
CAST('>> ' + LVL as varchar(100)) AS LVL,
CAST(Hierarchy + ':' + CAST(child.YAAN8 as varchar(100)) as varchar(100)) Hierarchy,
RecursionLevel + 1 AS RecursionLevel
FROM Recursive_CTE parent
INNER JOIN #temp2 child ON child.yaanpa = parent.YAAN8
)
SELECT * FROM Recursive_CTE ORDER BY Hierarchy
Writing Word from Database
Best way to do this using Access Database, do following:-
1. Create a Table in access database and define all of the related data for mail merge.
2. Open this table and click on External Data Word Merge.
3. Word document will open, Select second option –> Create a new document and then link the data to it.
4. Type your letter and if you want to attach a field you can click at insert merge field and select your field.
5. After this you can check the preview.
6. Click at Finish & merge, once you done.
I think you can use excel by attaching it to access database.
