Topics
Started by
Posts
Last post
Hi, I have a SQL script with about 5500 lines, it does numerous things, but mainly, the job of the …
7 replies
Hi, Select Lnno From Temp_Check Where det_trantype = 'Opbal' Group By Lnno Havin…
3 replies
Hi, The question which i am going to ask will prove that i how newbie i am. Basically indexes incre…
4 replies
I have a field that contains a time (i.e. 16:40:27) and I have a field of "SecondsAtStatus" (i.e. 7…
10 replies
Sp is getting more time(more than 7m) to generate report :w00t: .Output has more than 21000 records…
5 replies
Hello, I created the stored proc in sql server. Now I want to use it in my crystal reports.So whil…
2 replies
Just wondering, I like to use ISNULL(column_name, 0) while my friend like to use COALESCE(column_na…
41 replies
HI Consider the below scenario: I Have a table with 5 partitions based on the org_id. In other word…
4 replies
Hi, I have 100 Stored Procedure. I want to search for 'Employee' key word in all 100 SP's, but it i…
7 replies
hi i need to craete table which has phone number field, format (345) 234 - 2345 what is the best da…
9 replies
Hi, below is the query to display the project_name where project_name matches the condition. select…
2 replies
I am trying to find all users who has no activity and in activity tables we do have some records wi…
2 replies
hello. here is the scenario: sp 1 inserts data in #table, #table is in sp2 and sp3 sp 2 and sp3 are…
12 replies
I am using a trigger to check some business logic before doing an insert. If the business logic fai…
2 replies
Hi, I am looking for a SQL which can group and rank the output based on date sequence. I can get th…
6 replies
Viewing 15 topics - 5,266 through 5,280 (of 10,647 total)
You must be logged in to create new topics.