John Mitchell-245523

Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 7,191 total)

RE: Identify objects that do not use an Identity Column but a Lookup Table to generate an Unique Identifier

Welsh Corgi - Monday, January 23, 2017 8:33 AM
How should I modify this query to identify the table name?

January 23, 2017 at 8:55 am

#1924415
RE: How to get hardcoded date form table

This should help you.
John

January 23, 2017 at 8:34 am

#1924411
RE: How to get hardcoded date form table

SELECT @ret = CASE WHEN MAX(Date) IS NULL
THEN c.Value
ELSE MAX(Date)
END
from dbo.EmpDate e
JOIN Config c ON c.id = 1
where e.Sa=...

January 23, 2017 at 8:15 am

#1924403
RE: Group multiples values together

jcobb 20350 - Monday, January 23, 2017 7:38 AM
I have three stocking locations. Two are within the same physical building but considered...

January 23, 2017 at 7:46 am

#1924400
RE: User Permission to view Only View not base tables

Rechana Rajan - Monday, January 23, 2017 5:59 AM
John Mitchell-245523 - Monday, January 23, 2017 3:03 AM

January 23, 2017 at 7:30 am

#1924397
RE: Indexes

GilaMonster - Monday, January 23, 2017 3:24 AM
Welsh Corgi - Monday, January 23, 2017 2:58 AM

January 23, 2017 at 3:33 am

#1924348
RE: Indexes

Welsh Corgi - Monday, January 23, 2017 2:58 AM
Steve,
So are you telling me if a have for example an index...

January 23, 2017 at 3:20 am

#1924345
RE: User Permission to view Only View not base tables

Since all schemas in question are owned by the user dbo, you shouldn't have a problem with ownership chaining. I recreated what I think your database looks like...

January 23, 2017 at 3:03 am

#1924342
RE: Query Help

s-sql - Friday, January 20, 2017 8:52 AM
Need help on a query to generate a two incremental values on below table.
Both the...

January 20, 2017 at 9:13 am

#1924075
RE: why is this trigger not working ?

Senchi - Friday, January 20, 2017 7:33 AM
John Mitchell-245523 - Friday, January 20, 2017 7:18 AM

January 20, 2017 at 7:58 am

#1924044
RE: retrieving global variable for trigger

sgmunson - Friday, January 20, 2017 7:02 AM
I'd love to know how that would ever be possible... To my knowledge,...

January 20, 2017 at 7:42 am

#1924038
RE: Suggestions and Ideas for Maintenance Plans

luismarinaray - Friday, January 20, 2017 7:11 AM
Hi,
I am requesting ideas, to take courage to speak to my boss.
I am administering more...

January 20, 2017 at 7:22 am

#1924025
RE: why is this trigger not working ?

Thom A - Friday, January 20, 2017 7:05 AM
Senchi - Friday, January 20, 2017 5:33 AM

January 20, 2017 at 7:18 am

#1924021
RE: Converting Stored Procedure to Function

Start by getting rid of the WHILE loops. As I mentioned in another of your threads, there's absolutely no need for them just to generate blank rows. After that,...

January 20, 2017 at 7:14 am

#1924014
RE: Identify objects that do not use an Identity Column but a Lookup Table to generate an Unique Identifier

Welsh Corgi - Thursday, January 19, 2017 9:36 AM
Yes I know how to identify objects that do not have an identify column.
I...

January 19, 2017 at 9:42 am

#1923768

Viewing 15 posts - 1,966 through 1,980 (of 7,191 total)