Viewing 15 posts - 391 through 405 (of 1,183 total)
bugop (4/7/2010)
Thanks for the responces..but at least a suggestion would have been ok.
Putting what everyone else has said aside, does this help....
If you are the type of person who learns...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 7, 2010 at 2:32 pm
shannonjk (4/7/2010)
Recently my company migrated from a SQL 2005 server to a SQL 2008 server (both are up and running concurrently on different machines). Reporting services and its...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 7, 2010 at 2:17 pm
That depends on the "A"'s definition.
I'm a SQL Database ArchitecAdminAlyst 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 7, 2010 at 12:41 pm
I'm guessing that there is a puddle of pee under huslayer's desk right now... :hehe:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 7, 2010 at 9:35 am
test for numeric:
ISNUMERIC(LEFT(yourFieldName,1)) = 1
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 7, 2010 at 9:32 am
timzepin (4/6/2010)
screwed up again...sorry. The version I'm using SQL Server 2008
😀
http://www.sqlservercentral.com/Forums/Forum392-1.aspx
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 6, 2010 at 12:45 pm
Which version of SQL are you using? You've posted this in the wrong forum and may not get the proper advice.
If you're using 2005 or 2008 look at the PIVOT...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 6, 2010 at 11:53 am
george.greiner (4/6/2010)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 6, 2010 at 11:08 am
This is a real shot in the dark since you seem to not have much say in the actual data collection process, but could you record the employee's "number" instead...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 5, 2010 at 8:58 am
Can you post what you've tried?
This appears to be a homework or study question. And most of us here DONT have a problem helping, we generally don't want to do...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 1, 2010 at 1:43 pm
Yep, the batch continues on until it hits a 'GO' statement
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 1, 2010 at 1:36 pm
Post your proc here. we can't debug what we can't see. 😀
AND
Read this ...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 1, 2010 at 1:25 pm
Miles Neale (3/31/2010)
First of all what you have done is interesting and will work and very creative. Job well done.
There is however an alternative available that you might want...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 31, 2010 at 1:28 pm
Jeff Moden (3/30/2010)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 30, 2010 at 2:05 pm
SELECT ID FROM PART WHERE CHARINDEX('_',ID) > 0
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 30, 2010 at 12:59 pm
Viewing 15 posts - 391 through 405 (of 1,183 total)