Viewing 15 posts - 946 through 960 (of 2,452 total)
david.dilworth (1/18/2016)
'Cornish' AS TheLanguage
Well there's something that you don't see every day 😉
I think Phil meant "Welsh" not "Cornish"
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 18, 2016 at 5:35 am
possibly ??
SELECT tb_1.SKU1,
tb_2.SKU2
FROM tb_1
INNER JOIN tb_2 ON LEFT(tb_1.SKU1, CHARINDEX('-', tb_1.SKU1)-1) = tb_2.SKU2;
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 15, 2016 at 9:50 am
maybe maybe not....would be a whole lot easier with sample data.....:doze:
WITH cte
AS
(SELECT zipcode,
ROW_NUMBER() OVER(PARTITION BY ZipCode ORDER BY ZipCode) AS rn
FROM Postal_Codes_Import
)
INSERT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 15, 2016 at 8:00 am
Eirikur Eiriksson (1/14/2016)
krypto69 (1/14/2016)
I ended up using:
CREATE TRIGGER NoDeleteMedicalGroup ON dbo.Medical_Group
INSTEAD OF DELETE
AS
BEGIN
ROLLBACK;
END;
No items in the Medical group table should ever be deleted....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 14, 2016 at 9:52 am
possible solution ??
USE TEMPDB;
IF OBJECT_ID('TEMPDB..yourtable', 'U') IS NOT NULL DROP TABLE TEMPDB..yourtable ;
CREATE TABLE yourtable(
PlanName VARCHAR(5) NOT NULL
,YearID ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 13, 2016 at 7:21 am
sorry
http://www.brentozar.com/archive/2013/11/what-you-can-and-cant-do-with-indexed-views/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 13, 2016 at 3:02 am
this link may help you
http://www.brentozar.com/archive/2013/11/what-you-can-and-cant-do-with-indexed-views/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 13, 2016 at 2:28 am
SQLisAwE5OmE (1/11/2016)
J Livingston SQL (1/11/2016)
am sure it will make providing you a tested solution so...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 11, 2016 at 2:57 pm
is there any reason why you cannot / will not provide sample data for your table?
am sure it will make providing you a tested solution so much easier for everyone.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 11, 2016 at 1:48 pm
Rankerg (1/10/2016)
Yes I think this is pretty close, I want the amended and new records in a NEW File
give us a clue......how close? whats incorrect?
sample scripts as already asked...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 11, 2016 at 12:11 pm
GilaMonster (1/11/2016)
Steve Jones - SSC Editor (1/11/2016)
Grant Fritchey (1/11/2016)
One of my favorite songs. Although Bauhaus actually did...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 11, 2016 at 10:59 am
karine.gambarjan (1/11/2016)
In the beginning I just wondered how do I define DATEDIFF =1 between two data rows for the same Product and ID....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 11, 2016 at 8:54 am
your rules appear to change as you go along.......please read this article and post back with some scripts that fully demonstrate what you require.
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum
shot in the dark
SELECT product,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 11, 2016 at 8:00 am
Hi
welcome to SSC......
your question isnt clear to me...suggest you read following article and post back.
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 11, 2016 at 7:55 am
Eirikur Eiriksson (1/10/2016)
{thundering voice in the background}CALM DOWN😎
you, me or OP?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 10, 2016 at 2:35 pm
Viewing 15 posts - 946 through 960 (of 2,452 total)