You are very welcome.

😎

You could try something like this

😎

;WITH FILTER_VALUES(FVAL) AS

(

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT...

muhamadehsan (10/24/2016)

---

I have a school.bak file I want to convert this to school.mdb file can any one convert for me , I am asking because I failed to install sql...

Phil Parkin (10/24/2016)

---

ramos.ferdinand (10/24/2016)

---

Hi Gurus,

Just wanted to seek out for your help. This is a bit opposite of what aggregation should be. :hehe:

I wanted to aggregate records with different...

Quick suggestion with a CTE for grouping

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

create table dbo.test1

(col1 int,

col2 int,

col3 varchar(2),

col4 decimal(3,1)

);

--Test Data

insert

into dbo.test1(col1,col2,col3,col4)

values

(1,2,'A',5),

(1,2,'B',5),

(2,3,'B',6),

(2,3,'B',6.5),

(2,3,'B',6.3),

(3,4,'B',6),

(3,4,'B',6),

(3,4,'A',6),

(3,4,'B',6);

;WITH BASE_DATA AS

(

...

It is not a valid SQL Server Backup file

😎

Done this hundreds if not thousands of times on almost all versions of SQL Server ever since the dinosaurs turned into oil,...

sqlserverDBA2016 (10/24/2016)

---

thanks mate

Does that mean that for me to migrate to sql server 2014, i just need to install 2014 sql server and export the dbs only .

I will be...

myalliku (10/24/2016)

---

Hi Folks,

I have a question to ask you about Database Recovery modes. I have managed an SQL Server and I take full backups for all databases daily. I do...

Quick suggestion, not tested so review carefully before applying to any production database.

😎

To satisfy this query

SELECT

[t0].[CardNumber]

, [t0].[ReferenceNumber]

,...

sindhupavani123 (10/24/2016)

---

Hi, I have the following data with me:

CREATE TABLE Table1 (ID varchar(10),StudentName varchar(30), Course varchar(15) ,SECTION varchar(2),DAY varchar(10),

START_TIME time , END_TIME time, actual_starttime time, actual_endtime time);

INSERT INTO Table1 VALUES...

Eirikur Eiriksson (10/24/2016)

---

Can you please elaborate further on this, what makes you think you might...

Can you please elaborate further on this, what makes you think you might need any...

I guess that it depends, without further information it is impossible to tell.

And what is backward compatibility used...

office 74070 (10/24/2016)

---

Hy Guys,

thank you for your replies.

Yes of course, it was a permission trouble. We have two reporting plattforms and different user in the connection settings.

My problem was...