Tag: sql-server-2008-r2

SQL Server 2008 R2 SSMS Default Login Username

I recently created a few test accounts on my server and logged into them using SSMS. When I start SSMS, my default login is now one of the test accounts. How do I clear the login drop down list or reset my account as the default login username?

how to read the content of xml file in the remote(network) machine through mssql stored procedures

I tried to read the contents of single xml file in the local machine using bulk insert. SELECT * FROM OPENROWSET ( BULK ”’+ @FILENAME+”’ , SINGLE_CLOB ) AS xmlData It is working, but the same i am trying to read from the remote machine. its giving the following error Msg 4861, Level 16, State […]

How to tell T-SQL query not to escape the given string/query result

This is a sample query select * from tablename where tableid in (<sub query>); The <sub query> here returns null or a string of pattern ‘id1′,’id2′,’id3’ My <sub query> is something like: select xml_data.value(‘(/Node/SubNode)[1]’, ‘varchar(max)’)) from tablename where tableid = ‘9944169f-95a6-4570-89d7-b57a3fe1b693’ The problem : My sub query returns proper data (‘id1′,’id2′,’id3’) but the parent query […]

Is there any info about using MS SQL Server with MediaWiki?

I wonder if it possible to use mediawiki 1.18 with MS SQL server(particullary, MS SQL server 2008 r2), and, if possible, where to find some info about them working together. I know that mysql is much better solution, but our client insist on oracle DB or MS SQL. And i’d prefer MS SQL because i […]

TSQL – populate record from the next adjacent row

Current Output Activity FromTime ToTime ——————————————————————- STOPPED INSIDE POI 2012-11-14 01:08:46.000 2012-11-14 01:19:46.000 MOVING INSIDE POI 2012-11-14 01:20:46.000 2012-11-14 01:21:46.000 MOVING OUTSIDE POI 2012-11-14 01:22:46.000 2012-11-14 01:22:46.000 STOPPED OUTSIDE POI 2012-11-14 01:23:46.000 2012-11-14 01:23:46.000 MOVING OUTSIDE POI 2012-11-14 01:24:46.000 2012-11-14 01:25:46.000 Expected Output Activity FromTime ToTime ——————————————————————- STOPPED INSIDE POI 2012-11-14 01:08:46.000 2012-11-14 01:20:46.000 MOVING […]

Substring Time Formatting

Currently I am using this script to pull a time out of a column: (RIGHT(‘0’ + ltrim(RIGHT(convert(varchar,cast(SUBSTRING(A.DocSign, CHARINDEX(‘^’, A.DocSign) +1, 19) as datetime), 100), 7)), 7)) What this returns is a time formatted like this 10:34AM – It is also converting military time to standard time in this code, and appends it to additional items […]

How to execute query without displaying result?

I want to test performance of some queries by executing it multiple times in SQL Server Management Studio and comparing statistics. My problem is that this method isn’t accurate because after every query result is displayed and memory use of Management Studio grows up. Important for me is to not increase memory consumption, because return […]

How to get the six week sunday's weekno in SQL server 2008 r2?

I want to get the six week sundays weekno using the SQL Server 2008.For example i have the November month, date 18, year 2012. The WeekNo of the November month 18 th date is “47”.

SQL server 2012 returns different results than SQL server 2008

I have a piece of script using cursor to sequence rows in a table. For example, the table looks like this, SSN, Kid_SSN, Kid_DOB, Seq# to list every person with 1 or more kids. I want to update Seq# to label each kid as 1,2,3… based on Date Of Birth. I used cursor for update […]

SSRS 2008r2 installation integrated with Sharepoint

I would like to install SQL Server Reporting Services 2008r2 integrated with Sharepoint. When I am installing it there is a radio box which indicates installation mode. When I choose it for integrated mode then setup gives me an error. It says that I have to try install with another SQL version except SQL advanced. […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.