LinksUp (10/25/2016)

---

Since you posted in a 2008 forum, here is a simple self-join using a cte that gives you your output. If you had access to 2012 or greater you...

Almost identical to LinksUp's solution, does the same thing;-)

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(ID,Client,Level,[Change Date]) AS

( SELECT ID,Client,Level,CONVERT(DATE,[Change Date],103)

FROM (VALUES

( 1,1000,2,'01/07/2016')

...

Could...

drew.allen (10/24/2016)

---

If I understand correctly, just change your ORs to ANDs in your original query. You're getting rows where ANY column does not contain any of those values, but...

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...