Topics
Started by
Posts
Last post
Is there a way to determine the name of the procedure that called a procedure? If a procedure is 5…
4 replies
A little help required if possible... I am trying to create a report that calculates and returns a …
3 replies
G'day all! I am finding myself creating quite a few views lately and wondered if there was a way I …
8 replies
I need to write some logic using SS2K that will remove certain characters in a string. Right now, …
6 replies
Hi, I need to produce an extract file from a sales table. The extract needs to be in a format of st…
11 replies
All, I have one senario. I will have to pull data from one db (around 7 tables) and then insert int…
2 replies
Hi All, I am new to this so need some expert guidance. In one of my datetime field data is stored i…
7 replies
Hi, i'm checking for a date range in SQL query from .NET app. My WHERE clause has this condition. W…
8 replies
I am transferring data from Progress to SQL Server by setting the Progress DB up as a linked server…
16 replies
I've got a table with a record for each day of the year. Each record has just a few fields. Does …
5 replies
I have this error Server: Msg 443, Level 16, State 1, Procedure fnGetFullWHInformation, Line 71 Inv…
15 replies
i have a complex view that will only return records if i use top. eg "select top 100000 * from Vi…
4 replies
Hi, How can I create a stored procedure that would take an integer @NumRows as input and randomly s…
7 replies
Hi I have one table which is having some records as below. reqno empno deptno fromdate vac_days 1 4…
2 replies
I was wondering about some behaviour in SQL when it comes to inserting duplicate keys... I created …
1 replies
Viewing 15 topics - 2,701 through 2,715 (of 17,082 total)
You must be logged in to create new topics.