Topics
Started by
Posts
Last post
I need to create a Trigger that creates a new quote no everytime a new opportunity is created.The q…
19 replies
Hi, I have to implement a view that has account number, year, period (month), balance, and Year-end…
6 replies
For some reason I can't pad an early day of month with '0'. Not sure why. There are no mixtures of …
17 replies
Our table holds 200 million rows with 180 columns. We are planning to implement a batch wise record…
14 replies
error i'm getting from the below query: Incorrect syntax near '@DatabaseName'. DECLARE @Datab…
11 replies
Hi All, Hello, I have an issue in finding out the date range and id previous to an event. here I w…
8 replies
Hi,I need to create a report that shows that last time a person completed a course each year. I've …
6 replies
Hi, I'm just looking for a disscussion about the best indexing strategy for a table I have that's i…
14 replies
Hi! The Question: Is it a good or bad idea to use Clustered Index on a datetimeoffset(7) on the Cre…
7 replies
Hi guys, need quantity from previous row , when prev_orderid=orderid from previous row.…
14 replies
Hi all, A query I've got isn't running particulary fast (a bout 2 and a bit minutes). I know, in th…
21 replies
Hello AllI have the following table... CREATE TABLE [dbo].[Space]( [DBName] …
5 replies
Hi all! I have an field 'MEDLEMSNUMMER', where i have found the highest number the very easy …
2 replies
Guys, One of our systems has Role Based Access Control that is extremely granular - there are about…
4 replies
Ok, so here is my sample data I am testing against... declare @t table ( Id int ,&…
12 replies
Viewing 15 topics - 976 through 990 (of 4,984 total)
You must be logged in to create new topics.