joeroshan (9/21/2016)

---

A quick and simple solution with good old joins.

Select

CustomeridID.Data as CustomeridID ,

AccountID.Data as AccountID,

EnquiryName.Data as EnquiryName,

Source.Data as Source,

EventDate.Data as EventDate,

EventDays.Data as EventDays,

EnquiryCreatedDate.Data as EnquiryCreatedDate,

Description.Data as Description

FROM dbo.[DataTEST]...

This will pivot the data sets to columns

😎

IF OBJECT_ID(N'dbo.DataTEST') IS NOT NULL DROP TABLE dbo.DataTEST;

CREATE TABLE [dbo].[DataTEST](

[ID] [int] IDENTITY(1,1) NOT NULL,

Data [varchar](255) NULL

) ON [PRIMARY]

INSERT INTO dbo.[DataTEST]

...

Here is a quick suggestion for filtering the data rows from the set

😎

IF OBJECT_ID(N'dbo.DataTEST') IS NOT NULL DROP TABLE dbo.DataTEST;

CREATE TABLE [dbo].[DataTEST](

[ID] [int] IDENTITY(1,1) NOT NULL,

Data [varchar](255) NULL

) ON [PRIMARY]

INSERT...

Minnu (9/21/2016)

---

Hi Team,

Restoring SQL Server database from one server to another.

Actual Database size is: 14.3 GB

But while restoring getting below error.

The database required 127533776896 additional free bytes, while only 47082643456...

Sri8143 (9/19/2016)

---

I have created a SSIS pacakge with Transfer SQL Server objects task which copies the selected data from one server to other. For this task it used the SMOServer...

Sean Lange (9/19/2016)

---

I think that is only two choices...

Sean Lange (9/19/2016)

---

I think that is only two choices...

I'm normally very tolerant when it comes to noobs but this one only leaves me three choises

😎

1) deaf

2) daft

3) dumb

dimpythewimpy (9/19/2016)

---

I tried to convert the above function to inline table valued function, but was unable to do the same. Can some one provide an example of inline function using...

Jeff Moden (9/19/2016)

---

Eirikur Eiriksson (9/19/2016)

---

Hi all,

I'm writing few pieces on XML operation's performance in SQL Server, both generating the XML, parsing it and operations on it and I'm wondering if...

SQLPain (9/19/2016)

---

Got a Column FundingDate DATETIME ( has date as well as timestamp). I am using the following in where clause.

CONVERT(varchar(10), L.FundingDate, 101) <=CONVERT(VARCHAR(10),GETDATE()-90,101)

--doesn't work, misses dates such 2007-11-14...

Brandie Tarvin (9/19/2016)

---

Eirikur Eiriksson (9/19/2016)

---

Hi all,

I'm writing few pieces on XML operation's performance in SQL Server, both generating the XML, parsing it and operations on it and I'm wondering if...

I've been in those meetings.....:-D

😎

Hi all,

I'm writing few pieces on XML operation's performance in SQL Server, both generating the XML, parsing it and operations on it and I'm wondering if anyone has any particularly...

Post the DDL (create table) script, sample data as an insert statement and the expected results.

😎