Topics
Started by
Posts
Last post
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
Hoping the gurus here can offer some advise here. I need to update a field ( Age ) in Table_1 base…
13 replies
I am trying to create a stored procedure where i would like to fetch the next previous and current …
6 replies
I have created a table that will assign several activities in my Primary table into four groups (ru…
2 replies
Hi Guys, I've received a set of files. The files can be grouped, with 3 files per group. For exampl…
1 replies
i need to parse a string like [p]a]a]s]s][p when a [ sign occurs then next letter need to be conv…
27 replies
I have two orders tables, one is a staging, the other is a "Orders Sent" kind of table. The staging…
17 replies
This isn't an important issue, but it struck me as strange and I'm curious to see if anyone can exp…
2 replies
Hello I have a table Allocations with coulmns AllocationID , PaymentID , …. AllocationID is a PK. D…
12 replies
Hi Guys, How can i make list of the last day of each month of the year 2011? Output: January-2011 :…
9 replies
HI All, I want to select all days that are the last day of the month from a calendar table. I guess…
3 replies
Please I need help in changing the following scalar valued function to an inline one to improve per…
1 replies
I'm studying for the 432 exam & have a few questions about SPLIT, MERGE & SWITCH. When yo…
1 replies
Viewing 15 topics - 5,941 through 5,955 (of 10,647 total)
You must be logged in to create new topics.