Topics
Started by
Posts
Last post
Hi friends i have a question Id Transcation amount 1 20000 1 3…
6 replies
I am trying to determine what is the best login for an application that is connecting to a sql serv…
1 replies
I'm trying to do a CASE statement comparing different columns for different result sets, and am won…
4 replies
Change rows into column and vice versa without using pivot method.
4 replies
I've been playing around with CTE's and when I run the code below it executes instantaneously.; WIT…
11 replies
Hello, I have searched a number of forums and tried a few examples but cannot get anything to work.…
9 replies
I have recently read about this in the below link. http://www.sql-server-performance.com/2013/tsql-…
12 replies
I create Sample Test Data. Please take a look Create Table Date1 ( ID INT , Code varchar(20), Creat…
1 replies
Here is my sample data table Table Name = Test ID,DTypeID,MinDuration,MaxDuration,UpdateField 1,123…
7 replies
I need some help with a query to split a table master table Id ComputerName Ip Vuln ScanDate 1…
5 replies
BEGIN DECLARE @FATHER AS INT SET @FATHER = (SELECT FATHER FROM SEGMENT WHERE SID = @sid) …
3 replies
Hi, I'm trying to create a report from the given database. I just need to see the latest records o…
5 replies
Hello there, when analyzing a procedure I often query the cached execution plans of procedures. I u…
2 replies
Dear All, Here's the background - I have a table of staffids and the shifts/durations worked - with…
24 replies
Hi all! Is there an easy way to pivot data into another table, when the design of the first table i…
5 replies
Viewing 15 topics - 4,261 through 4,275 (of 10,647 total)
You must be logged in to create new topics.