Topics
Started by
Posts
Last post
I need to create a demo database. I have some SME's entering sample data. I will need to create n…
3 replies
I need to create a trigger event (on create) that will, based on values in the new row, open a mat…
2 replies
I have a query which is using a IntegerListType, havng implemented the integerlisttype it nows runs…
3 replies
I have 1 script that I can run on Server A where the data resides and it takes a fraction of a seco…
5 replies
I want to extend the minimum datetime value(1973), some of the oracle date fields have date 01-01-0…
3 replies
Hi, I am having some serious performance issues when trying to represent time and attendance data f…
1 replies
Hi I am trying to write a query to report vehicle utilisation of fleet cars. I have records for eac…
9 replies
Hi Friends i have a table student_id School_Id 100 1 100 2 100 …
9 replies
I need the sum of a column based on an if condition. So I want the total number of occurances where…
2 replies
Hello all I am trying to execute the following code: BEGIN TRANSACTION GO USE TyroneTest IF NOT EX…
1 replies
I'll preface this by saying dynamic SQL is unfortunately required in this situation. I have a table…
9 replies
i'm after a function that i can apply to a datetime value and return the shift that was on. I guess…
13 replies
Hello comunity i have the following script : DECLARE @PivotColumnHeaders VARCHAR(MAX) SELECT @Pivot…
2 replies
I only want the records where the condition is not true. This select gets those records where the t…
3 replies
1. If you have one stored procedure nested in another, can you have the child procedure insert rows…
3 replies
Viewing 15 topics - 8,701 through 8,715 (of 10,635 total)
You must be logged in to create new topics.