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?
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 […]
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)’, ‘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 […]
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 […]
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 […]
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 […]
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 […]
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”.
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 […]
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. […]