Topics
Started by
Posts
Last post
Hi, I have a table with 3,000,000 records for one year. It has only a primary key. Just select quer…
11 replies
I need to display result like : 1 <A>, <B>, <C>, <D> 2 <E>, <Z>…
7 replies
Dear All. I have developed a system for Manufacturing. IN which I have to display production line …
1 replies
Hi All, I am developing a report, In which I need to select creditors group either single one or al…
2 replies
Hi there - looking for guidance on generating output in XML format. I have a new application that …
7 replies
All, I involved in a fine tuning work. The table has around 40,000,000 records and the table one co…
10 replies
I have table with OrderId, LineId, FirstDate, LastDate, DaysBetween. The order and line are the ke…
5 replies
Hello All, I've created a cursor that works fairly well. And I use a Print statement which prints o…
13 replies
Hi, I am creating a table through a stored procedure, in the table I am trying to get a distinct co…
3 replies
There are two tables I want to join or merge, but need some help with the query. Table1 = archive t…
2 replies
Hi, I have a table records like: 5:30 AM11:00 AM 11:30 AM2:30 PM 2:30 PM5:30 PM 5:30 PM11:00 PM…
13 replies
I have the following query: SELECT RP.PERIODNAME, [1.1] = COUNT(CASE WHEN NV.CASETYPE = 'F' AND NV…
21 replies
i am creating a proc that exports data to excel then emails it using database mail but have stumble…
10 replies
My requirement is to have an automated way of figuring out the settings of configuration properties…
3 replies
How would i make the following update statements into a single statement without missing any criter…
1 replies
Viewing 15 topics - 3,166 through 3,180 (of 12,230 total)
You must be logged in to create new topics.