Topics
Started by
Posts
Last post
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
Hello, I'm trying to figure out how best way to group records that are consecutive. For example, I …
4 replies
I have 3 table. Source table, dim table and load table.. I have a source table .. In the source tab…
7 replies
I want to do a select in a proc and if @@ROWCOUNT = 0, I would like to kill that rowless resultset …
27 replies
Viewing 15 topics - 5,941 through 5,955 (of 10,644 total)
You must be logged in to create new topics.