Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server-2008
Search options not deleted
user 41590
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
0
votes
3
answers
10k
views
How to check if range between two numbers is available in table of ranges
I have following table of number ranges
Create table Ranges {
Id int identity(1,1) primary key,
RangeFrom int not null,
RangeTo int not null
}
Insert into Ranges(RangeFrom, RangeTo) VALUES (1, …
- 1,109
0
votes
text positioning for select list
Max Vernon: you were right, Courier did the trick.
I added style:"font-family: Courier New" to the <selected> tag.
- 1,109
0
votes
2
answers
37
views
text positioning for select list
I have following issue, I have hierarchy table where every record has level, code and description and I need to have description to look as it is was one column.
Example code
CREATE TABLE #tmp (Valu …
- 1,109
2
votes
1
answer
1k
views
Unpivot columns based on select
It is possible to do Unpivot operation, where column names are done via select, without using dynamic SQL ?
I tried this, but it fails.
SELECT *
FROM [dbo].[Report]
UNPIVOT
(
Value
FOR WeekName …
- 1,109
0
votes
1
answer
2k
views
SQLCMD is not working in pre-deployment script in sql project
I have sql project in visual studio and I created pre-deployment script
/*
Pre-Deployment Script Template
------------------------------------------------------------------- …
- 1,109
0
votes
Allocate space for object 'dbo.SORT temporary run storage
I also got this error message. It turns out that the physical disk was full. Our SQL Server admin deleted some history backups and changed backup mode from full to simple at some databases which had l …
- 1,109
3
votes
1
answer
2k
views
CLR Procedure with XML parameter returns Data at the root level is invalid. Line 1, position 1
I have following CLR stored procedure, which is throwing error on this command
xmlDoc.LoadXml(inputXml);
code
public static int spGetTaxOfficeXML(SqlXml _inputXml)
{
// this proced …
- 1,109