Try this in SSMS:

sp_helplanguage @@language

No

yashuvp (1/17/2014)

---

I found couple of data that are in wrong format 1/1/0001 (old data) so I have modified the sql to look for the date that are good, but still...

yashuvp (1/16/2014)

---

I am importing Oracle table with data using SSIS package and while preview the data I am getting following error.

Year, Month, and Day parameters describe an un-representable DateTime. (mscorlib).

Any...

How is this?

declare @TestDate date = getdate();

select dateadd(month,3,dateadd(year,datediff(year,0,dateadd(month,-3,@TestDate)),0))

set @TestDate = '20140413';

select dateadd(month,3,dateadd(year,datediff(year,0,dateadd(month,-3,@TestDate)),0))

set @TestDate = '20140331';

select dateadd(month,3,dateadd(year,datediff(year,0,dateadd(month,-3,@TestDate)),0))

set @TestDate = '20140401';

select dateadd(month,3,dateadd(year,datediff(year,0,dateadd(month,-3,@TestDate)),0))

JimbobsQL (1/17/2014)

---

Hi All,

I'm trying to find the most succinct way to get the last occurrence of April 1st given a date.

At the moment I'm using this:

DECLARE @Date DATE = '20131217'

SELECT...

Think of BETWEEN as the following:

...

where

FilterColumn >= @StartDate and FilterColumn <= @EndDate

Would this make sense if @StartDate was greater than @EndDate?

Hard to tell you what you should do since we can't see what you see. It would help if you posted your code and the DDL for the table...

GilaMonster (1/14/2014)

---

Almost definite. Something changed values on that page on disk after SQL wrote it out,...

Just verifying that 824 errors usually point to a possible I/O Subsystem issue.

ccmret (1/13/2014)

---

Hello I want to set the default parameters for a function. I;d like to set the date start date to current date and end date for the last...

USE Sims

go

select * from dbo.Students where StudentID = 1; -- Will select data from Students table in database Sims

go

USE SimsCopy

go

select * from dbo.Students where StudentID = 1; -- Will select...

mwitthoft (1/12/2014)

---

Good ideas about the cursor declaration. Yes, it's declared LOCAL. And although the proc does not modify the table that the cursor is reading, I'm planning to try a...

rho_pooka (1/11/2014)

---

Jeff Moden (1/11/2014)

Although it may seem so, I'm not being sarcastic at all when I ask you, do you know what "Books Online" is? People who ask the...

May I ask why you deleted your original question? To be honest it is bad form especially since it is possible others my have...