Viewing 15 posts - 1,471 through 1,485 (of 3,221 total)
dlam 18073 (2/2/2011)
if I put the 2nd procedure into 1st, how to know when the last...
February 3, 2011 at 8:05 am
After a search of previous forum posts (under the title "Bills of Materials") I ran across this reference, posted by Jeff Moden at:
http://www.sqlservercentral.com/Forums/Topic414386-169-1.aspx
Doing what Jeff recommended in the above...
February 3, 2011 at 7:10 am
Do not know if you are inserting one row at a time, or as a batch, that said you may want to examine using within your update/insert SP, a
IF...
February 2, 2011 at 6:55 pm
In both procedures I would use the TRY CATCH technique, first to report any errors, and secondly if the first SP generates an error the 2nd SP would not be...
February 2, 2011 at 6:42 pm
This is where I am unsure how to structure the database. I could have an ApprovedByID and ApprovedDate in the Expense Table or Invoice Table, but that would only allow...
February 2, 2011 at 6:26 pm
User Table
ID --Why such a generic term is it the user's Id or?
User Name
User Type -- this could be a limited standardized item - kept in a lookup...
February 2, 2011 at 5:07 pm
Wondering if any denizens of the thread can help this OP, as it is beyond my limited capabilities.
http://www.sqlservercentral.com/Forums/Topic1056947-149-1.aspx?Update=1
February 2, 2011 at 11:00 am
pwalter83
I have posted your code in a easily usable format for others to assist you. To be honest with you my knowledge is not that vast and I do...
February 2, 2011 at 10:52 am
PSB (2/1/2011)
CAn you give an example ?
Go here :
http://technet.microsoft.com/en-us/library/ms187928(SQL.90).aspx
February 1, 2011 at 7:43 pm
I have had the unique experience of moving from a team lead (4 programmers) actively engaged in programming, writing software requirements and test plan documents. It was enjoyable as...
February 1, 2011 at 7:31 pm
To help those who want to help you with a tested solution, please post table definition(s), sample data and required results. You can do this easily, just click on...
February 1, 2011 at 11:37 am
Tom.Thomson (2/1/2011)
Andrew Watson-478275 (2/1/2011)
Koen (da-zero) (2/1/2011)
A bit easy though, as you can guess the answer just by looking at the names of the DMV. 🙂
I'm obviously too suspicious. I...
February 1, 2011 at 6:57 am
sunder.bugatha (1/31/2011)
It doesn't work for me..temp table #OOPS is not getting created.
The original code I posted, if it completed successfully would not have created the temp table #OOPS. Now...
February 1, 2011 at 6:37 am
Just as a wild thought - you could use something like this:
BEGIN TRY
EXECUTE ('restore verifyonly from disk=''C:orthwind.bak''')
END TRY
BEGIN CATCH
SELECT
...
January 31, 2011 at 7:39 pm
Have you tried.
1. In a NON production db opened the table with SSMS ... click in the data type column for the row with the address type, select CHAR(40)
Now...
January 30, 2011 at 5:20 pm
Viewing 15 posts - 1,471 through 1,485 (of 3,221 total)