Topics
Started by
Posts
Last post
Ok... this is just friggin wierd. We have a field called "ISDELETED". If the record is current th…
67 replies
Hi All I am having an issue grasping the behaviour of Joins. DDL: CREATE TABLE [dbo].[T1]( [Col1] …
3 replies
Hi, I have a query where the last left join is killing the performance. Someone suggested me to rep…
19 replies
OK, I've been poking at this for days and can't figure out why its not working. SQL Server 2008 R2 …
13 replies
I'm getting the following error: The MERGE statement attempted to UPDATE or DELETE the same row mo…
12 replies
500+ posts and I finally get to start my second thread! Hopefully I'll get a better response on th…
14 replies
I want to have SQL read new messages from a specific mailbox and mark them read. Anyone ever done s…
9 replies
I am referring to this article. http://www.sqlservercentral.com/articles/T-SQL/77391/ I was expecti…
4 replies
Hi, i am trying to write a merge query for the insert to the table. but the source table does multi…
3 replies
I need Status Update column like : 1)All (both completed and pending i.e which went to Enrollme…
19 replies
I have a procedure on a server which can be called from several different linked servers. (To be…
2 replies
Please run below code ---------------------------- set nocount on declare @role varchar(255),@dbnam…
12 replies
This function gets the score up to now for students (we are using categories and some of the catego…
9 replies
I have two queries I execute on a table. For Query1, the index would be a combination of Columns - …
2 replies
Hi, I found this code made by someone else in the company (he does not work here anymore) and it se…
5 replies
Viewing 15 topics - 5,896 through 5,910 (of 10,647 total)
You must be logged in to create new topics.