Topics
Started by
Posts
Last post
Our company has used Linked server to get the other db server data . Now we are trying to replace t…
5 replies
I have a user report that runs in > 1 minute in one environment and takes over 22 minutes??? The…
3 replies
Hi Friends, I have created a SP - Dynamic Merge for SCD type 1 and Type 2. When I execute the SP …
1 replies
How do you something like this? :hehe: CREATE TABLE [dbo].[Tbl]( [field1] [smallint] NULL, [field…
11 replies
I've got this far to generate financial years. From an arbitrary start date it counts each financia…
4 replies
How do you create a connection to an Excel file (either Excel 2010 or 97-2003), from a SQL database…
10 replies
Can you briefly explain the working of below query select DATEDIFF(MONTH,0,getdate()) In my machine…
7 replies
Hi, I do not understand why I get different results when running the two SQL statements below: SELE…
3 replies
Hi all In the Employee Table, (EMPNo,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) Example DAta EMPNO…
6 replies
Hi, I'm having to write an anonymisation script for our production DB's so we can bring them into t…
2 replies
Hello All, I need help with a function. I give my report users the options below so that my functi…
6 replies
So I have an after trigger that sends an email. I want the insert to happen whether the trigger wo…
13 replies
Greetings... I am NO SQL expert - good at writing very simple queries - but now I have to do someth…
77 replies
Here is an code example of my problem.... My question is How do I get the scores? ie: 50, 300, 71…
2 replies
CREATE TABLE Test ( ContactID INT, SalesOrderID INT, OrderYear DATETIME ) insert into Test(ContactI…
6 replies
Viewing 15 topics - 6,031 through 6,045 (of 10,647 total)
You must be logged in to create new topics.