Viewing 15 posts - 7,441 through 7,455 (of 13,876 total)
One way is to create a SQL Agent job which runs the package.
Then allow the user to run a proc (possibly using EXECUTE AS to escalate the rights of the...
March 7, 2016 at 10:14 am
The error message mentions SEQ_NUM. Put something in that.
March 7, 2016 at 8:33 am
RV16 (3/7/2016)
No, I just give same title by mistake but I want to insert some data not update. I am now on next step of my phase.Thanks
Different question, but similar...
March 7, 2016 at 8:19 am
etl2016 (3/4/2016)
My query extracts from DW and manufactures a summarised aggregate table, which has 1 day information per record, so,...
March 4, 2016 at 1:49 pm
ripas (3/4/2016)
I couldn't set that allow null property. It has primary key...Is there any other way to do this?
No, you cannot force NULLs into a column that has been defined...
March 4, 2016 at 11:29 am
ripas (3/4/2016)
I want to transfer advisors from student_div_master to advisor_stud_table but because of null values I get an error.
advisor_stud_table has primary key. Is there any other way to copy some...
March 4, 2016 at 9:30 am
etl2016 (3/4/2016)
Hi,Does SQL Server allow programming within a SELECT statement?
For instance, SELECT col1, col2 (some programming result) as Col3 FROM tables
Could you please share some thoughts.
thank you
Yes.
Select Col3...
March 4, 2016 at 9:27 am
below86 (3/3/2016)
Phil Parkin (3/3/2016)
below86 (3/3/2016)
Jeff Moden (3/2/2016)
oneteabag (3/2/2016)
...but the challenge is every section is pretty much relying on the output from the previous section.
So why not use the single...
March 4, 2016 at 9:26 am
TheSQLGuru (3/3/2016)
March 3, 2016 at 8:50 am
below86 (3/3/2016)
Jeff Moden (3/2/2016)
oneteabag (3/2/2016)
...but the challenge is every section is pretty much relying on the output from the previous section.
So why not use the single proc with the...
March 3, 2016 at 8:36 am
Try
WHERE DXCD1 IN ('7140') OR DXCD1 IS NULL
March 3, 2016 at 8:33 am
March 3, 2016 at 7:37 am
shamshad.ali (3/3/2016)
So I need some kind of script...
March 3, 2016 at 7:00 am
Mike Wiz (3/2/2016)
For example code=1234, keywords=bakery,baking,pastry
I want to search against another table that has titles, looking at all...
March 3, 2016 at 6:45 am
Viewing 15 posts - 7,441 through 7,455 (of 13,876 total)