Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-02-13 : 13:46:49
|
GReetingsI have a table variableDECLARE @BranchWorkLoad TABLE( [Date] [nvarchar](31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DefinitionValue] [float] NOT NULL, [DefinitionDate] [datetime] NOT NULL, [Week] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL )When doing INSERT INTO @BranchWorkLoad how can go ahead and insert values even if the SELECT returns no rows. force feed it :) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 13:49:47
|
| if select returns no values what values should you insert as default? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-02-13 : 13:54:26
|
| shoot me in the head..move my question to that list you guys keep of dumb questions ok time for coffee break. sorry about that stupid question.... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 13:56:01
|
quote:
Originally posted by yosiasz
shoot me in the head..move my question to that list you guys keep of dumb questions ok time for coffee break. sorry about that stupid question....
no worries  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
INSERT values when SELECT returns no rows
Tara Kizer