Topics
Started by
Posts
Last post
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
Hello, I'm stuck after looking online and reading for 3 days, I would really appreciate some help. …
5 replies
I would like to create a views for the entire Database. The views must exclude any fields which is …
4 replies
I am currently doing string manipulations with T-sql. In the where statement of my code I have the …
33 replies
Viewing 15 topics - 3,826 through 3,840 (of 12,230 total)
You must be logged in to create new topics.