Hello I have also installed the SQL Engine and the SSMS and take some notes on SQL Server 2011 installation

What is interesting is although there was a warning about the...

I guess he is trying to get the "Active" text from "<Status>Active</Status>" fragment

OK, I studied some

If you remove the below attribute value from Contact element

xmlns="http://ws.constantcontact.com/ns/1.0/"

And change sql script as follows then it will...

"xmlns" attributes within root element and Contact element are causing the problem.

But I do not know why!

If those attributes are removed then the second SELECT statement will return Status element...

The first select returns nothing, perhaps he is asking about that select.

My task is to validate which files contain the header as

Title Forename Surname FullName JobTitle Department Organisation Address1

and move that file in to pass folder and the rest of...

Here is a script that is working on my test environment

First I get the list of txt files in a specific directory using code demonstrated at List Directory Files using...

You can get the list of all files using the sql code at List Directory Files using T-SQL xp_cmdShell Stored Procedure

This code again uses the xp_cmdshell.

Then you can make...

Hello,

You can check the article How to read text file using t-sql xp_cmdshell command for reading text files within SQL Server.

Again xp_cmdshell can be used for moving files between file...

Hello,

I get a script similar to below when I tried your requests using SSMS

I hope that helps,

BEGIN TRANSACTION

GO

CREATE TABLE dbo.Tmp_Testowners

(

owner_id int NOT NULL IDENTITY (1, 1),

owname varchar(15) NULL

)

GO

SET IDENTITY_INSERT dbo.Tmp_Testowners...

Sorry, instead of sql pivot please try following code

select

Name, address, phone,

ClaimCode1 = MAX(ClaimCode1),

ClaimCode2 = MAX(ClaimCode2),

ClaimCode3 = MAX(ClaimCode3),

ClaimCode4 = MAX(ClaimCode4),

ClaimCode5 = MAX(ClaimCode5)

from (

select

Name, address, phone,

ClaimCode1 = case when rn =...

Hi,

Did you tried using T-SQL Pivot syntax in your codes?

Please also check the above url for pivot table samples.

You can use Output clause for that task.

Actually it is one of the features I love in t-sql

Please check for examples at T-SQL OUTPUT Clause Sample and T-SQL OUTPUT Clause...

Hi,

Steve points to an important point.

The important point is variables work successfully only the original update code affects single table row.

If you use variables just it is the case in...

Hi Paul,

I remember we have a discussion on splitting function, do you remember too 🙂

In fact I could not measure how fast my split functions are.

I have also coded a...