Database

Xiangyang Liu 刘向阳 wrote: Thanks to myself +5 for talking to yourself and for posting the solution - might help someone who is working on the same :) I are Troll :suss:

This my help http://weblogs.sqlteam.com/jeffs/archive/2007/09/10/group-by-month-sql.aspx[^]

SET @my_variable =SELECT dbo.my_function(@my_function_parameter)

I don't know what the performance would be like but your code seems a bit weired. Does table1 and table2 have any relationship(column[s]) in common? it seems to be you're going to end up with a cartesian product of some sort.

Okay I see what you mean... I have not had a big problem with this as I usually have no trailing characters. There might be a setting about trailing characters, but I cannot remember. Sorry I cannot help. djj

i am commiting the changes. i have also tried to unlock tables before alter but to no success. think i have to re-think the whole process.

awadhendra tiwari wrote: I have problem where I have get list of all tables on which full text index can be applied with their key names. SELECT TC.[TABLE_SCHEMA] , TC.[TABLE_NAME] , CCU.[COLUMN_NAME] , TC.[CONSTRAINT_NAME] FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU ON TC.[CONSTRAINT_NAME] = CCU.[CONSTRAINT_NAME] WHERE TC.[CONSTRAINT_TYPE] = 'PRIMARY KEY' AND EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS C WHERE C.[TABLE_NAME] = TC.[TABLE_NAME] AND C.[DATA_TYPE] IN ( 'char', 'varchar', 'nchar', 'nvarchar', 'text', 'ntext', 'image', 'xml', 'varbinary', 'varbinary(max)' ) ) ORDER BY TC.[TABLE_NAME] awadhendra tiwari wrote: its urgent The people that visit this site do so in their spare time. Rushing would be inappropriate. I are Troll :suss:

But, why would you destroy SQL server 2000? ♫ 99 little bugs in the code, 99 bugs in the code We fix a bug, compile it again 101 little bugs in the code ♫

Big Joke ♫ 99 little bugs in the code, 99 bugs in the code We fix a bug, compile it again 101 little bugs in the code ♫

You cannot add new classes to your project at run-time. You need to write a program that creates classes dynamically, for example using CodeDom[^] or Emit[^] APIs of .NET. CodeProject has examples of using both these sets of APIs[^].

hi, i want to use TABLOCKX lock on my table. i have used same query given in above post. but problem is lock does not get released after completion of transaction holding lock on table. hence another transaction keeps waiting. following are my 2 query i tried in query analyzer of sql server. Please help me... Query 1: BEGIN TRAN A SELECT * FROM alerts with (TABLOCKX, HOLDLOCK) declare @cnt bigint set @cnt = 1000000 print 'start time = '+cast(getdate() as varchar) while @cnt > 0 begin print 'Cnt = ' + cast(@cnt as varchar) set @cnt = @cnt - 1 end print 'end time = '+cast(getdate() as varchar) COMMIT TRAN A ----------------------------------------------------------------------------------- Query 2: BEGIN TRAN B print 'start time = '+cast(getdate() as varchar) SELECT * FROM alerts --with (TABLOCKX) print 'end time = '+cast(getdate() as varchar) COMMIT TRAN B Please let me know if i'm doing anything wrong. Thank in advance... Rajesh.

You are misunderstanding what Query Cost is. If you run any single query, the cost will always be 100%. If you run multiple queries, the total cost of all of the queries in the batch added together will equal 100%. The value is used to compare the relative cost of each query in the batch as the message says.

Perhaps you could use a different database.

Little Debugging.. CREATE PROCEDURE sp_GetEZQueryList ( @sUser AS nchar(500) , @sSupervisor AS char(1) , @sAllowed AS varchar(8000) ) AS IF @sSupervisor <> 'Y' SELECT EzqDateMod , EzqFlxID , EzqUserName , EzqName , EzqData , EzqDescrip FROM EZQuery WHERE ( EzqUserName = @sUser ) OR ( EzqUserName = 'SYSTEM' /*AND CAST(EzqFlxID AS varchar(10)) IN ( SELECT * FROM intlist_to_tbl WHERE(@sAllowed) ) */) ELSE SELECT EzqDateMod , EzqFlxID , EzqUserName , EzqName , EzqData , EzqDescrip FROM EZQuery GO exec sp_getezquerylist 'DO''SULLIVAN', 'N', '100' Executes fine, without the IN clase to look up The source of your issues appear to be in this function (I assume its a function based on the nomenclature) intlist_to_tbl. If intlist_to_tbl is really a function why are you sending that data to the db, and converting it instead of storing it in the db? Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

T2102 wrote: I have gotten some pivots to work with arbitrary # of columns, but I've had to use dynamic sql. Yea if the columns before execution time are not known then you will need to resort to dynamic SQL. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

Do all MDX queries cause SSAS to crash? Or just the one you are trying to run? Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

r.kh wrote: please send me the er of codeproject.com I assume by 'er' you really mean Entity-relationship model? Correct? There used to be a site similar in setup to Code Project (not written by Chris), not sure what ever happened with it though. You might go looking around the web development articles and find something interesting to learn from. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

Maybe you should first check if the listener for the oracle database has started yet. Then the connection string.

Here you go List of reporting software[^] BTW I'm worked/working in both SSRS(RDLC) & Crystal reports .... fine for me. thatraja **My Tip/Tricks My Dad had a Heart Attack on this day so don't... **