Topics
Started by
Posts
Last post
I'm fairly new to SQL and have become completely stuck in trying to do this: I want to update a col…
3 replies
Can someone recommend a (free?) tool to format TSQL Code. Ideally, it should be something working i…
16 replies
Here's my scenario. I have a table that looks something like this: CREATE TABLE [dbo].[Logs]( [ro…
9 replies
Was watching Brent Ozar explain performance tuning today (Great! Highly recommended!!) and it made …
6 replies
Ok, here is what I'm faced with. I have a number of patients that need to be assigned to doctors in…
2 replies
Hi All, I only have five categories in my table. I don't have any other data in my table: [Code] Ta…
5 replies
experts, how to exclude the negative value in this OT calculation, ,CalcPart AS ( SELECT departm…
9 replies
Hello all, I am looking for validation and help on this issue, as it's driving me absolutely nuts.…
5 replies
I was working in the "Modify" script of a stored procedure just now. I accidentally selected only a…
22 replies
Hi All, I have a table and I have a column that has data like below Tabl1 col1 Base 1 2 3 4 I need…
2 replies
I have a database with about 2,000,000 objects in it. Yes I know its lots but this is what I have …
9 replies
Hi all I have a question about concurrency. Let me provide some set-up code first. DROP TABLE IF EX…
24 replies
I have to Create a Store Procedure named AddToCart.This procedure should take CustomerId, productId…
4 replies
Here is something I found this morning. Since indexed views are used in queries that do not explici…
1 replies
Hi! I have a litle problem with following: I have some users (U1, U2, U3, etc.) who handles product…
5 replies
Viewing 15 topics - 2,956 through 2,970 (of 3,091 total)
You must be logged in to create new topics.