Viewing 15 posts - 19,336 through 19,350 (of 26,490 total)
Do you have access to teh AdventureWorks sample database? Can you use one or more of the tables there to formulate a similar problem?
August 6, 2009 at 11:37 am
madhu (8/6/2009)
Hi,We have sql server 2005 EE and SQL server 2005 SE. I want restore a database from Enterprise edition to Standard edition.
Is this possible?
As far as I am aware,...
August 6, 2009 at 11:33 am
Okay, now we are actually getting somewhere. How about providing us with the actual problem you are trying to resolve? Rather than asking piecemeal questions, put the whole...
August 6, 2009 at 11:15 am
hugh.hemington (8/5/2009)
August 6, 2009 at 10:54 am
emily (8/6/2009)
Lynn Pettis (8/6/2009)
August 6, 2009 at 10:46 am
Swamy Magam (8/6/2009)
Thank u friend. my requirement is I want show batch wise Empnos in grid. this is my Requirement.
This may be your requirement, but for every requirement, there...
August 6, 2009 at 10:32 am
You have provided the DDL for the table and sample data. The only thing I see missing that would help me is the expected results based on the sample...
August 6, 2009 at 9:59 am
A little confused as to what you are asking. Are you wanting the to return the last day of a month based on the current or given date, such...
August 6, 2009 at 9:49 am
donato1026 (8/5/2009)
Lynn Pettis (8/5/2009)
That's the difference between a community (SSC) and a forum (all the others).Thanks for the compliment (from all of us) and the feedback.
That's a very good point....
August 5, 2009 at 2:43 pm
That's the difference between a community (SSC) and a forum (all the others).
Thanks for the compliment (from all of us) and the feedback.
August 5, 2009 at 1:47 pm
Mike Hinds (8/5/2009)
Richard M (8/5/2009)
... you know you can Edit your own posts, right? 😎I saw the button and used it, but didn't get a button.
Ignorance is bliss.
The...
August 5, 2009 at 1:44 pm
I think I know what you are asking but it would help if you would provide the DDL for your tables, sample data for the tables, and expected results when...
August 5, 2009 at 12:50 pm
donato1026 (8/5/2009)
else ((ABS(SUM(isnull(hmss.CREDIT_MEMOS, 0)) + SUM(isnull(hmss.EVEN_EXCHANGE, 0))))/(ABS(SUM(isnull(hmss.CREDIT_MEMOS, 0))...
August 5, 2009 at 12:44 pm
homebrew01 (8/5/2009)
Query 1:
Raw data:
[font="Courier New"]
Date Emp#LastFirstHours
8-1-2009 17SmithJohn2.3
8-1-2009 17SmithJohn1.6
8-1-2009 17SmithJohn3.3
8-1-2009 24Jonesmary1.7
8-1-2009 24Jonesmary4.2
8-1-2009 24Jonesmary1.1[/font]
select date, Last_name, First_name,...
August 5, 2009 at 11:56 am
Mitch2007 (8/5/2009)
thanks for the reply and forgive my delay but things here have been swamped.
I ran your...
August 5, 2009 at 11:16 am
Viewing 15 posts - 19,336 through 19,350 (of 26,490 total)