Viewing 15 posts - 46 through 60 (of 9,643 total)
Now add the WHERE clause:
INSERT INTO
[Tbl_ComputerInventory]
(
[ComputerName]
, [SerialNumber]
...
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...
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?
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...
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,
...
December 28, 2017 at 4:03 pm
December 6, 2017 at 12:26 pm
December 1, 2017 at 9:54 am
Thanks for your reply. Yes, this code has been returning about 15 million rows...which...
December 1, 2017 at 7:53 am
November 16, 2017 at 8:22 am
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...
October 17, 2017 at 6:37 am
October 13, 2017 at 6:48 am
October 3, 2017 at 5:00 pm
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...
September 15, 2017 at 4:31 pm
Viewing 15 posts - 46 through 60 (of 9,643 total)