Viewing 15 posts - 13,666 through 13,680 (of 13,680 total)
Wow, that's a busy server – Terminal Services, SQL Server, C# development, SQL Server development and SQL Server admin!
As EM and QA work well from other PCs/servers, why don't you just...
April 27, 2004 at 11:38 pm
I think you are summing across the entire resultset – so you will get the same numbers every time. You need something more along these lines:
SELECT Merchant.MerchantId, Merchant.MerchantName, DefinedPaymentDistribution.DistributionName, PaymentType.PaymentTypeName,
April 27, 2004 at 11:16 pm
Check out this link – it may help you out.
http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp
April 21, 2004 at 1:13 am
There's probably a really elegant way of doing this. This isn't it, but it works
select '$' + convert(varchar(30), cast(amount as money),1) as Formatted_Cash ...
replacing 'amount' with...
April 18, 2004 at 11:48 pm
I think I would go down the multiple job steps route. If any of the jobs fails, you'll be able to identify more quickly exactly where the process is going...
April 15, 2004 at 1:34 am
This will get you some of the way - it works in the current database, so you'd need to iterate round all the dbs you need to check.
SELECT table_catalog, table_name,...
April 15, 2004 at 1:22 am
Not sure whether you would want to do this because of data storage considerations, but if this is a query which you execute regularly, could you add a new calculated...
March 30, 2004 at 5:14 pm
Just a small typo in this, should be
select id, convert(varchar(10), date, 120) from temp
March 21, 2004 at 11:36 pm
Ace - that will be filed in my 'Useful SQL Utilities' folder, thanks.
March 15, 2004 at 5:03 pm
Thanks v much, that's nearly exactly what I need. But the 'Name' field that is returned appears to be the logical file name corresponding with the data/log file selected (and...
March 15, 2004 at 3:46 pm
Noeld – please explain why you should not cast a datetime as int. I have used
cast(cast(GETDATE() - 0.5 as integer) as DateTime)
with apparent success. Just interested ... the...
February 25, 2004 at 4:15 pm
I have a similar related question. I have a script which uses a cursor to update a large number of records - is there any way of indicating progress (10...
January 26, 2004 at 3:34 pm
Alternatively, after performing the delete, go into EM, design table and set the Identity Seed of the primary key to something else (eg 2) and click on Save. Then set...
December 15, 2003 at 9:09 pm
Just in case ...
Casting my mind back to the SP3 install, where the first exe you run just unzips files (and doesn't actually do the install).
Look for a setup.bat or...
December 7, 2003 at 10:58 pm
Agree with previous post. Also presume you want to write a different message to the log if the main transaction fails? Perhaps it would be better to have one log...
December 7, 2003 at 10:43 pm
Viewing 15 posts - 13,666 through 13,680 (of 13,680 total)