Insert into table using select query

Depends how you are running the query, but i would use a CTE to create a table of 4,5,6,7:

with num as (
 select 4 as num
 union all 
 select num +1
 from test 
 where num < 7)
Insert into S_GLOBALFIELDS_FACT(S_ID,B_ID,G_ID,AMOUNT)
select '150',nums.num,G_ID,AMOUNT 
from S_FACT, nums
where S_ID=2 and B_ID =(2)

That will insert 4 items for each row where B_ID = 2

If you want the B_ID to be selected where B_ID = 4, 5, 6 or 7 then just use a "IN" operator:

Insert into S_GLOBALFIELDS_FACT(S_ID,B_ID,G_ID,AMOUNT)
select '150',nums.num,G_ID,AMOUNT 
from S_FACT, nums
where S_ID=2 and B_ID IN (4,5,6,7)

Hope that helps ^_^
Andy


UPDATE: How to pass arrays as parameters
Assumptions:
1: You're using sql server 2008 or later.
2: You're using SqlClient Connection in your code.

First you have to create a user defined type:

CREATE TYPE int_list_table AS TABLE (n int NOT NULL PRIMARY KEY)

This will be stored in your database for future use. You can use this as a stored procedure parameter.

Create Procedure My_Insert(
@ids as int_list_table
)
AS
BEGIN

  
  Insert into S_FACT(S_ID,B_ID,G_ID,AMOUNT)
  select '150',B_ID,G_ID,AMOUNT 
  from S_FACT s
  inner join @ids i on s.B_ID = i.n
  where S_ID=2

  /* or using "IN"
  Insert into S_FACT(S_ID,B_ID,G_ID,AMOUNT)
  select '150',B_ID,G_ID,AMOUNT 
  from S_FACT 
  where S_ID=2 and  B_ID in (select n from @ids)
  /*
END

You can pass the array as a parameter without specifying a type

using (conn)
{
    SqlCommand cmd = new SqlCommand("dbo.My_Insert", conn);
    cmd.CommandType = CommandType.StoredProcedure;
    SqlParameter dtparam = cmd.Parameters.AddWithValue("@ids", ids);
    dtparam.SqlDbType = SqlDbType.Structured;
}

I hope that helps ^_^
Andy