Topics
Started by
Posts
Last post
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
1. First script As below code, wirtten too much overlaping index whenever executing also impact app…
2 replies
I am new sql server. I am trying to get the following data. I have 3 different tables table1 table2…
13 replies
Hi, I'm having 2 tables with old and new project numbers, If project number in Table A matches with…
6 replies
Viewing 15 topics - 5,266 through 5,280 (of 10,644 total)
You must be logged in to create new topics.