Viewing 15 posts - 8,626 through 8,640 (of 13,882 total)
A CLR TVF is the fastest and best, in my opinion. Is that an option for you?
March 9, 2015 at 11:38 am
Another option here is to use SSIS, where you have instant access to C# via script tasks.
March 9, 2015 at 8:15 am
It has to be said: this is a very weird requirement. I would be interested to know why you are doing things this way – are you able to provide...
March 6, 2015 at 10:17 am
davoscollective (3/6/2015)
omarlopez7 (3/6/2015)
In that case not work, i says if you us on the where section like this.Select * from table
where date between '12-12-12' and '12-31-12'
Between is inclusive of the...
March 6, 2015 at 6:37 am
omarlopez7 (3/6/2015)
In that case not work, i says if you us on the where section like this.Select * from table
where date between '12-12-12' and '12-31-12'
I do not understand your point.
BETWEEN...
March 6, 2015 at 6:27 am
rolinoberto (3/6/2015)
suppose I have an application, which is used to fill and use the information stored in a database, suppose (after...
March 6, 2015 at 6:18 am
omarlopez7 (3/6/2015)
This will do the same you have in the where section, go from day 25 to 29. Give it a try,i used before and works great.
Here is me 'giving...
March 6, 2015 at 6:08 am
Sure. Copy the text from the results grid, paste it into SSMS and execute it.
March 6, 2015 at 5:57 am
omarlopez7 (3/6/2015)
"Last_Status_DT >= '2013-10-25'
AND Last_Status_DT < '2013-10-29';"
For this one
"Last_Status_DT between '2013-10-25' and '2013-10-29';"
And...
March 6, 2015 at 5:35 am
See if this gives you what you need.
if object_id('dbo.tab1', 'U') is not null
drop table dbo.tab1
create table dbo.tab1
(
a int primary key
,b text
...
March 6, 2015 at 5:18 am
rolinoberto (3/6/2015)
I am new to this forum and to SQL world.
I need your help to find a solution for my headache, my question is:
I am using SQL...
March 6, 2015 at 3:40 am
Ron, you should try this out in on a test server.
There is no problem at all in overriding the connection string of a connection manager using an environment. No parametrization...
March 5, 2015 at 11:00 am
Nevyn, the idea of having multiple environments in the same SSISDB instance for Dev/QA/Prod etc makes me shudder.
There is too much risk of running a package with the wrong env...
March 5, 2015 at 10:57 am
Does my version work?
declare @temp table (ID int);
declare @i int = 1;
while (@i < 1000)
begin
insert into @temp
values (@i);
...
March 5, 2015 at 4:45 am
ramyours2003 (3/5/2015)
from one of my colleague he said by changing the compatibility mode while restoring the backup from sql 2014 to sql 2012
This will not work. Compatibility mode affects...
March 5, 2015 at 4:09 am
Viewing 15 posts - 8,626 through 8,640 (of 13,882 total)