Viewing 15 topics - 272,566 through 272,580 (of 284,021 total)
Topics
Started by
Posts
Last post
I am trying to finding date difference between today's date and given date in the table.Some rows h…
1 replies
USE AdventureWorks2012; GO SELECT p.FirstName, p.LastName ,ROW_NUMBER() OVER (ORDER BY a.Postal…
1 replies
Hi all, I always see this result while getting DBCC OPENTRAN: Oldest active transaction: SPID (…
1 replies
I was reading about these but wondered how they would help when 99% of your sql is ORM-generated? …
1 replies
I"m trying to learn SSIS and am creating a package. I have a data flow with the following: 1. OLE D…
1 replies
I have to put the following dates in a Matrix with dip on rows and data on columns. On the same day…
1 replies
I had to take a database offline but it took ages and crashed. At first I couldn't access it but on…
1 replies
Hi All,I have the following table:declare @T table(ID int identity, NUM int);insert into @T values(…
1 replies
HiCan somone help me explain this.Why does the left join not group the rnGrp column like …
1 replies
We use SQL server 2012 merge replication to replicate data between 11 databases. At some time a con…
1 replies
Hi, I have SQL Server 2012 Enterprise / Standard Edition - Per core and Windows Server 2012 is in V…
1 replies
I've got two tables and need to obtain the data in the Records table based on the information in th…
1 replies
Tennessee vs. Nebraska Live Stream Georgia vs. TCU Live Stream Sun Bowl 2016 Live Stream Liberty Bo…
1 replies
Hi, We use Adam Machanics great proc sp_WhoIsActive fairly frequently and I know his tutorial state…
1 replies
I got a PIVOT thats giving me some trouble. Is meant to retrieve yearly expenses per coucillors. Pr…
1 replies
Viewing 15 topics - 272,566 through 272,580 (of 284,021 total)