Viewing 15 posts - 91 through 105 (of 294 total)
I have the following constraint (along with others that are similar) on a table:
ALTER TABLE [dbo].[Ship_Contract_Line]
WITH NOCHECK ADD CONSTRAINT
[XFKCT_Ship_Contract_Line_Delivery_Point_Code]
FOREIGN KEY([Party_Account_No], [Delivery_Point_Code])
REFERENCES [dbo].[Delivery_Point] ([Party_Account_No],...
August 4, 2008 at 7:39 am
rbarryyoung (8/2/2008)
There is no security in obscurity.Post it.
OK
/*
Used to generate Delete scripts. It does NOT run them.
You need to copy the output of this script to a new window...
August 4, 2008 at 3:05 am
I have no idea if this will work, but here's an attempt at cut 'n' paste
It didn't. How do I attach file? ...
Hmm, xsl files are not...
July 30, 2008 at 5:28 am
Chris Morris (7/25/2008)
... which seems a little simpler and easier to follow (at least to me, on a friday) because the CASE is in the SELECT rather than the JOINs.
Oh...
July 25, 2008 at 4:56 am
Greg Snidow (7/24/2008)
I think this fixes your original question, which was the CASE in the WHERE clause.
It does indeed Greg, thanks very much. Bl*&%y syntax! 😀 Kudos to, to...
July 25, 2008 at 3:40 am
You know what it's like, you post a question and then while reflecting on your problem, you solve it having a smoke...
This works, but I still don't like it.
select distinct...
July 24, 2008 at 11:52 am
Mike
First of all, congratulations on earning your MVP status. Reading the news prompted me to look this article up to help me with an address validation task I have...
July 2, 2008 at 11:14 am
Insert this into the top of the script
--===== Conditionally drop
IF OBJECT_ID('dbo.Tally') IS NOT NULL
DROP TABLE...
June 27, 2008 at 11:38 am
zxn001 (6/27/2008)
Of the solutions printed in the article, his had the fastest computing time.Please excuse my ignorance, but what is wrong with while loops?
nothing per se, but run this in...
June 27, 2008 at 10:07 am
The link is dead, but you can still find the article here. http://www.sqlservercentral.com/articles/Miscellaneous/2586/%5B/url%5D
Dave J
June 24, 2008 at 4:52 am
SET DATEFORMAT YMD
declare @datestring varchar(20)
set @datestring = '20080610014222'
select cast(
substring(@datestring, 1,4) + '/' +
...
June 12, 2008 at 11:49 am
Timothy Ford (5/29/2008)
We're right around $4.15 usg here. I don't know how our gallons compare to yours. I thought you were using litres over there.
We do, but as...
May 30, 2008 at 8:47 am
I know, should have put another smiley or two in. 🙂
Looking on the web, Am I right in saying its now about $5 a gallon? That's around 2.53 GBP!...
May 29, 2008 at 12:09 pm
I've not finished the article yet but I have just read this:
"(with gasoline in the United States reaching an insane price of $1.80 per gallon)"
In the UK I am paying...
May 29, 2008 at 9:30 am
Yes. Apologies, it's a colloquial expression meaning 'Spot on'. And the word Rooster is apparently an Americanism for the animal featured on my Avatar.
1772, from roost...
May 23, 2008 at 11:12 am
Viewing 15 posts - 91 through 105 (of 294 total)