Viewing 15 posts - 241 through 255 (of 498 total)
OOPS... I forgot... You'll also have to strip off the last Union in the above...
January 13, 2004 at 12:46 pm
Give this a try. Please note that I just whipped this up so it is untested!
-- Run this script and paste the results into a new QA Window. Then run...
January 13, 2004 at 12:44 pm
If you run this SP in QA do you get the ???? in the data? If not I would start looking at what is happening when you call the SP...
January 13, 2004 at 11:03 am
Yes you can. Look at the system stored procedures that start with sp_trace_.
IE: sp_trace_create, sp_trace_generateevent, sp_trace_setstatus...
January 12, 2004 at 2:41 pm
I would highly suggest you call Product Support Services to resolve this.
January 12, 2004 at 2:37 pm
Try this...
SELECT YourMonth = datepart(mm,CONVERT(datetime,convert(int,'057')))
, YourDay = datepart(dd,CONVERT(datetime,convert(int,'057')))
, YourDate = convert(varchar, convert(varchar, datepart(mm,CONVERT(datetime,convert(int,'057')) ) ) + '/'
+ convert(varchar, datepart(dd,CONVERT(datetime,convert(int,'057')) )) + '/'
+ '20' + '04')
January 12, 2004 at 2:34 pm
None that I know of off the top of my head. Besides, why reinvent the wheel? Profiler is very efficient and works very well!
January 12, 2004 at 2:16 pm
You might notice better performance if you use an outer join instead of the not exists. IE:
SELECT ...
FROM tblMMStudentTestScores TS
LEFT JOIN #tblMMStudentTestScoresTEMP T ON ...
WHERE T.?? IS NULL
If you have...
January 12, 2004 at 2:14 pm
I think the best way to do this would be with Profiler. If you use the template SQLProfilerTSQL_Replay it will capture the actual calls to the SP along with the...
January 12, 2004 at 2:09 pm
No I don't use the dbproject as a DAL. Since I only do TSQL work for the most part I use the DB project to hold all of my SP...
January 12, 2004 at 10:41 am
Hey Frank! I use VSS Too... I also do all of my TSQL work on Stored Procedures through a database project in Visual Studio. I like to use a lot...
January 11, 2004 at 2:22 pm
Even better yet. When in QA hit F8 to bring up the object browser. Drill down to the SP you want to "EDIT" and right click on it. Hit Edit...
January 9, 2004 at 1:45 pm
I agree with the idea of using replication for this. Merge replication isn't too bad but I would stay away from using Managed Identities if at all possible.
January 9, 2004 at 1:32 pm
Christy,
You've gotten a lot of good advise here. I just wanted to answer you specific question on using SP calls for "Simple Selects"....
Yes I would create an SP for simply...
January 9, 2004 at 12:54 pm
Antares,
I realize that there is no major difference in if you use right or left when properly done. I just found it amusing that he wrote it using a right...
January 8, 2004 at 10:25 pm
Viewing 15 posts - 241 through 255 (of 498 total)