Microsoft SQL Server Forum

Hello All, How to split the data in a column with comma separation. I am attaching the images for my Input and my expecting Output. Input: ID Group ProjectIds 1 xxx 1234,456,8972 2 yyy 567,7890,12 3 zzz 32,165

duplicate rows occurring when using inner join,i want to join a table value to another table..

hello, do you know how to determine the database version of a database on sql server management studio for some compatibility reasons because not all of the databases are created using the version of sql server i am currently running. some of them are attached using backup. Thanks.

Below is a screenshot of my sql code and results where I've been trying to join 3 tables. I need to find the number and name of each customer that currently has an order on file for a Gas Range. I've included screenshots of the data as well. Any help you can give me with this most difficult problem will be appreciated. ...

I am trying to loop through my counter to create a dynamic sql query which should finally look like I am trying to use this approach to get the final query but doesnt seems to work declare @CurrentRow int set @CurrentRow =0; declare @RowsToProcess int declare @FinalHistoricalQuery varchar(5000) WHILE @CurrentRow<3 BEGIN

If i make any changes(Insert/Delete/Update)in a site then the corresponding changes will store in tables of that particular DB. How to know on which table which operation(DDl/DMl)has done. I would like to store DML activities on Database level in a table,not on perticular Table, Please help

Dear all, I am currently undertaking an academic project to design & build a Web Application (using HTML5 and open standards) that will require a data storage method and a means of serving the data to the Web Application. Data will include items such as simple statistics in numeric format and information in text format. I am considering...

I've searched around for help on this but everything I find seems to be a discussion about the relative benefits of using, or not using, this setting. I want to specify in SQL Server that ZLSs are not acceptable in the field whether or not NULLs are allowed. If ever I have to deal with an empty-looking value I want to know it's NULL rather...

Hai all, I have to select the data from sql server table which is in following format. Ex table Name : sample The table sample has one column named as Text and the datatype of that column is nvarchar(20). so in that column i have a data like:

Hi, I'm having problems with databases that are getting corrupted. I have a server that runs a SQL Anywhere 11 database. (the consolidated database). Beside that, we have about 15 remote databases that run on the laptops of my mobile workforces. To keep all databases in sync, I have setup a two-way server-to-laptop replication.

I am new to sql server I have web application in asp.net 4.0 with code in vb.net I am saving data for example: hr & safety When i save data in sql server 2008 R2 and retrive it in my web forms it shows hr amp safety what is it? how can i solve it? and what if i want to replace & with simple and?

I know that users can be given permission to access the database to select data from database as shown below. But doing this for each user in the user table would take ages.. is there any method i could do this for all users in the user table I want to give all of them roles to allow them to read certain tables only.. any ideas how this can be...

Viewing them both on the screen yields 2 different sizes (object browser says (5), sp_help says (10))....no there have not been any recent changes so I do not need to refresh the view of the object browser. Any one know why the difference? Thanks!

i got this question in an interview! lats say i have a below table and i want to fetch the rows only till the period is currently active (all the rows above including Active Period = 1). if Active Period = 1 that means it currently Active.Query has to be dynamic lets say if the Active Period changes later then it has to fetch the rows till...

I set up a Web Service Task in SSIS with the following Server URL: http://www.webservicex.net/globalweather.asmx?WSDL, Service:Global Weather, Method:GetCitiesByCountry Output File:WeatherOutput.xml. It runs fine and produces the data, but contains control characters. Instead of < and >, it shows &lt; and &gt;.

Hello, this is a two part question 1) Can someone recommend a way to automatically backup SQL and mysql databases? Preferably if there is an online service (free or paid). Would be nice if the software or website could handle SQL and mysql. I am currently hosting my .net MVC 3.0 application hosted on asphostportal.com. We are in the final...

Hi, I wonder if anyone could help. I have been hacked and one field in my database has had html and links added after the original content. http://www.website.com</title><style>.ajbv{position:absolute;clip:rect(481px,auto,auto,446px);}</style><div class=ajbv><a href=http://ma I need to remove everything after and including the title to...

Hi, I wonder if someone could advise on the following. I inherited this code, I am not a coder but have had some kind of hack and am looking at code to reduce its vulnerability. At the top of the page I have nPage = CLng(Request.QueryString("Page")) Keyword = Trim(Request.QueryString("Keyword")) in the where clause I have

dear all, I have 2000 rows in my table and i want to have subtotal after every 20th row could anyone help me i do not know how to do it. thanks in advance.

I am wanting to replace "in stock", "low stock" and "out of stock" with Values of "20" , "2" and "0" my software only allows me to do one expression at a time. I wanted to know if this is possible and if so how?

I have multiple users using an Access front end plugged into a SQL Server back end. I want something that identifies the user's session to SQL server. I've tried @@SPID and found that there can be multiple values when connecting from the same session of Access. Equally, login and user names/IDs are not reliable as it's perfectly possible...

Hi, everybody Prompt please, MS SQL 2012 on the virtual computer. Backup of all section with bases every day, at 19.00. That is, for every day I have the file copy .MDF and .LDF. Is there a way to recover the database at a certain time? Not 7 hours, but for example at 12.00. If I just attach the base then at the start I get an error about the...

Hi I am new to SQL coding - need some advice I have data with dates but the dates I have are currently "YYYYMMDD" which is fine and I don't want to change But the data I wish to bring back needs to be data from the last 7 days So

Can you tell me why this CAST(ExtensionData AS nvarchar(10)) AS Expr1 results in an error "Data type mismatch - no conversion possible"? is an ntext column. This error pops up SQL Server Management Studio when I am editing a view; if I ignore it and run the view anyway, it pops up again. It also happens if I use CONVERT instead of...

I have a problem understanding how/why T-SQL refuses the following line within a View : IIF(..='C',IIF(..,'P',IIF(..,'Q','N')),..) AS Error: Error in list of function arguments: '=' not recognized. Unable to parse query text. It seems to be that, unlike when processing the same code in Access, it cannot, or will not, resolve expressions...