Viewing 15 posts - 3,931 through 3,945 (of 4,080 total)
No heretical rebuttals from me. I just want to know if they are using that column to enforce a sequence.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 7, 2008 at 10:55 am
Barkingdog... can you please explain WHY you want to reuse those numbers? What you want to do isn't impossible, although you couldn't designate the column to be...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 5, 2008 at 4:55 pm
Create a concatenation user function and use it in a summary query.
Here's a great write up by Jeff Moden. Let me know if you have...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 5, 2008 at 4:47 pm
Just brainstorming...
Using views to simply alter fieldnames costs very little. Ever think about having a separate view for each project? I've never done this in...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 5, 2008 at 11:21 am
For an exhaustive discussion on a similar topic (Finding the next Sunday, regardless of datefirst setting) take a look here:
http://www.sqlservercentral.com/Forums/Topic606669-338-1.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 5, 2008 at 9:58 am
The UNC is a good idea. I have often seen people trying to BCP files from drives on their personal PC rather than the server. (I've...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 4, 2008 at 5:28 pm
Think about doing a query to list names contain more than two strings (more than one space '% % %'). You will want to change those individually. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 4, 2008 at 5:12 pm
SELECT a_id FROM dbo.a WHERE a_id IN (SELECT a_id FROM dbo.b)
This is yet another reason why it is a good practice to always qualify your column names to be specific...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 4, 2008 at 2:57 pm
Dear Joe,
Two different views or tables make this a totally different problem with a totally different solution. Are you doing this project as a class assignment by...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 4, 2008 at 2:44 pm
What if I have a table which has multiple columns and those columns contain the dates and I wish to merge those dates columns into one new column? Do I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 4, 2008 at 9:46 am
It's a small lake....
Besides, there's just something so aesthetically satisfying about watching a trebuchet fling (pork chops, tennis balls, cans of vienna sausage, cats, volkswagens, whatever) 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 3, 2008 at 4:29 pm
Joe,
My error and my apologies. I thought there was a link. I must have been hallucinating.
Here is the link in MS-Help.
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/24ba54fc-98f7-4d35-8881-b5158aac1d66.htm
Seth,
Thanks for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 3, 2008 at 2:45 pm
Aw rats.....
(putting down borrowed pile of pork chops)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 3, 2008 at 2:03 pm
Why not just declare a second table variable? It's a trivial cut-and-paste and will start all over again with the identity values. If you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 3, 2008 at 1:58 pm
I'm not laughing or mad, Joe. But you actually had two questions. Steveb already gave you a link to the UNPIVOT operation, which has an example...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 3, 2008 at 1:53 pm
Viewing 15 posts - 3,931 through 3,945 (of 4,080 total)