Viewing 15 posts - 13,186 through 13,200 (of 15,381 total)
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...
January 23, 2012 at 3:05 pm
Or just use the date datatype.
declare @MyDate date = CURRENT_TIMESTAMP
select @MyDate
January 23, 2012 at 2:23 pm
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...
January 23, 2012 at 2:09 pm
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...
January 23, 2012 at 2:01 pm
"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...
January 23, 2012 at 1:45 pm
jeetendrajaiswal2000 (1/23/2012)
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...
January 23, 2012 at 12:33 pm
jcb (1/23/2012)
3. No need for precision, dirty reads are allowed.
But what about duplicate or missing data? It is not just precision that is affected by dirty reads. If you are...
January 23, 2012 at 11:13 am
You will need to make the DateTime column be not null and add a default constraint for that column of GetDate()
January 23, 2012 at 11:00 am
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...
January 23, 2012 at 10:28 am
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...
January 23, 2012 at 9:16 am
Ok so do you need to have the table in Access detached from SQL server or can you create a link table via ODBC?
January 23, 2012 at 8:25 am
pwalter83 (1/23/2012)
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...
January 23, 2012 at 8:17 am
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'...
January 20, 2012 at 3:26 pm
p.s - sorry about the poor formatting - not sure how I can make it better? copy/pasted into notepad tidies it up
Forgot to mention that to post code you...
January 20, 2012 at 9:42 am
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...
January 20, 2012 at 9:40 am
Viewing 15 posts - 13,186 through 13,200 (of 15,381 total)