Topics
Started by
Posts
Last post
Hi All, I am attempting to provide some guidelines to the report writers for one of my clients. The…
20 replies
Hi, I want to create a approach for solving the cross tabbing statistics report. I know some method…
4 replies
I have been asked to refactor a piece of T-SQL that applies a schedule made up of time segments ove…
1 replies
I have three tables [contractor], [estimate], [contract]. Here is what I have so far: SELECT [C…
9 replies
I have this code below which will give me a row number for each visit against a property. My proble…
3 replies
I want to know if a stored proc with a IF within will re-execute the execution plan or use the save…
2 replies
Hi, I am creating a report which has input as date (which is a month end Date) and option to run Mo…
4 replies
Hi everyone, I have a table with the following data structure: office, asset 1, desktop 1, printer…
8 replies
SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO SET ANSI_PADDING ON GO SET CONCAT_NULL_YIELDS_…
5 replies
Would like to enforce unique combinations but not PK/Unique index E.G. allows ID, ID2 1, 2 1, 2 2…
6 replies
What I have is two database's, one is the live the other is archive. I need to pull any records ou…
1 replies
Hi, I have a query similar to the below SELECT StartDate, InvoiceDate FROM TableA Where CASE WHEN I…
2 replies
Hi all I have A order table. I want to send information to all my user when a new record insert in …
11 replies
I've come across an issue with a query that, to me, should fail, but it doesn't. I was wondering if…
5 replies
Hello, I hope that I am in the correct place haven't overlooked the answer if it is somewhere else…
17 replies
Viewing 15 topics - 3,826 through 3,840 (of 12,234 total)
You must be logged in to create new topics.