Viewing 15 posts - 11,401 through 11,415 (of 26,486 total)
Right click on the principal database, click on properties. Select the Mirroring page and look at the Operating Mode. What is selected there?
June 11, 2012 at 12:02 pm
twdavis-893252 (6/11/2012)
SELECT INV_ITEM_ID,SUM(QTY_AVAILABLE)AS QTY,PRODUCT_ID FROM PS_PRODKIT_AVL_VW
WHERE PRODUCT_ID IN('10-5266SP','10-3012SP','10-5202SP','10-2012SP','10-3033SP','10-5210SP','10-2066SP','10-3066SP','10-5212SP')
GROUP BY INV_ITEM_ID,PRODUCT_ID
ORDER BY PRODUCT_ID,QTY,INV_ITEM_ID
that gives this result:
INV_ITEM_IDQTYPRODUCT_ID
10-2002204.0000000000000010-2012SP
10-2005256.0000000000000010-2012SP
10-2009266.0000000000000010-2012SP
10-2028268.0000000000000010-2012SP
10-2024286.0000000000000010-2012SP
10-20BRQ287.0000000000000010-2012SP
10-2012311.0000000000000010-2012SP
10-20BRK72.0000000000000010-2066SP
10-206773.0000000000000010-2066SP
10-2066108.0000000000000010-2066SP
10-2005256.0000000000000010-2066SP
10-2009266.0000000000000010-2066SP
10-2028268.0000000000000010-2066SP
10-2002408.0000000000000010-2066SP
10-3024103.0000000000000010-3012SP
10-3012206.0000000000000010-3012SP
10-3002206.5000000000000010-3012SP
10-3009221.0000000000000010-3012SP
10-3005262.0000000000000010-3012SP
10-3028303.0000000000000010-3012SP
10-303359.0000000000000010-3033SP
10-303493.0000000000000010-3033SP
10-30BRT101.0000000000000010-3033SP
10-3009221.0000000000000010-3033SP
10-3005262.0000000000000010-3033SP
10-3028303.0000000000000010-3033SP
10-3002413.0000000000000010-3033SP
10-30BRK90.0000000000000010-3066SP
10-306695.0000000000000010-3066SP
10-3067132.0000000000000010-3066SP
10-3002206.5000000000000010-3066SP
10-3009221.0000000000000010-3066SP
10-3005262.0000000000000010-3066SP
10-3028303.0000000000000010-3066SP
10-5205317.0000000000000010-5202SP
10-52BRQ465.0000000000000010-5202SP
10-5212483.0000000000000010-5202SP
10-5224499.0000000000000010-5202SP
10-5202737.0000000000000010-5202SP
10-5210156.0000000000000010-5210SP
10-5209340.0000000000000010-5210SP
10-5202368.5000000000000010-5210SP
10-5228397.0000000000000010-5210SP
10-52BRQ465.0000000000000010-5210SP
10-5212483.0000000000000010-5210SP
10-5224499.0000000000000010-5210SP
10-52BRQ465.0000000000000010-5212SP
10-5212483.0000000000000010-5212SP
10-5224499.0000000000000010-5212SP
10-52660.0000000000000010-5266SP
10-52BRK1.0000000000000010-5266SP
10-526718.0000000000000010-5266SP
10-5210156.0000000000000010-5266SP
10-5209340.0000000000000010-5266SP
10-5202368.5000000000000010-5266SP
10-5228397.0000000000000010-5266SP
What I want to see is just the Minimal qty value for...
June 11, 2012 at 11:29 am
kond.mohan (6/11/2012)
I HAVE TO CREATE THE REPORT
I HAVE CALCULATE THE INCREMENTAL /DECREMENTAL (JOINEE/EXIT) EMPLOYES IN SQL SERVER
MY TABLE STRUCTURE IS
EID ...
June 11, 2012 at 9:55 am
Not really enough information to provide a good answer, so how about a shot in the dark about what the problem could be.
From the looks of it, you may be...
June 11, 2012 at 9:33 am
anthony.green (6/11/2012)
Nope, SQL wont allow files to be on network drives, they have to be on local storage only.
Don't think that is completely true. If I remember correctly, there...
June 11, 2012 at 9:26 am
How about Mr. Celko? I don't know why, but everytime I read one of his posts my blood pressure rises about 20 points.
June 11, 2012 at 9:22 am
Prasad.N (6/11/2012)
I have doubt Recording SP's i have to use previous developed sp in my present sp. here previous sp returns 4 tables but i want 2nd table only. Example...
June 11, 2012 at 9:16 am
Using the formatted data from Lowell's post (thank you, Lowell), here is one way to accomplish your task:
With tenant_history(hmy, dtdate, htent, sevent, dtoccurred, dtmovein, dtmoveout )
AS
(
SELECT '176340','2011-08-26 00:00:00.000','55496','Notice Given ...
June 11, 2012 at 9:08 am
Possibly, but you didn't really give us what I requested. Please take the time to read the first article I reference below in my signature block. It walks...
June 11, 2012 at 8:58 am
nscott 48570 (6/11/2012)
June 11, 2012 at 8:14 am
If your company is willing to spend some money, you may want to look at this: http://pragmaticworks.com/Products/Business-Intelligence/TaskFactory/SSIS-read-email-source.aspx.
June 11, 2012 at 7:51 am
You have posted quite a bit of information, but unfortunately, I am not quite able to figure out what it is you are trying to accomplish. One thing that...
June 10, 2012 at 9:33 am
pandeesh (6/9/2012)
Is it possible to simulate ANSI 89 notation in the current SQL server 2012?
No. There is no way to simulate the ANSI-89 style. The best thing I...
June 9, 2012 at 11:34 am
Based on what you have posted, no. You will need to restore the database.
June 9, 2012 at 11:07 am
Viewing 15 posts - 11,401 through 11,415 (of 26,486 total)