sksankararaman (8/22/2008)

---

Hi every body!

I am new SQL. I can write some amount of queries. I have this problem and I am looking for a solution.

I have one table which has...

sksankararaman (8/22/2008)

---

Hi every body!

I am new SQL. I can write some amount of queries. I have this problem and I am looking for a solution.

I have one table which has...

sg (8/22/2008)

---

Thanks a lot Amit Khanna.. 🙂 Great job..

Updating the temp table as done by Arjun tewari wont work

declare @i int

set @i=234

update #temps set @i = cl_bal = @i...

Chirag (8/22/2008)

---

arjun.tewari (8/22/2008)

---

arjun.tewari (8/22/2008)

---

sg (8/22/2008)

---

create table #Temps

(

num int, OP_Bal int, quantity int

)

insert into #Temps values(1, 234, 12)

insert into #Temps values(2, 234, 08)

insert into #Temps values(3, 234, 9)

insert into #Temps values(4,...

roy.halvorsen (8/22/2008)

---

I have some problems with a creating a Select statement. The query includes 2 tables: tUsers (UserId (PK), ParentId (PK)) and tFamilyConn (UserId, FName, LName, Sex, DateOfBirth, DateOfDeath). Both...

arjun.tewari (8/22/2008)

---

sg (8/22/2008)

---

create table #Temps

(

num int, OP_Bal int, quantity int

)

insert into #Temps values(1, 234, 12)

insert into #Temps values(2, 234, 08)

insert into #Temps values(3, 234, 9)

insert into #Temps values(4, 234, 11)

select...

sg (8/22/2008)

---

create table #Temps

(

num int, OP_Bal int, quantity int

)

insert into #Temps values(1, 234, 12)

insert into #Temps values(2, 234, 08)

insert into #Temps values(3, 234, 9)

insert into #Temps values(4, 234, 11)

select *...

Ray Herring (8/20/2008)

---

I am trying to partition a large table (23MRows and growing) which is primarily an archive. I have set up the base tables and defined an appropriate...

Exactly, Go for the derived table it is much much more performant than a sub query.

BTW, AFTER LOOKING AT THE DATASET, how do you define a member to be the parent of other?

soren kongstad (8/20/2008)

---

Hi

I have a dataset that looks like this

id Code Text

001 A ...

Man the requirement of this fellow is that his table name is also dynamic. 😎

Abhijit More (8/20/2008)

---

Okay, the scenario is i have custom filter, which stores the SearchTable, SearchColumnName & SearchParameterValue in table in different columns like Product in 1 column | ProductName in...

Johannes Fourie (8/20/2008)

---

Another option would be to do the delete on an insert trigger, it would add additional overhead on the table, but if the table does not have too...

Spend some time in converting the external data as pr YOUR requirement and avoid further pains.