Topics
Started by
Posts
Last post
Hey guys, trying to create a stored proc that updates records and returns the number of records upd…
2 replies
Hello, I have a query where I am trying to get only the first record for a field that has the s…
6 replies
Hello. I want to ask about the possibility of solving the problem below. This problem is SQL2008 …
6 replies
The issue is this. I have a list of values in columns like.. AA infringed …
8 replies
I have situation where if there is no transaction during a week then show the previous week balanc…
10 replies
Folks, I usually had one row in table containing multiple values with nulls, which is relatively ea…
7 replies
Hi, I have two tables tbl_data and tbl_events. The tbl_events tables has a list of eventnames that …
6 replies
How can i cover col1 with sum(col2) I have a table: DECLARE @TEST TABLE ( …
2 replies
Hi all, Can someone please recommend an efficient way to achieve the following. Thank you. -- samp…
20 replies
Hi I had a stage table where we dump all the data in nvarchar format, with the help of stored proc…
6 replies
PROBLEM: Table has multiple dated records for each category, I need to extract the 2 most recent r…
1 replies
Looking for help on the following. I think I know how it should work, but it isn't. So, let's ask t…
2 replies
Hey guys, I have a need to query a table grouped by Col_A, Col_B, Col_C, Col_D and return only one …
7 replies
for example : with cte1(id) as { select query .............. union all select query............. jo…
14 replies
Hi All, We have an excel file which changes every week.Weekly data will be added to each column in …
4 replies
Viewing 15 topics - 2,536 through 2,550 (of 4,984 total)
You must be logged in to create new topics.