Topics
Started by
Posts
Last post
I am trying to figure out how this works. Locking difference between TabLock and TablLockX. They …
7 replies
Hi Folks, I am trying to perform some if/else logic on the last business day of the month. I have a…
2 replies
Is there a better way of doing this? IF object_id('tempdb..#Temp1') IS NOT NULL BEGIN DROP TABLE…
6 replies
Hi, I'm executing the following queries: UPDATE AcumuladosContas SET MES12DB = MES12DB + 5000.00 W…
17 replies
Hi, I have a large Stored Procedure. One tiny part of it is dynamic: SET @qry = 'SELECT something';…
5 replies
I have a sample table CREATE TABLE dbo.Analysis ( ID INT IDENTITY, Margin [numeric](21, 6) NULL, Ga…
7 replies
Hi all, I am trying to learn Execution Plan reading. I executed the below query USE [AdventureWork…
3 replies
Hi not sure if this is the correct forum but I need some help with dates in SQL. I have been given …
4 replies
Is it possible to pass a variable for MAXDop as a query hint? My query below works when I set a co…
6 replies
*advice I have a big nasty query I have been assigned to look at that basically is pulling varcha…
2 replies
I have a situation where I created I ran a query that generated about 32,000 individual deletes tha…
11 replies
Hello comunity I have write this TSQL, but my problema that is return more than one LastPrice for t…
2 replies
Hey guys, I have these result codes from one table...There are like 12 distinct ones...When I join …
9 replies
If you have a table that is already populated (say 900,000 rows) and then you create an index, is t…
3 replies
Hi Friends, I have a requirement where i have to write a Sql for : basically i have 2 columns 'star…
5 replies
Viewing 15 topics - 4,126 through 4,140 (of 10,647 total)
You must be logged in to create new topics.