Quick inline calendar table example using the sample data posted previously on this thread.

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#tamp') IS NOT NULL DROP TABLE #tamp;

CREATE TABLE #tamp

( WeekNo INT, FromDate SMALLDATETIME,...

For a variable inside the procedure use this

😎

DECLARE @MY_INT_VAR INT;

SET @MY_INT_VAR = 0;

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

😎