Topics
Started by
Posts
Last post
I have stored procedure which takes more than a min to run in sql browser.when i call from java UI …
4 replies
Dear Friends, I need help to count how many years,months, days left between two dates. the data:acq…
12 replies
I have the message system DB diagram below. A person can create a Thread (conversation) with anyo…
8 replies
DECLARE @Text VARCHAR(256) SET @Text = 'Generic="abcde" Generic="fghij' Generic="sdfsdfasdf"' How c…
6 replies
Hye, SELECT CHARINDEX('A2,C1,C2,C3,D1', '01,02,03,04,05,A1,A2,C1,C2,C3,D1,D2,J1,J2,J3,K1,M1,M2,M3,N…
4 replies
Hi, Below is the sample data to play with and i need to use the partition by to split the record ba…
13 replies
Hello friends hopefully you can assist me In my query, I need to frame a condition like Activities …
3 replies
I receive the follow error when executing a stored proc that has dynamic sql in it: ErrorNumberErr…
2 replies
Hi All, I am having user table as below Create table #TEMP_USER ( ID int identity (1,1) , USERNAM…
31 replies
Hi, I am reviewing a stored procedure,which is causing blocking. I found it has begin tran/co…
1 replies
I'm trying to create a foreign key constraint in database, but I got this error: 'Grievance (LRAT…
2 replies
Hello, I am working on a query (optimized) to get some extra info for a base table. Tables facts: …
12 replies
Hi, Can some one help to find median for Odd and Even count in one function Thanks Grace
9 replies
Hi! I have a procedure that: Create Procedure MainProc as Declare @dirxml Varchar( 300 ) Declare …
1 replies
Hi, Below the sample data select 'verify1' union all select 'verify1' union all select 'verify1' un…
5 replies
Viewing 15 topics - 451 through 465 (of 10,647 total)
You must be logged in to create new topics.