You can't have two different data types in the same column, your effectivly saying I want DATETIME and VARCHAR data in the same column which is not allowed.

You will need...

No problem, glad I could assist.

May I suggest some further reading http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

They may help you out with other date related issues you may run...

Ed Wagner (1/17/2013)

---

If your field is a datetime data type, then you're comparing the datetime result of GetDate() against the datetime value of the field. So, nothing's going to...

GilaMonster (1/17/2013)

---

Oh yes, absolutely and...

SELECT CHARINDEX('%','antho%ny')

= 0 % does not exist

>0 % exists and in what location in the string

Shadab Shah (1/17/2013)

---

Consider the following code

CREATE TABLE EMP3(EMPNO INT IDENTITY,NAME NVARCHAR(50))

INSERT INTO emp3 VALUES('ABC')

INSERT INTO EMP3 VALUES('DEF')

INSERT INTO EMP3 VALUES('GHI')

INSERT INTO EMP3 VALUES('JKL')

INSERT INTO EMP3 VALUES('MNO')

CREATE TABLE #TEMP(NUM INT,NAME NVARCHAR(50))

INSERT...

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/

But again like I said on your other post, query sys.master_files get the number for temp db then match it to the processor value from the above

But seriously read that...

duplicate post

replies here please http://www.sqlservercentral.com/Forums/Topic1408333-391-1.aspx

select cpu_count from sys.dm_os_sys_info

select value_in_use from sys.configurations where name = 'max degree of parallelism'

If also not familiar lookup WITH ROLLUP, its another one to look at along with WITH CUBE, both produce different outputs so need to ensure you choose the right one,...

Thats becuase you probably wont have anything that is equal to the date being used in the where clause

You really need to do an >= < where clause

SELECT [Invoice_Date]

,[UserId]

,[Customer]

,[InvoiceNo]

,[Description]

,[Pack]

,[PIP_Code]

,[Class]

,[Major_Grp]

,[Invoice_Val]

,[Cost_Pr]

,[Quantity]

FROM [Telesales].[dbo].[Sales]

Where...

The log will show the spid and timestamp that the recovery model changed.

You can then correllate that back to the default trace, as long as the data is still in...

Might want to switch your caps lock off

No need to shout.

Again sys.master_files, filter out all your log files (data_space_id = 0) and...

you cant split a data or log file to multiple files.

data and log files are always seperate, you cant have an data file which is your log file, unless for...