gravitysucks (8/25/2012)

---

dan-572483 (8/24/2012)

---

If the length of the string might vary - but there will always be brackets - this will work:

declare @string varchar(max)

set @string = '{String you want to remove...

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(

...

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...

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...

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,'')

Nice to learn new thing. Thanks

Hugo Kornelis (8/23/2012)

---

mtassin (8/23/2012)

---

So what purpose did leaving out the table create statements or saying that we have to assume that they exist in the text prior to the code...

check the database MCW2 permissions available to the role...

here is a better link ..

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/abc8e23d-0169-4cf8-a546-3dd0a5758d21

SqlServerTroubleMaker (8/19/2012)

---

New query window

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...

That's strange ....

I never encountered such issue ...

you said that there is something else too , what was that ??

create a view with visible columns ; have permission set...

rVadim (8/19/2012)

---

naisu1383 (8/19/2012)

---

Actually i am counting mail returns for month field if any. So for that i need count of month for particular month and then total of mail returns...

naisu1383 (8/19/2012)

---

Actually i am counting mail returns for month field if any. So for that i need count of month for particular month and then total of mail returns for...

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...

when you...