Topics
Started by
Posts
Last post
I have a query that uses the SUM aggregate function to return results for over 200 columns. Based …
2 replies
Hi, I have this query that works fine. ;WITH cte AS ( select * from (SELECT distinct pehPErcontrol …
5 replies
I have two tables which are listed below. TableA StudentID StudentName 1 A 2 B 3 C 4 D 5 …
9 replies
Hi all I am tasked with importing large fixed width text file to SQL, previously I used a library c…
23 replies
Hi, I needed to change part of my query to use a date field now I can't get it to work: This is the…
2 replies
I copied the query result set to TEST.xls and required result set into result.xls. I have a table n…
8 replies
We have a situation were we want to get the results of a stored procedure from a DB2 database in SQ…
4 replies
Hey guys, I've got a table of stats which gets updated on a daily basis with an additional row for …
1 replies
Hello, I´m new in this forum. Maybe someone can help me with my problem: My data looks like this: S…
1 replies
Over internet there are a lot of topics regarding the size taken by NULL values. There is some mism…
3 replies
Hi all, I have given a scenario in which I have to eliminate cursors from all the objects of databa…
18 replies
How to calculate the update amount for the example below? Table A has the following rows. I want to…
2 replies
Hi all, I need a help on getting the distinct set. My Data look like this: SET 1 SET ID Product …
10 replies
Hi, Is there a way to call a SP for each row in a table, and to specify the value as a parameter? L…
16 replies
Hi, I have a table which currently has a month and a number by month representing lets say car sal…
4 replies
Viewing 15 topics - 3,166 through 3,180 (of 10,647 total)
You must be logged in to create new topics.