Viewing 8 posts - 1 through 8 (of 8 total)
Hi All,
Thank you very much! These are my insert statements:
_________________________________________________
INSERT STATEMENTS FOR THE LOOK UP TABLE (LutTask)
-- insert LUTtasks that existed yesterday.
INSERT INTO [HRA].[LutTask]
([RequestType] ,[Role] ,[TaskName] ,[ParentTaskCd] ,[Description] ,[FlgDeleted] ,[CreatedBy] ...
June 17, 2019 at 9:51 pm
calbimonte.daniel - Friday, January 4, 2013 9:28 AMI agree.I used the adventureworks project for SQL 2012 for the part 2.http://msftdbprodsamples.codeplex.com/releases/view/55330
It looks like...
March 21, 2017 at 11:38 am
Nice job describing temporal data. I actually didn't know that a series of information was called temporal data.
I also didn't know that the gender of legal entities was '9'.
Thanks...
May 12, 2010 at 8:45 am
In your second article you define postal code as nchar(5). While that works for us zip codes some international postal codes are six characters and must include a...
May 12, 2010 at 8:25 am
According to the MCSE Database Design and Implementation:
Before a stored proc is created, the command syntax is checked for accuracy. If no errors are returned, the proc's name is stored...
April 27, 2010 at 9:12 am
I'm not sure which server version you are using, but in SQL Server 2008 ( including Express ) you can sort the procedures in descending modified date in the Object...
April 27, 2010 at 8:56 am
This is an excellent follow up to the first article. In the example for displaying a comma separated values list of all the test scores for each student, could...
April 19, 2010 at 9:40 am
Greg,
Thanks so much for your suggestions. I don't know very much about DTS, so, can you recommend a resource where can I learn about Lookups and DTS?
Chieko
April 6, 2004 at 7:14 am
Viewing 8 posts - 1 through 8 (of 8 total)