Viewing 15 posts - 2,206 through 2,220 (of 5,502 total)
What would also help if you simply could post the full error message. It usually tells the table and primary key that's violated.
And I don't think it's an issue with...
January 5, 2011 at 3:49 am
joshtheflame (1/4/2011)
🙂 Lutz I want 'Holiday' to appear in the column value along with the header 'Sunday' actually in place of '0' 🙂
Oh, I finally got it...
In that case you'd...
January 5, 2011 at 3:15 am
AndrewSQLDBA (1/4/2011)
Thanks LutzThat was it, worked perfectly. I did have to modify the length from 11 to 10.
Andrew SQLDBA
*Ouch* Can't even count such a small string manually anymore. Is that...
January 4, 2011 at 3:31 pm
Use a subquery to count the occurrence of Address fields and link that back to your original table for Address values with count > 1.
January 4, 2011 at 3:13 pm
Assuming you can ensure the data structure you could use omething like LEFT(StringValue,LEN(StringValue)-11)
Both, 'large.jpg' and 'small.jpg' are 10 char long +1 char for the minus sign.
January 4, 2011 at 3:09 pm
Jonathan Kehayias (1/4/2011)
January 4, 2011 at 2:58 pm
If there are values within a column containing commas, how do you know what values belong to one column and what values belong to the next/previous one?
Is there any chance...
January 4, 2011 at 2:44 pm
GSquared (1/4/2011)
...
He basically asserted that there appears to be a geographic concentration on the subject of eggregious copyright infringement in the world of coding. He merely said that a...
January 4, 2011 at 1:26 pm
Jeff Moden (1/4/2011)
...
As a bit of a side bar, I'm constantly amazed at how some folks apparently just don't give a rat's patooti as to how their code looks and...
January 4, 2011 at 12:48 pm
joshtheflame (1/4/2011)
Thank you for appreciating the way I've posted my data. Actually I've observed that ppl do not bother to provide scripts which is ethically wrong. Its the place where...
January 4, 2011 at 11:36 am
Anil Maharjan (1/4/2011)
Well i am just wondering do this similar type of script works for the complex type node too for xml file.
which we can find the XML...
January 4, 2011 at 9:53 am
kevin4u06 (1/4/2011)
thanks got it......is there any other way instead of a single select statement.....which is beter than the queries posted in the challenge.
to quote from a previous post:
...there are situations...
January 4, 2011 at 9:38 am
kevin4u06 (1/4/2011)
they haven't yet....i need that solution....cause im dealing with the same scenario right now....
Trust me,they have. 😉
January 4, 2011 at 9:19 am
Viewing 15 posts - 2,206 through 2,220 (of 5,502 total)