Viewing 15 posts - 121 through 135 (of 351 total)
Drag it ....onto the diagram window...
September 29, 2011 at 9:44 am
kishoremania (9/28/2011)
Can I know why you used rank() for max_b and row_number() for max_c?
To get the max value... order by desc...
September 28, 2011 at 2:38 pm
This is what you are looking for...
WITH Cte_test
AS
(select MAX(B) AS B, MAX(C) AS C FROM
test456 )
SELECT DISTINCT A,B.* FROM test456 A, Cte_test B
September 28, 2011 at 1:09 pm
Can you be more descriptive ?
September 27, 2011 at 11:37 am
The easiest way to do is:
Use maintainance plans:
1. drag the cleanup task and set it to the path folder that contains the log files backups and set to delete older...
September 27, 2011 at 11:34 am
ricer (9/15/2011)
We had reserved 18 drives for main data and was planning on using...
September 15, 2011 at 12:43 pm
hydbadrose (9/15/2011)
September 15, 2011 at 11:48 am
What is the size of the each record or what datatype and size you have in the file?
Use import/export to see what data types does excel have.
September 15, 2011 at 11:33 am
Does Job Owner and Job was invoked by the same user ?
If not I would really change the owner of the job to sa or some system account.
September 15, 2011 at 10:46 am
komal145 (9/14/2011)
I HAVE TABLE SOMETHING LIKE THIS:CREATE TABLE #Parm_Filter
(
[Parm] [varchar](50) NULL,
[PRMLabel] [varchar](200) NULL,
[PRMValue] [varchar](200) NULL,
[PRMOrder] [int] NULL
)
WANT TO INSERT SOMETHING LIKE THIS:
PRMLabelPRMValueParmPRMOrder
January1Month1
February2Month2
March3Month3
April4Month4
May5Month5
June6Month6
July7Month7
August8Month8
September9Month9
October10Month10
November11Month11
December12Month12
1st1Quarter1
2nd2Quarter2
3rd3Quarter3
4th4Quarter4
Here I'm inserting a sample row into the...
September 14, 2011 at 4:38 pm
MysteryJimbo (9/8/2011)
@SQLFRNDZ (9/7/2011)
Intension is how would I detect the...
September 8, 2011 at 12:57 pm
Do I have any other way that I can re-create a job to create triggers when there is a re-initialisation using sanpshot.
Intension is how would I detect the re-initialization ?
...
September 7, 2011 at 12:45 pm
winash (9/7/2011)
How do you re-initialize? Snapshot or from backup?
using snapshot
If you initialize from backup you'll need to re-create the triggers everytime (since your audit tables are in another DB...
September 7, 2011 at 12:13 pm
This is true but it is not possible in our environment as publisher is having multiple subscribers and different requirements.
We can make changes only on our end. Can you please...
September 7, 2011 at 11:43 am
Viewing 15 posts - 121 through 135 (of 351 total)