Topics
Started by
Posts
Last post
Bit tricky to explain this one... I have a table similar to the following: Ref &nb…
5 replies
Assume the following scenario: a customer wants 10 units A and 20 units B. In stock are (Bad Englis…
4 replies
CREATE PROCEDURE ggg_test_sp @start_date datetime,@end_Date datetime AS SET NOCOUNT ON DECLAR…
4 replies
I am trying to compare data from two quarters that I have. Table structure is the same between both…
6 replies
how do i calculate no. of days between 2 dates in oracle. select expiry_Dt-sysdate as noofda…
5 replies
I have to write a query that eliminate duplicate records from the table.. please help me to do this…
3 replies
PRINT DATEADD(m,1,'20050228') yields: 2005-03-28 Is this a known bug or am I missing something? Doe…
8 replies
I'm returning some records and would like to have the first field be a counter. 1 for the first rec…
2 replies
I've two stored procedures, one which uses a single SQL statement to return data and one which uses…
3 replies
Hi, I am selecting a group of items from a listbox.How to pass those values as an…
2 replies
Hi, Is there any way to retrieve the timezone information from the registry? I am able to read it u…
1 replies
Hi, Is there any UDF for conversion of Hexadecimal to a readable string? Like I have (0xB6FEFFFF00…
1 replies
Hi, I have a situation where I need to calculate some of the Time Differences based on the Timezon…
2 replies
i have table Controller (ControllerID, ControllerNAme, isActive) and tables SendControllerFo…
2 replies
What would be the result of this expression?? declare @month int set @month = -1 select case @month…
1 replies
Viewing 15 topics - 12,406 through 12,420 (of 17,082 total)
You must be logged in to create new topics.