Topics
Started by
Posts
Last post
Hi i am really struggling here I have a weird character string that has all sorts of funny characte…
5 replies
How do i use "orelse" in sql server, "orelse" similar to VB.net example: select a,b from table wher…
5 replies
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
Viewing 15 topics - 3,166 through 3,180 (of 12,234 total)
You must be logged in to create new topics.