Viewing 15 posts - 256 through 270 (of 326 total)
gravitysucks (8/25/2012)
dan-572483 (8/24/2012)
declare @string varchar(max)
set @string = '{String you want to remove...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 26, 2012 at 12:03 am
I am not sure but I think he is looking something like this ; and I am still scratching my head to do this in a proper way..
CREATE TABLE #Trips(
...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 25, 2012 at 11:04 pm
open vs2008-new prj - integration prj , that would do the same..
one more thing , for other projects to appear in the menu , you may have to install vs2008...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 25, 2012 at 4:14 am
what kind of relationship , do you have in the tables ?
select customer , count(cust)from CustTable a
left join OrderTable
on customer=Cust
group by customer
this may have been the proper code;
why is that...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 25, 2012 at 12:23 am
Another way to do it using STUFF.
declare @testid varchar(50)=
'{784A4579-8689-438E-ADAA-9DCBC8A88AE7}'
select STUFF(stuff(@testid,len(@testid),len(@testid),''),1,1,'')
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 24, 2012 at 11:31 pm
Nice to learn new thing. Thanks
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 23, 2012 at 11:17 pm
Hugo Kornelis (8/23/2012)
mtassin (8/23/2012)
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 23, 2012 at 12:48 pm
check the database MCW2 permissions available to the role...
here is a better link ..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 20, 2012 at 8:58 am
SqlServerTroubleMaker (8/19/2012)
right click --> Connection --> change connection --> Entered dev named instance name -> got it connected to it (looks like it was, but it wasn't),
in fact...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 20, 2012 at 8:48 am
SqlServerTroubleMaker (8/19/2012)
Bottom right was also showing wrong instance name.
That's strange ....
I never encountered such issue ...
you said that there is something else too , what was that ??
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 20, 2012 at 8:41 am
shivashankara9 (8/19/2012)
yes, 5 columns should visible
as, you said we can do with view
please let me know, how to do with view.
create a view with visible columns ; have permission set...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 19, 2012 at 9:26 pm
rVadim (8/19/2012)
naisu1383 (8/19/2012)
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 19, 2012 at 8:10 pm
naisu1383 (8/19/2012)
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 19, 2012 at 8:08 pm
kaushal_shah26 (8/19/2012)
My main concern: In the future, if we add a new column to tableA then " Insert into tableA (column x, column y, column z) select columnx, columny, columnz...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 19, 2012 at 7:58 pm
shivashankara9 (8/19/2012)
Hi,I have a table with 10 columns
Out of 10, i need to mask 5 columns because i don't want to show those columns in development and testing environment.
when you...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 19, 2012 at 7:39 pm
Viewing 15 posts - 256 through 270 (of 326 total)