Try this:

declare @myDate datetime;

set @myDate = cast(dateadd(day, -1, getdate()) as date);

SELECT

*

FROM

[ThomasSci].[dbo].[tsi_gdserial_vw]

where

cast(date_shipped as date) = @myDate

order by

...

Control-Shift-R in SSMS for SQL Server 2012. I don't have SQL Server 2014 installed yet.

If that doesn't work, start with the Edit menu when you have an active query...

kiran.rajenimbalkar (8/19/2015)

---

CREATE TABLE abc (

id INT

,EID INT

,name NVARCHAR(1000) NULL

...

Looks like you need to refresh the Intellisense Local Cache.

Sean Lange (8/19/2015)

---

I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT...

Do you know what would really help? DDL for the tables/views involved, sample data that represents the problem domain (includes data that will be returned as well as some...

Read this:

https://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(SP_ADDSERVER_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(DevLang-TSQL)&rd=true

Chris.Hubbard4U (8/17/2015)

---

I did not answer you first question; sorry about that.

I can not think of...

Yes. Need the answers to the two questions I asked.

What you are looking for is a running total. Will need more information, DDL for the table (CREATE TABLE statement), sample data (INSERT INTO statements), expected results based on...

Looks like someone ran sp_dropserver.

Two questions:

1) is this a default instance

2) What does the following return: select SERVERPROPERTY('machinename');

What does this return:

select * from sys.servers;

Alvin Ramard (8/17/2015)

---

Brandie Tarvin (8/17/2015)

---

You are WRONG, Sir! Case has absolutely EVERYTHING to do with the way things work. If we...

Not relevant to what I am talking about here....