So do you want both rows excluding or only one of the rows?

Eg which data set do you want to see

210,2,212

410,1,141

329,7,231

or you need the data set to look like

110,1,112

210,2,212

310,3,313

410,1,141

329,7,231

The only way that I can think of is to have an SQL Agent Job running on a schedule that updates the record that have expired. However unles you...

Thanks Lowell,

I love playing with kewl stuff in SQL server, thankfully I've got a couple of instances on VM's I can play around with in case I mess up 😀

Fair enough, just curious why the backup wasnt an option, and a detach in this situation is the best way of doing it.

I would still find out why access...

I've seen that thread I'm not a fan of triggers on tables (personal preference) so hardly ever use them, but that doesnt mean its a bad thing.

It does need...

I would speak to the network admin about obtaining rights as those folders are locked down for a reason, and either ask someone with the correct privlages to copy them...

laurie-789651 (9/28/2012)

---

If you do the CAST on the first value to be processed, that should fix it:

-------------------------------------------------------------------------

DECLARE @A Int, @b-2 Int, @C Int;

SELECT @A = 9,

@b-2 = 3,

@C = 2;

SELECT...

I've just debugged it and theres a fault in the original CTE not parsing the last value in the list.

so I've 'tweaked' it to add on a terminator, such...

If you select those values into variables, then the Insert is very simple,

WITH CTE AS (

SELECT CHARINDEX(CHARS,@STRING,1) x

,...

No idea, did you click on the edit mapping button, which should bring up a list of the source columns, you will need to select the data type for the...

I'm never sure if this is a bug or not in SQL server, but for some reason if the Divisor is an Integer, the result will also be an Integer.

If...

Its a fairly straight forward Insert, the issue you will have is that you need to define the fk_visbox_id and fk_msgIn_id columns otherwise the Insert will fail as these are...

Ok, you will need to go through and redefine the Excel column widths and datatypes to match the destination table.

this is done when you are on the Select Source...

The problem with exporting to excel is that the text is assumed to be varchar/nvarchar 255, as excel doenst hold the original field lengths.

Why not just cut out the middle...

I take it you want to pivot the results so that they are on a single row rather than on several rows.

DECLARE @CHARACTERS TABLE (CHARS CHAR(1))

INSERT INTO @CHARACTERS VALUES

('N'), ('E'),...