Use this tag for questions specific to the 2008 R2 version (sql.100) of Microsoft's SQL Server.
0
votes
0answers
7 views
How to convert a procedure into create criteria with nhibernate
I have a stored procedure that i have to convert it into nhibernate create criteria.I have done all the mapping related to procedure in .hbm file.But when i debug the code, no data is retrieved.But ...
0
votes
0answers
3 views
Create scripts in seperate file for each object with correct ordering
In MSSMS you can create scripts for each object in a different file. That's awesome.
But if you want to actualy run the scripts, you'll have to determine the order of the scripts or you will run into ...
2
votes
0answers
24 views
SQL SERVER 2008R2 Nested Transactions with RAISERROR
We are going through a process of switching from DB2 to SQL Server 2008R2 and I'm a bit unfamiliar with TSQL. Any help getting a better understanding of what is occurring would be nice. We've ...
0
votes
2answers
20 views
I am unable to use THROW SQL Server 2008 R2
SQL Server 2008 R2 Management Studio does not recognized my throw in the below example, it says
incorrect syntax near Throw
I am trying to throw an error here, so I can handled it in my website ...
0
votes
0answers
18 views
Restore database created in SQL Server 2008 R2 to SQL Server 2008 R2 SP2
I have a .bak file created by some other user in (I think) SQL Server 2008 R2 (10.50) and I need to restore it in SQL Server R2 SP2 (10.52). I used a hex viewer to look into the .bak file and found ...
0
votes
0answers
4 views
Update doesn't work inside a stored procedure called from OPENROWSET
We have a stored procedure that calculates a value and stores it into a table.
We're trying to get that value with a subselect query in this way:
PROCEDURE CODE:
[...] Code to calculate the value. ...
1
vote
0answers
14 views
Calling stored procedure usign Nhibernate named query
I am facing some problem while calling procedure using named query in nhibernate.I have a procedure which accept three parameters, first one is varchar(max) which is actually a guid list, second is ...
0
votes
1answer
18 views
Replace XML node
I have a table in which there is a column named "ServiceConfig" with datatype xml.
I have a record with xml like below :
<Config>
<services>
<service name="pro" />
...
0
votes
0answers
10 views
How to enable the SQL server instance to accept filestream data type?
I have already created database on SQL Server resided on our company's Server. Now I want to enable FILESTREAM on that database. When I tried to open SQL server Configuration manager from my pc, I got ...
0
votes
1answer
29 views
Calling SP with Output Parameter From another SP
I just trying to call SP from another SP, but stuck in that when find output parameter in calling SP. i am using EXECUTE sp_executesql to call the Store Procedure.
Here is some part of my SP
...
1
vote
1answer
37 views
SQL Server 2008 R2 view assistance
I have several views and tables which I am trying to connect in one view to create a website GUI for several users (and myself) to use. It is basically an inventory system which is linking together ...
1
vote
4answers
37 views
Calculations over Multiple Rows SQL Server
If I have data in the format;
Account | Period | Values
Revenue | 2013-01-01 | 5432
Revenue | 2013-02-01 | 6471
Revenue | 2013-03-01 | 7231
Costs | 2013-01-01 | 4321
Costs | 2013-02-01 ...
0
votes
1answer
23 views
Improving performance of a query
I have the following sql query Performing badly:
SELECT
Count(ExtCardID) as CardCount
from
CardIDs CARDS with (NoLock)
inner join
(select CustomerPK
from GroupMembership with ...
0
votes
0answers
50 views
T-SQL Query - Return One Result, or return 0 (SQL 2008R2)
I'm quite the novice when it comes to T-SQL, and I can't figure out this query.
I am trying to compare an Item's value to it's ledger Value to check for any anomalies, because occasionally they go ...
0
votes
1answer
37 views
updateing all foriegn key constraint in sql server?
I have a database in sql server 2008 R2 that have many table (over 200) and have many relation betweens tables.
Delete rule in most of relations is No Action
I need to Update all relation delete rule ...
