Viewing 15 posts - 13,816 through 13,830 (of 13,838 total)
What error message do you get when the browser won't connect?
Can you still ping external addresses?
If you stop the SQL Server service, does it fix the problem ... are you...
May 11, 2004 at 1:54 am
In the interests of referential integrity, you'll probably need two delete statements. The first will delete the relevant invoice lines and the second their corresponding header records.
(Not sure quite why...
May 10, 2004 at 11:06 pm
You need to use aliases ... effectively creating two instances of the TeamList table and then using them as if you had two separate (but identical) tables ...
select team1.teamname,...
May 9, 2004 at 10:53 pm
Query Analyzer (one of the SQL Server client tools) is the standard development environment for views, stored procs etc.
Not so sure that many guys in this forum think that EM...
May 9, 2004 at 10:43 pm
If the answer to Jeff's question is that column 1 is unique and ascending (as it appears from your example), I still can't think of a quick way of doing this ......
May 6, 2004 at 1:13 am
In my opinion, it would be much tidier and easier to manage all of this if you keep all of the data in SQL Server rather than mixing your db...
May 5, 2004 at 9:29 pm
Good question and one which I've considered in the past. Seems to me that you have to limit direct access to the database (keep the only authorised users / roles...
May 4, 2004 at 1:27 am
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
Viewing 15 posts - 13,816 through 13,830 (of 13,838 total)