Viewing 15 posts - 1,921 through 1,935 (of 5,504 total)
What do you need that c.u.r.s.o.r. for?
Unless I'm missing something, the following statement should do it:
UPDATE #mytable
set permitnum =
case
when id = 1 then permit1
when id = 2 then permit2
when id...
February 14, 2011 at 5:12 pm
Just remove the "as" between your column names and the data type.
Example:
Instead of
FranchiseGroup as varchar(255),
use
FranchiseGroup varchar(255),
February 14, 2011 at 2:46 pm
Matt_V (2/14/2011)
Quick question,...
February 14, 2011 at 1:02 pm
Would it be an option to add those three calculations as computed persisted columns?
It came to my mind when you stated the inbound is infrequent...
February 14, 2011 at 12:38 pm
Just search thissite for "string concatenate for xml path".
February 14, 2011 at 12:28 pm
rameshbhumi (2/14/2011)
We are also seeing these Queries getting triggered from BO Server to Database. I would like to know what exactly the purpose of these Queries. It will be Great...
February 14, 2011 at 11:25 am
duplicate post. No replies please.
Discussion already started here.
@praveen: I asked you before not to yell at us. All it does is limiting the replies you might get.
February 13, 2011 at 5:53 am
duplicate post. No replies please.
Discussion already started here.
@praveen: I asked you before not to yell at us. All it does is limiting the replies you might get.
February 13, 2011 at 5:53 am
praveensc2003 (2/13/2011)
still i am getting error message. Could you please help me to resolve this issue
Msg 547, Level 16, State...
February 13, 2011 at 5:46 am
Except for the double usage of some parts of the statement it shoult work...
DECLARE @DeleteOutput3 TABLE (CONID INT PRIMARY KEY CLUSTERED)
DELETE Contact
OUTPUT
deleted.CONTACTID
INTO @DeleteOutput3
WHERE CONTACTID = 10;
DELETE FROM SalesHeader INNER JOIN
@DeleteOutput3...
February 13, 2011 at 4:09 am
Please read and follow the advice given in the first link in my signature on how to provide sufficient information. This will include table def, ready to use sample data,...
February 13, 2011 at 4:02 am
rajesh-303966 (2/12/2011)
Is it possible to make the pos=1 and RtnSetid1 dynamic as
By declaring variable value upto 6 for ex. x <= 6 posx and RtnSetidx likethat....
Kindly help me on...
February 13, 2011 at 3:39 am
Ninja's_RGR'us (2/12/2011)
That's precisely why Mr Magoo was asking the question. That's something that should be handled at the presentation layer. Not by t-sql.
While it CAN be done....
February 13, 2011 at 3:24 am
There are two issues:
#1: in line 1 you have [Customer Customer ID="1" ] There seems to be an additional blank after the second "Customer". It should either be Customer_ID or...
February 12, 2011 at 4:36 pm
Viewing 15 posts - 1,921 through 1,935 (of 5,504 total)