Topics
Started by
Posts
Last post
I am working with the data from msdb.dbo.sysjobhistory and want to take the average duration of eac…
24 replies
I have a pivot table that displays studentid and a list of assessments as the columns the cells are…
6 replies
Hello, I have a the following table: Time NumCaseCode 15h00 - 16h00141 15h00 - 16h00142 …
13 replies
I want to setup a stored procedure for a sql server 2008 r2 that can update between 0 to 8 columns …
7 replies
hi friends, Entry_id Eventy_type_id( not unquie) Event_value( not unique)Event_datetimeusername…
13 replies
I want to write SQL query that, when given a month of the year, will return a table with eventID as…
3 replies
Hi all, I'm trying to update a table using a subquery. when I run the below script I get an error M…
14 replies
hi, i want last day last year,what is the function for that. example if i put date 02/29/12 the i …
16 replies
Hi folks, First of all, hello SQLServerCentral users. I have been a member for some time but this i…
5 replies
I have a table that looks like the following: I want to be able to update the trendValue column ba…
1 replies
I execute the following Statement: Select 'DATED_TEXT','DATED_TEXT_RTF',DATED_TEXT_RTF, count(*) …
15 replies
I wrote some Stored Procedures using CTE but not that much. How could I convert the code below to C…
30 replies
I have the following sample data: create Table dailyLog( logId int, name varchar(100), date da…
6 replies
What is best way to write this statement? 1) DECLARE @L_ZERO INT SELECT @L_ZERO = IdMyTable FROM My…
9 replies
Hi All, I've been googling like crazy for an approach to calculate SomersD statistic on data sets. …
3 replies
Viewing 15 topics - 5,926 through 5,940 (of 10,644 total)
You must be logged in to create new topics.