Viewing 15 posts - 46 through 60 (of 9,643 total)
Now add the WHERE clause:
INSERT INTO
[Tbl_ComputerInventory]
(
[ComputerName]
, [SerialNumber]
...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 29, 2017 at 7:42 am
If you have your databases in an SSDT database Project you can use T4 templates to generate CRUD procedures. I've also used written T-SQL to generate them, but since I...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 28, 2017 at 5:10 pm
Have you considered using SSRS and putting a page break based on customer id and save as a PDF or as Excel?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 28, 2017 at 4:39 pm
Can you post the table definitions including collation for character columns?
If your import table has a case-sensitive collation and your destination table does not you could still get...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 28, 2017 at 4:13 pm
Here's how I get Foreign Key info:
SELECT
FK.name,
SCHEMA_NAME(FK.schema_id) AS schemaName,
OBJECT_NAME(FK.parent_object_id) AS parentTableName,
parentCols.name AS parentColumnName,
OBJECT_NAME(FK.referenced_object_id) AS referencedTableName,
...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 28, 2017 at 4:03 pm
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 6, 2017 at 12:26 pm
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 1, 2017 at 9:54 am
Thanks for your reply. Yes, this code has been returning about 15 million rows...which...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 1, 2017 at 7:53 am
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 16, 2017 at 8:22 am
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 16, 2017 at 8:09 am
Jo Pattyn - Tuesday, October 17, 2017 2:53 AMSorry polluting sql 2017 administration. Why can't migrating SSRS to 2017 be simple?
If things...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 17, 2017 at 6:37 am
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 13, 2017 at 6:48 am
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2017 at 5:00 pm
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 25, 2017 at 11:37 am
Okay, I didn't delve deeply into what was different because the row counts returned where in the 300K range. Basically the difference is that when run in serial the query...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 15, 2017 at 4:31 pm
Viewing 15 posts - 46 through 60 (of 9,643 total)