Viewing 15 posts - 1,006 through 1,020 (of 2,894 total)
davdam8 (10/26/2012)
It returns 3 values:370015.120000
20000.000000
123812.953300
Just three rows?
Or it does return this:
370015.120000
370015.120000
20000.000000
20000.000000
123812.953300
123812.953300
123812.953300
The sum you have mentioned is the SUM of the above sequence....
October 26, 2012 at 7:49 am
declare @tMaster table (idMaster int, textFR varchar(20), textEN varchar(20))
declare @tChild table(idChild int, idMaster int, textFR varchar(20), textEN varchar(20))
INSERT INTO @tMaster values(1, null, null), (2, null, null)
INSERT INTO @tChild values(1,1 ,'element...
October 26, 2012 at 7:15 am
davdam8 (10/26/2012)
Can't figure it out here:
Why SUM of (123812,953300 + 20000,000000 + 370015,120000) result used in the query below = 1151469,099900...
October 26, 2012 at 6:26 am
...
UPDATE fi SET fi.cor = 'Y', fi.tam = 'Z'
FROM fi (NOLOCK)
WHERE (case when fi.ref = '' THEN fi.oref ELSE fi.ref end)...
October 26, 2012 at 5:25 am
GilaMonster (10/26/2012)
That's doubly wrong, because EXISTS with correlated subqueries does not perform equally with joins, it's usually very, very slightly better (and actually they're not even equivalent query forms)
Agree with...
October 26, 2012 at 5:15 am
There is another way, I'm not sure about it's performance, but it takes less lines :hehe::
CREATE FUNCTION dbo.FindMinMaxDate4 (@v1 DATETIME, @v2 DATETIME, @v3 DATETIME, @v4 DATETIME)
RETURNS TABLE WITH SCHEMABINDING AS
RETURN
...
October 24, 2012 at 2:09 am
Use surrogate Primary Key (the best and simple in in SQL server will be having INT IDENTITY PK, you don't need to add "firstname+lastname" to it). Use IndividualPersonalKey as another...
October 24, 2012 at 1:56 am
harri.reddy (10/22/2012)
they gave me docs,which field they need and what lenght of data type.
my question is ,should i create logical /physical data model or start making table in sql server...
October 22, 2012 at 10:24 am
davdam8 (10/22/2012)
Here it goesSELECT PROJ, CARAC
FROM X
WHERE CARAC<>''
ORDER BY CASE WHEN CARAC= 'None' THEN CARAC ELSE CARAC END DESC
This is what I got at the moment.
Thanks
Regards!
Can you that is a...
October 22, 2012 at 10:10 am
...
Is that a claim that any design using identity (or any other auto-generated surrogate key) is inherently awful ...
Yes it is his claim, and you can find it in one...
October 22, 2012 at 7:36 am
You don't need to duplicate your posts 😉
http://www.sqlservercentral.com/Forums/Topic1375152-1292-1.aspx
October 22, 2012 at 7:16 am
In short: you can use INSERT with OUTPUT clause.
But, if you could specify which table you are going to load your data from, that would allow to advice you in...
October 22, 2012 at 7:14 am
If you really want, you can code it like that:
IF 1 <> 1
BEGIN
EXEC ('ALTER DATABASE TempDB SET RECOVERY SIMPLE WITH NO_WAIT')
END
October 22, 2012 at 7:05 am
Plzz follow this: http://www.sqlservercentral.com/articles/Best+Practices/61537/
😉
October 22, 2012 at 6:07 am
...and plan offers to create an index.also logical reads decrease
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[Trans] ([Kind],[Date])
INCLUDE ([ReferenceNum],[UID],[Success],[Counter])
Then go for it!
October 20, 2012 at 7:24 am
Viewing 15 posts - 1,006 through 1,020 (of 2,894 total)