First, I'll give 3 little whines...

- You made tables in filegroups different than PRIMARY. If you do this, please create those filegroups beforehand.

- Please add after the DDL all necessary...

I'm afraid there isn't a real sweet piece of code... You can get the data from the syscolumns and sysobjects tables and from this make a cursor or similar loop....

sello Moloto (11/18/2008)

---

Hi

I want to set my database property to return a decimal number when I do division .

e'g select 1/10 should return 0.1 instead of 0

how do I...

Lee Hemmings (11/17/2008)

---

I have a SSIS package which I want to export data on a daily basis; it writes to excel file once but then will error if I run...

timscronin (11/14/2008)

---

Order table

orderid shipto locationid

1 acf fcd

2 ...

milan (11/14/2008)

---

Hi all,

Could you please help me to move data from one table to another? It's a bit tricky.

a. Table A has 2 colums

1.map 2....

timscronin (11/14/2008)

---

No actually join to one other table based upon columns in the first table. If shipto is null use location, if shipto has a value use that and...

I don't think a natural join specifically exists in TSQL... And the only thing I can think of what it could mean is a normal join between 2 tables with...

Are you trying to say you're looking for another job? Or that the company you work for is just positive by design?

cindy_sinath (11/9/2008)

---

I am trying to do a count or a sum on

Categories where 001, 003, 004 are Tests and 002 are sessions. All these codes exists under one field called...

Pooja_prasad (10/29/2008)

---

thnkz.

I know the above syntax but I got to know that there is an insert...set form also. Or is it that it is present only in MySQL and not...

Pooja_prasad (10/29/2008)

---

I need to use the insert...set form in my code but the statement i have written is not working.

insert into contactinfo

...

Of course your table desc and the actual procedure helps, but for testing and understanding purposes you really should put some sample data into a post, using the guidelines in...

Davroche (10/29/2008)

---

We need the DDL for the table(s), create statements. The tables are already there I did not create them. I am simply querying the data. I...

Arul Manoj (10/22/2008)

---

Hi,

Actually my table has below structure:

RowNumber UserId UserNmae TimeDifferenceInMinutes

1 ...