wschampheleer (2/9/2010)

---

SELECT [t1].[Id]

,[t1].[Name]

,[t1].[Designation]

,[t1].[Address]

...

Thank you Ramesh, this is working fine.

I want to use WHILE in my SQL Query, I think somewhere it is getting wrong so the rows in record set are getting repeated in the output.

I have 2...

if the Table2 has structure like as:

Table2

(

Id INT FK(Id) references TAble2,

Value

)

Now, in this table for Id=1,

Id Value

1 Salary

2 Age

3 ...

It seems this would go as per my requirement, but I wanted that impossible way. 🙂

Thank you

In #Table1, the columns are declared explicitly taking in mind the total number of columns combinedly from Query1 and Query2.

Hi,

I tried to insert into #Table1 and I am getting an error as :

The select list for the INSERT statement contains fewer items than the insert list. The number of...

Definition of bltTssVeh is as:

USE [Mark]

GO

/****** Object: Table [dbo].[bltTssVeh] Script Date: 01/22/2010 17:29:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[bltTssVeh](

[Veh_Id] [int] NULL,

[VehicleNo] [nvarchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[TssNo]...

DECLARE @Driver TABLE(DriverName VARCHAR(64), ArrTime SMALLDATETIME, DepartTime SMALLDATETIME, VehicleNo VARCHAR(16), IsLate DATETIME)

INSERT INTO @Driver(DriverName, VehicleNo, DepartTime, ArrTime, IsLate)

SELECT TOP 10 DrvNameMain AS DriverName, ArrTime = @Time,

DepartTime=@DepTime, vehicleNo AS Vehicle,

(CASE...

@ Paul's Query -

1. In the table, there are millions of records stored and are keep on increasing frequently.

2. As per based on date search criteria the records has...

Answers to ur queries:

1. In the table, there are millions of records stored and are keep on increasing frequently.

2. As per based on date search criteria the records has to...

Thank u Adi for your suggestion.

I think the option you gave is good, using a >=and<= operator instead of BETWEEN is much better to know the boudaries of condition.

Thanks...

This is part of my query:

(CASE

WHEN (DATEDIFF(second,Actual.ActualDepartTime,Schedule.SchdDepartTime)/60) >=60

THEN Convert(nvarchar(10),(DATEDIFF(second,Actual.ActualDepartTime,Schedule.SchdDepartTime)/60)/60)+' '+'hr'

Else (DATEDIFF(second,Actual.ActualDepartTime,Schedule.SchdDepartTime)/60) +' '+'min.'

END) AS DeptEarly

Thanks Stewart for your valuable suggestion.

I had thought the same go earlier.

Date period is variable, it depends on user