Viewing 15 posts - 3,001 through 3,015 (of 8,761 total)
LinksUp (10/25/2016)
October 25, 2016 at 1:21 am
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')
...
October 25, 2016 at 12:59 am
sqlserverDBA2016 (10/24/2016)
what would the fix be for this :The operating system returned error 21(The device is not ready.) to SQL Server during a
write at offset 0x000000a87d0000 in file 'D:\SQL_DATA\tempdb1.ndf'
Could...
October 25, 2016 at 12:21 am
drew.allen (10/24/2016)
October 24, 2016 at 1:35 pm
david.kiellar (10/24/2016)
Wow, not pretty but it works. THANK YOU so much.
You are very welcome.
😎
October 24, 2016 at 7:41 am
You could try something like this
😎
;WITH FILTER_VALUES(FVAL) AS
(
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT...
October 24, 2016 at 7:14 am
muhamadehsan (10/24/2016)
October 24, 2016 at 7:02 am
Phil Parkin (10/24/2016)
ramos.ferdinand (10/24/2016)
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...
October 24, 2016 at 6:59 am
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
(
...
October 24, 2016 at 6:58 am
Beatrix Kiddo (10/24/2016)
Now, who'd like to be the first to open the unknown .rar file on this thread http://www.sqlservercentral.com/Forums/Topic1828619-2799-1.aspx 🙂 ?
It is not a valid SQL Server Backup file
😎
October 24, 2016 at 5:51 am
sqlserverDBA2016 (10/24/2016)
detaching and attaching can risk corrupting the files
Done this hundreds if not thousands of times on almost all versions of SQL Server ever since the dinosaurs turned into oil,...
October 24, 2016 at 4:17 am
sqlserverDBA2016 (10/24/2016)
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...
October 24, 2016 at 3:43 am
myalliku (10/24/2016)
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...
October 24, 2016 at 3:33 am
Quick suggestion, not tested so review carefully before applying to any production database.
😎
To satisfy this query
SELECT
[t0].[CardNumber]
, [t0].[ReferenceNumber]
,...
October 24, 2016 at 3:29 am
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...
October 24, 2016 at 3:20 am
Viewing 15 posts - 3,001 through 3,015 (of 8,761 total)