Topics
Started by
Posts
Last post
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
I want to select all rows where userid occurs more than once in table [user_artist_owned] I have th…
5 replies
Hi, I have a tanle called X and have Fields like B network DateLoaded 11 c net 201…
5 replies
Help. Trying to avoid a cursor to self join a table and get obtain a two year average of one of th…
9 replies
Viewing 15 topics - 8,716 through 8,730 (of 10,647 total)
You must be logged in to create new topics.