If these are dates coming from Excel, be careful if your data has very old dates.

Excel sees the years 1900 as a leap year (a legacy from Lotus 1-2-3), so...

You can use snapshot isolation after you enable it for that database, but you will need to set the isolation level to snapshot on each connection or stored procedure that...

homebrew01 (1/8/2014)

---

I tried something like this, and the temp table does contain the new MemID values, but get the error " Must declare the scalar variable "@MemberID"." ...

I don't really see anything wrong with your logic.

Have you verified that there actually are updates being performed? Are there any other triggers on this table? Could the...

homebrew01 (1/8/2014)

---

We have a web application in which a member can sign up, get a member ID, then that ID populates 6 various tables. That is fine 1 at...

Is there some reason why you can't do that...

born2achieve (1/3/2014)

---

Hi Michael,

Thanks what i did already

declare @MyData table (Id int not null, StartDate datetime not null, EndDate datetime not null )

insert into @MyData

select 101 as Id,'2014-01-14 13:30:00.000' as...

born2achieve (1/3/2014)

---

Hi Michael,

Thanks for your response.

On your sample you are hardcoding the Currdate

set @CurrDate = '2014-01-15 23:59:59.997'

But i wanted to check the getdate() falls b/w 1st to 15th...

homebrew01 (1/3/2014)

---

I usually dump the files into a table so I can more easily query them, based on the file date and when an event occurred:

SELECT * INTO Trace_20131229

FROM fn_trace_gettable('F:\TraceFiles\MyTrace_x131123_x2330_54.trc',...

homebrew01 (1/3/2014)

---

I have a server side trace running, and curious how long running jobs are logged. If the trace starts at 1:00 am and is full at 10:00 am (Trace_1.trc)...

You can run a query on the source server to get the filename:

select top 1

bs.database_name,

bmf.physical_device_name

from

msdb.dbo.backupset as bs

inner join

msdb.dbo.backupmediafamily as bmf

on bmf.media_set_id = bs.media_set_id

where

bs.database_name = 'master'

and bs.type = 'D'

order by

bs.backup_start_date desc

database_name...

This query seems to do what you want with the first result with the date before the 16th of the month and the next result for on or after the...

Here is another method using the PARSENAME function to split the elements when you have 4 or fewer elements.

-- Parse up to 4 '.' delimited elements and sort by numeric...

Have you tried using the command line version of WinRAR, so that it does not generate an error dialog box?

Using the WinRAR Command-line tools in Windows

http://comptb.cects.com/2503-using-the-winrar-command-line-tools-in-windows

Markus (1/2/2014)

---

Michael Valentine Jones (1/2/2014)

---

SQL Server 2014 In-Memory-OLTP Tables do not support identity columns or foreign keys, so that puts them well outside what I would be willing to accept...