Viewing 15 posts - 8,086 through 8,100 (of 8,760 total)
This is straight forward, the main pitfall is that the node value must either be typed (XSD) or referenced with text().
😎
USE tempdb;
GO
/* Create a table (variable) */
DECLARE @XMLUPDATE TABLE
(
...
June 5, 2014 at 11:16 pm
dirk.dromgoole (5/20/2014)
June 5, 2014 at 10:34 pm
An even simpler solution is to grab the output into a table variable which then can be used to get the old-new values for the identity map table.
😎
DECLARE @INSVAL TABLE
...
June 5, 2014 at 8:16 pm
This should get you started, notice I changed the data type of the monetary value, float is not the appropriate type!
😎
USE tempdb;
GO
create table #prova
( Valuta varchar(2),
Misura DECIMAL(18,5)
)
insert into #prova values...
June 5, 2014 at 7:26 pm
Luis Cazares (6/5/2014)
thomashohner (6/5/2014)
But how would you alias those continents?:hehe::hehe:***Just Kidding
I could alias them and join them. 😀
SELECT *
FROM NorthAmerica na
JOIN SouthAmerica sa ON na.PanamaSouthBorder = sa.ColombiaNorthBorder
JOIN Europe ...
June 5, 2014 at 6:42 pm
scotteb (6/4/2014)
June 5, 2014 at 1:43 am
ramana3327 (6/5/2014)
I am still new to the SQL Server. So I want to know all your experiences.
If you want send a report that the SP is taking this time and...
June 5, 2014 at 1:11 am
ramana3327 (6/4/2014)
If we forget about mine and come to the general situation. In usually what could be the possible reasons causes of high execution time if we execute SP immediately...
June 4, 2014 at 2:30 pm
SQLRNNR (6/4/2014)
LightVader (6/4/2014)
SQLRNNR (6/4/2014)
How about 1 big monitor and 1 projector?Then it is like having 2 monitors but you really only (technically) have 1.
I hooked up my old SNES to...
June 4, 2014 at 12:14 pm
Unfortunately the situation leaves us purely guessing, as far as we can tell, the first execution bulk loads million records and the next writes engraves them in Sanskrit.
😎
June 4, 2014 at 12:06 pm
Rudyx - the Doctor (6/4/2014)
These are Windows Server vulnerabilities methinks - these and any other MS security hot-fixes should ALWAYS be applied.
It is an OS scope threat, as I said...
June 4, 2014 at 11:56 am
Jeff Moden (6/3/2014)
My greatest pet peeve of all is what some people claim to be "best practices".
The plural makes it sound like polygamy
😎
June 3, 2014 at 1:22 pm
June 3, 2014 at 1:15 pm
Why not use the Split function?
😎
June 3, 2014 at 1:14 pm
rahulabhinav15 (6/3/2014)
Actually the excel sheet gets createdin the...
June 3, 2014 at 1:08 pm
Viewing 15 posts - 8,086 through 8,100 (of 8,760 total)