Topics
Started by
Posts
Last post
Hello, I have a simple question, is it possible to make order query like: select .... order by item…
4 replies
Is there any advantage/disadvantage to including the BEGIN and END block in a simple stored proc, i…
24 replies
Hi All, The following statement is called from the front end application. SELECT MAX(DOC_RECEIVED_D…
19 replies
Can I build a index on a temporary table in a stored procedure?
2 replies
I'm looking into some coding of SP's in a database and see this construction several times: DECLARE…
21 replies
Hello Everyone, We would like to have a T-SQL script to purge some data based on several conditions…
4 replies
Here's my situation. For some insane reason, my power user for an application set up his students w…
2 replies
If I have date values as follow. 7/13/2008 7/14/2008 7/15/2008 7/16/2008 7/17/2008 7/18/2008 7/19/2…
2 replies
I have 3 date params. @Now @MonthFrom @YearFrom What is the best practice? 1.) do my count as a sub…
1 replies
Hi, all My SP runs slowly. I checked the source codes and found it is because of using the followin…
23 replies
select CAST('0061' as numeric(4,3)) This is silly but I'm stumped by this statement giving me an er…
4 replies
Hi All, I am trying to insert some error handling to the sql script below to delete duplicate recor…
2 replies
I have trouble to write the select statement to reset the sequence number when value of one column …
9 replies
Hey Hey, I need some Help, I Got a bit of homework 2 do yesterday and I cant seem to Figure it out.…
22 replies
i have 6 rows in a table so what i need to do is i will be inserting the data from other table int…
2 replies
Viewing 15 topics - 2,536 through 2,550 (of 17,082 total)
You must be logged in to create new topics.