Viewing 15 posts - 76 through 90 (of 311 total)
GSquared (11/2/2011)
You can't use table variable names in column-qualification.
Actually you can. Just put square brackets around the variable name, although I prefer the alias.
Create PROCEDURE [dbo].[proc_AdditionalInfotbl] (@jobtbl JobTableType READONLY) AS
Begin
Update...
November 3, 2011 at 12:56 am
Or even simpler
SET @TableHTML =
N'<html><body>Please note the following outstanding items from the audit requirements listing, which you have requested. Please ensure that...
October 25, 2011 at 10:31 am
FOR XML EXPLICIT seems to do the trick.
SET @TableHTML =
N'<html><body>Please note the following outstanding items from the audit requirements listing, which you...
October 25, 2011 at 4:42 am
Strange enough, both query 1 en query 2 do not terminate on my machine. Looks like it has something to do with replacing CHAR(0) in combination with the collation. If...
October 19, 2011 at 3:26 pm
Take a look at http://support.microsoft.com/kb/194124
HTH
October 17, 2011 at 4:09 am
You posted a possible answer to your own question more than a year ago, so maybe you forgot.
http://www.sqlservercentral.com/Forums/FindPost922664.aspx
Unfortunately, the link to connect.microsoft.com results in an unexpected system error now....
October 2, 2011 at 2:12 pm
SELECT
RIGHT('0000000' + CAST(1234 AS VARCHAR(7)), 7) +
RIGHT('0000000' + CAST(76541 AS VARCHAR(7)), 7)
September 29, 2011 at 12:13 am
What's wrong with it? What do you expect?
August 2, 2011 at 2:08 pm
declare @nodeid int = 1
declare @doj date = '2011-08-01'
;with cte as (
select
...
August 2, 2011 at 11:06 am
Koen Verbeeck (7/28/2011)
Gianluca Sartori (7/28/2011)
SQL Server has always...
July 28, 2011 at 7:59 am
Maybe this one?
SELECT
exid1, exid2, exid3,
COALESCE([1], '') + COALESCE(',' + [2], '') + COALESCE(',' + [3], '') + COALESCE(',' + [4], '') + COALESCE(',' + [5],...
July 27, 2011 at 7:43 am
Ok, here's some explanation. Most of the work is done in the derived table, so let's rebuild it.
SELECT
D.ID,
X.C.value('@Name[1]','NVARCHAR(2000)') AS...
April 6, 2011 at 10:08 am
Glad it works out for you. I'm about to leave for work, so I don't have the time to give you an explanation right now. I'll be back.
Peter
April 5, 2011 at 10:31 pm
This one deals with a variable number of <Value> elements.
SELECT
[Type], [Path], [Option1], [Option2], [Option3]
FROM
(
SELECT
D.ID,
X.C.value('@Name[1]','NVARCHAR(2000)') AS [Option],
...
April 5, 2011 at 5:02 am
SELECT
ComputerName,
X.C.value('.', 'varchar(255)')
FROM
dbo.MyTable
CROSS APPLY
AppInfo.nodes('/ROOT/Applications/Application') as X(C)
March 31, 2011 at 5:30 am
Viewing 15 posts - 76 through 90 (of 311 total)