It will work on a nullable column. Meaning that if you don't supply a value for that column it will use the default. You can also include that column in...

Or just use the date datatype.

declare @MyDate date = CURRENT_TIMESTAMP

select @MyDate

Well then help me understand your matching criteria...

There may or may not be a period date (TranPeriod). When there is a matching period date for both transaction types and the...

Part of what Wayne was saying is that in your sample data you create a temp table implicitly and every single column is an int. You said something about a...

"Snapshot isolation transaction failed accessing database 'xxx' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation."

And I'm not allowed to use ALTER DATABASE...

jeetendrajaiswal2000 (1/23/2012)

---

Try this query. It will work.

SELECT f.ForumId,f.Title,f.Intro,count(t.ThreadId) AS [Thread Count],count(p.PostId) AS [Post Count] FROM

Forum f inner join Thread t on f.ForumID = t.ForumID

inner join Post p on...

But what about duplicate or missing data? It is not just precision that is affected by dirty reads. If you are...

You will need to make the DateTime column be not null and add a default constraint for that column of GetDate()

First of all read this article. http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

It is NOT a magic go faster pill and is fraught with all kinds of issues.

Secondly, If you just need to insert data a...

Hi and welcome to SSC. It was good that you included ddl and sample data. However, you clearly didn't test what you posted because the syntax was wrong all over...

Ok so do you need to have the table in Access detached from SQL server or can you create a link table via ODBC?

pwalter83 (1/23/2012)

---

Hi,

I am new to MS Access (2007) and have a requirement to add an existing table to MS- Access database. There are 4 tables already associated with the database...

Pretty sparse on details. Does this help?

SELECT AssetEvents.UserIdCreated,

COUNT (AssetEvents.TimeCreated) AS [Total Asset]

FROM AssetEvents

WHERE AssetEvents.TimeCreated between '1/1/2012' and '1/7/2012'

GROUP BY AssetEvents.UserIdCreated

union all

SELECT InventoryEvents.UserIdCreated,

COUNT (InventoryEvents.TimeCreated) AS [Total Inventory]

FROM InventoryEvents

WHERE InventoryEvents.TimeCreated between '1/1/2012'...

Forgot to mention that to post code you...

Hi and welcome to SSC. It is nearly impossible for anybody to really understand your problem the way you have it posted. Typically what you should post is ddl (create...