Hi...

Assuming that each date returns just one row this should work:

declare @field1 varchar(128), @field2 varchar(128), @field3 varchar(128), @field4 varchar(128), @field5 varchar(128), @field6 varchar(128)

select @field1 = case when field1 = 'jim'...

Lynn Pettis (3/21/2008)

---

Just curious, but what is wrong with the following code:

update dbo.TeamBalance set

Balance = Balance - @Purchase

where

TeamId = @TeamId

...

I see. The same still applies, so yes it would work fine as you've described in the example.

Regarding the error handling, to release the locks you'd have to make...

Todd Biggins (3/20/2008)

---

I get stuck on how to conditionally format the calculations of subtotals. With table format, I can pick and choose on each column.

If you can tell...

znkin (3/21/2008)

---

Thanks for the reply...

Instead of doing an Update query if I write a insert query will the same work. And also do I need to ensure some kind of...

Jonathan Devine (3/20/2008)

---

ah ok, that makes sense then, thanks for the response.

In that case is there any parameter that can be supplied to a 'field1 =" clause so that it...

what error message are you getting in event viewer?

dakshinamurthy (3/20/2008)

---

Hi,

If i would like to know, whether a particular DB is online or has gone to a suspect mode, can i use the following query, so that once the...

How did you change the service account? You should change the service account using SQL Server Configuration Manager because doing so will ensure that the new account is given...

stuartreid73 (3/20/2008)

---

We have about 40 locations worldwide, with a typical data size of about 200 GB per location, with some up to 2 TB. Most sites have 1024 to 1536...

Or you could enable C2 auditing - but then you're auditing more than just ddl commands.

From my experience I've found there's very little difference between the two when using a low number of rows...but when using thousands or tens of thousands of rows I've found...

Oops....I'm so used to using SQL 2005 I never bother to think that other's might be using SQL 2000. Use master.dbo.sysaltfiles instead of sys.master_files. You'll just need to...

Hi El, not sure why I went for the sp_foreachdb method.

Try this instead....

select db_name(database_id) as databasename

, @@version as version

, @@servername as servername

, databasepropertyex(db_name(database_id), 'IsPublished') as IsPublished

, str(convert(dec(15),sum(size))* (select convert(varchar(11),low) from...

Sounds like you've got a seriously fragmented table there. How often do you backup your log? Backing it up more frequently will keep the log files trim during...