Quick thought, you can use something like the relevant part in this script

😎

SELECT

DB_NAME() ...

Adding a little bit of tinkering based on the operator cost results in the previous post, mainly changing from the CASE to a WHERE clause for filtering. Not a big...

You should still change the data type...

If you do then the trigger should work. Can you post a DDL (create table) script for the table?

😎

Quick question, can you change the data type for the commenthtml column from TEXT to NVARCHAR(MAX)?

😎

Quick thought, normally would do this using VBA function wrapper, especially if the output spans multiple cells and/or the procedure has parameters. Very powerful stuff if done properly.

😎

Chipping in my 2 cents, using a version / source control is good where it is applicable or possible but when it isn't, a combination of bcp and a simple...

Hi and welcome to the forum, here is a quick and straight forward sample, should be enough to get you passed this hurdle.

😎

Note: Suggest that you revise the design...

Lynn Pettis (11/2/2014)

---

Actually, the n is the number of the row to start with. ...

Quick suggestion, use the FIRSTROW = n, n = number of rows to skip

😎

Jeff Moden (10/30/2014)

---

Now we're cooking with gas! Well done! I had eye surgery today (lens replacement) and can't see so well yet and can't spend much time in...

Adding some gas supplies for the stove, first there are five methods for replacing logical operators or comparison operator combination equivalent thereof with a single comparison operator.

😎

USE tempdb;

GO

SET NOCOUNT ON;

...

Looking at the XML and the expected results, it is apparent that something is missing in the description;-)

The code below is slightly verbose in order to be self explanatory, note...

Quick window function based solution with xml path concatenation, should get you passed this hurdle.

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.data_set') IS NOT NULL DROP TABLE dbo.data_set;

create table dbo.data_set (id int primary...

Some additional knowledge/information/logic is needed to complete this as djj mentioned, here is some quick code to get you started.

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.Webs') IS NULL

BEGIN

Create Table dbo.Webs

(

FullURL nvarchar(255)

);

Insert...