I like the CASE idea... will this work for you?

DECLARE @now TIME

SET @now = GETDATE()

SELECT CASE WHEN @now BETWEEN CONVERT(TIME,'07:00:00') AND CONVERT(TIME,'15:00:00') THEN 'First Shift'

WHEN @now BETWEEN CONVERT(TIME,'15:00:00') AND CONVERT(TIME,'23:00:00')...

Thank you Gail!

It's because of the xml namespace declaration. Try using WITH XMLNAMESPACE to locate the node:

declare @XmlData xml

declare @xml table (xmldocument xml)

declare @NewValue varchar(50)

set @NewValue =...

Lowell (11/11/2011)

---

ORDER BY newid() is the way to get randomized data.

you've got to do a few things: first, extract the domain from the urls...in my example, as long is...

If the list of top-level domains in your table is small, you can do something like this easily:

select top 1 ID, URL from URL_LIST where URL like '%google.com%' order by...

It sounds like your Windows Authenticated login has connectivity permissions, but is not mapped to any user databases. Go the the Properties of the login, User Mapping, and check...

Then add a YTD column to the base table and create insert/update/delete triggers to adjust the YTD data when values are added, updated, and deleted.

How would this work in your view?

select p.Year, p.Month, p.Account,p.Amount,

case when Month=(select top 1 Month from Postings order by Month)

then Amount

else (select SUM(Amount) from Postings where Month <= p.Month)

end...

Actually this looks like what you need:

http://www.mssqltips.com/sqlservertip/1629/determine-free-space-consumed-space-and-total-space-allocated-for-sql-server-databases/%5B/url%5D

I just created the usp_Sizing sproc and it indeed returns a Free Space % column, along with lots of other statistics.

I use both of these:

SELECT DB_NAME(database_id) AS DatabaseName,

Name AS Logical_Name,

Physical_Name, (size*8)/1024 SizeMB

FROM sys.master_files

order by SizeMB desc

and

exec sp_MSforeachdb @command1='use [?] exec sp_spaceused'

go

If you put SQL Server 2005 Express on their PCs, you could have them run a Windows batch file that calls a SQLCMD (or OSQL) command to run the query....

Indexing tables is more of an art than a formula sometimes 🙂 Off the top of my head I'm thinking that the index has not been used enough to...

You may be able to use the ISNULL function to just clean the data temporarily before pivoting:

http://msdn.microsoft.com/en-us/library/ms184325.aspx

That's not any more details :). I'll have to assume that you have an image FILE on a disk. You can combine a select, insert, or update query...

Hi, is the IMAGE data on a separate SQL Server instance? Is it contained in a database or a flat file? Need more details...