Topics
Started by
Posts
Last post
In search of suggestion to rewrite SQL in order to resolve Error Msg returned in SQL 2000 Q/A:…
4 replies
Hello All, I am creating a view, with amongst other fields has the columns startdate and endda…
2 replies
Hi, I want to send the result of a query in the body of a mail message. I'm using sp_send_cdosysmai…
1 replies
Hi I'm trying to do this select but I'm having a error 156, i'm stuck with this. Can anyone help?&n…
10 replies
What I want to do is to create a table displaying time only of the date. BW1 00:00:00 00:30:00 01:0…
4 replies
Either I have been looking at this too long, or it is just not making sense to me... I have functio…
6 replies
Hi, I'm having issue of developing a SQL query to meet the following requirements. I have two table…
4 replies
A developer asked me if there is any way to pull data from a table by actual row numbers. He wants …
7 replies
WE have tables with millions of rows and everytime I try to rename the datatype, I always get this …
3 replies
Hello there, i was wondering whether there was a simple way of getting not just the max valu…
6 replies
I want to be able to take a table and run a query such that the contents of the column become the c…
4 replies
i have a table in my database. it has many about 1000 rows. each row has a programID. When i…
11 replies
Hello All, I remember sometime back that I had read about the same thing, but could not find out. I…
1 replies
i have a sproc that is taking 5 hours+ to run. that was on 40000 rows. even on 25 rows it takes ov…
4 replies
I've imported data from Excel which contains 0D when displayed. I use the following to replac…
4 replies
Viewing 15 topics - 6,511 through 6,525 (of 17,082 total)
You must be logged in to create new topics.