Viewing 14 posts - 31 through 44 (of 44 total)
Sorry this will not work,
However I say, Thank you all of you who Help me in this regard, especially Chris and Lynn.
I had sorted out by creating Custom Function,
Here is...
December 23, 2009 at 3:40 am
>> are the values of RowID unique within the table
No
>> are they always unique within a single [ReportId]
Yes
December 22, 2009 at 7:17 am
>> Sorry to join in late, but looking at your stored procedure in the first post, all your stored procedure is doing is setting local variables to what will most...
December 22, 2009 at 7:15 am
>>How many different values of RowID do you have?
All are different. 1,3, ... 52, so on
>> Is this 52 weeks, or is the 52 just a concidence?
No
This is not exactly...
December 22, 2009 at 7:02 am
Thanks
52 Rows
December 22, 2009 at 6:44 am
>> lmu92 >>@abcim: Are you sure this proc is running at all on your system and not firing any errors?
Yes this is a Sp, means that this is compiled but...
December 22, 2009 at 6:21 am
What is CTEs (common table expressions) ?
December 22, 2009 at 5:13 am
Neither ReportId1 is Pk nor RowId. They are both FK's
This SP was working 100% before when i was not using local variables.
The reason for using variable is that @Total is...
December 22, 2009 at 4:28 am
no it returns many
December 22, 2009 at 2:22 am
OK Mohit I will ask vendor then tell you.
Thanks both of you.
March 18, 2009 at 1:43 am
Hello i have INstalled SqlExpressProfiler.exe
Then i have authenticated sucessfully but then i am getting this error,
version: 0.1.5.20
exception: System.Data.SqlClient.SqlException: You do not have permission to run 'SP_TRACE_CREATE'.
at...
March 18, 2009 at 1:26 am
go to performance tools-->sql profiler
open new trace and give the authentication for that server.
leave everything to default and click the "Run".Later stop the trace and search for the events you...
March 18, 2009 at 1:09 am
Thanks for your reply,
Strange...check if any job is doing this.Run profiler and catch for the events which is causing this.Also check the event viewer logs.
Profiler is the best thing for...
March 18, 2009 at 12:41 am
Viewing 14 posts - 31 through 44 (of 44 total)