Sign Up! | Tags | Domains | Statistics | Options | Advanced Search
|
Sign Up! | Tags | Domains | Statistics | Options | Advanced Search |
asp.net » Mark Smith - Sep 29, 2008
What have I been up to? It's been a while since I last wrote a blog on here, so what have I been up to? Well, it's been a very busy time for me as along with the birth of our first child, I've been working on a few …
Also tagged: asp net, community news, general software development, net faq
asp.net » Mark Smith - Sep 29, 2008
I recently had a situation where I needed to highlight the ids in a given range which were out of sequence and not part of a range (i.e. 1,2,3,4,6, would show that 5 was missing). Fortunately, I found that this was …
asp.net » Hoster Poster - Sep 29, 2008
If you haven't heard, the new Web SKU is a special, low-priced version of Windows that is focused exclusively on Internet-based Web serving. We've added a lot of new features and support for hardware compared to the …
Also tagged: iis
asp.net » Stephen Songer - Sep 29, 2008
Ran into problems trying to deploy my first web application to use a SQL Server Reporting Services report. I created a RDLC file and bound my report viewer control to an object data source. Worked fine on my local …
Also tagged: asp net
asp.net » Stephen Songer - Sep 29, 2008
Got the performance reports up and running and everything seemed good. Then I started getting "Difference of two datetime columns caused overflow at runtime." errors when trying to run the reports. Turns out it's a …
asp.net » Stephen Songer - Sep 29, 2008
Found a niffy little tool for some basic SQL Server reporting. Microsoft has some dashboard reports that work with SQL Server 2005 SP2. You can download it here …
asp.net » Stephen Songer - Sep 29, 2008
Found out that my database maintenance plan had failed the past several days and wondered why I had not received email that the job failed. When I checked the database error log I found the following error: An attempt …
asp.net » Stephen Songer - Sep 29, 2008
Discovered the power of common table expressions today. I needed to create an hierarchy of GL accounts. My table was an adjancey list which made the CTE very easy. CTEs are new to SQL Server 2005. WITH …
asp.net » Stephen Songer - Sep 29, 2008
Sometimes I've needed to do "cross tab" queries -- a throwback to a built-in MS Access query type. In SQL Server 2005 there's a built in way to do it using the pivot function. Very easy and very useful …
asp.net » Stephen Songer - Sep 29, 2008
Some databases store longer text fields as binary. To retrieve the text in a varchar field, do the following: CAST(CONVERT(varbinary(max),velive.dbo.part_binary.bits) AS varchar(max)) velive.dbo.part_binary = Table …