Rod at work (6/5/2015)

---

I've got two tables that I'm trying to order the data returned in a view. As I understand it, starting with SQL 2005 doing a SELECT TOP...

[font="Arial Black"]Hey, why are we trying to change a column declared as a DATETIME column to an INT? If it is a Date/Time value store it as such.[/font]

Sorry for...

SQL-DBA-01 (6/5/2015)

---

Hi Experts,

I dont have RDP access to the server so can't RDP to check when SQL was last installed.

Is there any way to find the details remotely by running...

My question, why are you converting a datetime column to an int column? If it is a date/time value use datetime data types.

Here is your original post:

yusufm 48726 (6/3/2015)

---

Hi,

I...

This sounds like a knee jerk reaction by management types...

Just another way to do it as well:

DECLARE @MyTable AS TABLE (

Id int IDENTITY(1, 1) NOT NULL PRIMARY KEY CLUSTERED,

[Source] varchar(10) NOT NULL,

FirstField varchar(20),

SecondField varchar(30)

);

INSERT INTO @MyTable ([Source], FirstField, SecondField)

SELECT...

Yes, you may have 1 default instance and multiple named instances. I'd start here: https://msdn.microsoft.com/en-us/library/dd692930(v=sql.10).aspx.

There may be other messages around the error that may help diagnose the error. That's why I asked what else was in the error log around the error itself.

Nope, you have access to extended events in SE.

Please post DDL (CREATE TABLE statement) for the table(s) involved, some sample data for the table(s) involved (INSER INTO statements), and the expected results based on the sample data you...

Just be careful with using a VIN as a primary key. I have been told that the algorithm for validating a VIN has changed and that all VINs are...

dwilliscp (6/4/2015)

---

Lynn... it looks like you can not use a case statement inside of the update statement... just trying to make sure.. I guess I can put the update together...

dwilliscp (6/4/2015)

---

Is there a way to use a case statement after "SET"? I am currently getting the following..

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'case'.

My...

Ed Wagner (6/4/2015)

---

rodjkidd (6/4/2015)

---

Lynn Pettis (6/4/2015)

---

Alvin Ramard (6/4/2015)

---

Jeff Moden (6/4/2015)

---

Shifting gears a bit...

Have any of you ever used a CTP of SQL Server to power your real production databases? ...