SQL Server is a relational database management system from Microsoft. Use this tag for all SQL Server editions including Compact, Express, Azure, FastTrack and PDW.
-1
votes
3answers
14 views
How to get the cumulative column from my sales table?
I have the following scenario
pid & month form a composite primary key .
pid month amount
1 1 10
2 2 15
1 2 20
1 3 10
3 3 4
2 3 6
Now the column to ...
0
votes
2answers
14 views
SqlDataReader filling combobox IsDBNull issue
Hello I have tried to handle Null exception but I'm still receiving the exception warning: data is null this method or property cannot be called on null values.
This is my code:
spojeni.Open();
...
1
vote
1answer
10 views
How to write stored procedure with if then
Am new to stored procedures, being familiar with C#.
I need a stored procedure that does this:
Select * from dbo.file_map where file_sub_type = @file_sub_type and column_name =
@column_name and ...
0
votes
1answer
17 views
SQL, How to Count Duplicate Values in One Table?
I have a view with the following table/sample values:
ParentID, ChildContainerID, ChildID
1 CCID1 CID1
1 CCID1 CID2
1 CCID2 CID1
...
0
votes
0answers
6 views
Compare tabular and data warehouse row counts
I have implemented an SSIS package to import new or changed data to Tabular model from Data Warehouse (hosted on SQL Server 2012) on a regular basis. As I am still testing my package, I need to ...
0
votes
0answers
4 views
configuring iodbc to use FreeTDS for MS SQL Server under cygwin
I'm trying to use RODBC to make a connection to a SQL Server database from R under cygwin.
I've installed libiobbc and libiodbc-devel, which I understand provide the driver manager that the RODBC ...
0
votes
1answer
19 views
To Group By Hire Date in MSSQL?
Assume the following table
Employee
EmployeeID INT
FirstName VARCHAR(50)
LastName VARCHAR(50)
SupervisorEmployeeID INT
Salary MONEY
HireDate ...
0
votes
0answers
13 views
SQL Report on Groups with Contiguous Time Entries
Using SQL Server 2008r2
I have a table with data structure of (id int IDENTITY(1,1) PK, Group_Num int NOT NULL, Time_Entry Time NOT NULL).
A query on the table would return results like the below ...
1
vote
2answers
14 views
How do I search for a table in sql 2005?
I just created a table within a huge database and saved it. I've tried to refresh the database to see if my new table appears and I closed & reopened the Management Studio but don't see my new ...
2
votes
2answers
24 views
SQL-statement for two group-columns
I have a problem creating a SQL-statement for sqlserver2008. I have the following data:
city person priority
-----------------------------------
Linz Mike 1
Wien Mike 1
...
0
votes
1answer
21 views
Can't restore database from backup file
Based on this article I made a small WPF application to backup/restore a database.
Code:
using System.Windows;
using Microsoft.SqlServer.Management.Smo;
namespace DBManager
{
/// ...
0
votes
1answer
17 views
SQL Server 2008 modify data type of table column
I need to modify the data type of a table column which is considered to be done via the statement:
ALTER TABLE QUANTITIES_NEW ALTER COLUMN VERSION_NEW VARCHAR(12);
Unfortunately I go an error ...
0
votes
1answer
41 views
Stored Procedure Where Parameter SqlDbType
I have a combobox and a textbox.
I use the combobox value for @criteria and texbox value for @value
but when I execute this there is no data showed up.
I already analyzing the problem is within :
...
0
votes
2answers
19 views
Using nvarchar cfsqltype in coldfusion with jtds jdbc
Firstly, my cconfig is:
Language: ColdFusion 10(and installed update 11)
DB is MS SQL Server 2012
Using the jtds jdbc(tried versions 1.2.6, 1.2.8 and 1.3.0)
I'm currently having a problem running ...
1
vote
1answer
20 views
Add node to XML using TRANSACT-SQL
I've been struggling with this simple piece of code without result. I'm just trying to add a new node to an XML variable.
DECLARE @XML XML;
SET @XML = '<root>
<policyData>
...
