Viewing 15 posts - 886 through 900 (of 13,445 total)
you keep missing the point about how tables do not have a natural or default order in SQL server.
they are treated as unordered rows of data.
all the rows are...
June 15, 2016 at 6:22 am
there is a paid oledb provider from cherrycitysoftware.com(since they cost $, i will not bother with a link) ; with that you could create a linked server or import via...
June 15, 2016 at 5:58 am
we need an example of duplicates making it in.
when i test, i get an error violating the PK, which would be expected.
insert into [Test_A]([V],[CA])SELECT '1','2'
insert into [Test_A]([V],[CA]) SELECT '1','2'
Msg 2627,...
June 14, 2016 at 2:39 pm
ok, in that case, i would cross join the default value, and select it in the isnull:
SELECT M.member_name,
M.member_plan,
...
June 14, 2016 at 1:54 pm
great job on providing sample data.
it looks like a simple isnull is needed, am i right?
SELECT M.member_name,
M.member_plan,
...
June 14, 2016 at 1:36 pm
brad.mason5 (6/14/2016)
Have issues with icons not displaying?
On a side note: How do you add images to the body? I add as...
June 14, 2016 at 1:16 pm
it also looks to me like you could combine the WHERE statement into a single query, that might be more efficient too:
aww nevermind, i didn't notice the IS NOT NULL...
June 14, 2016 at 11:57 am
create a role, and then grant execute to the role; don''t grant on a per object basis, and you'll be fine.
as long as the proc uses objects only in the...
June 14, 2016 at 11:50 am
the first handful of articles from my search points to networking issues, and not anything with SQL server itself.
[this article mentions Distributed Transaction Coordinator on the remote linked server...
June 13, 2016 at 12:54 pm
dschlobohm (6/13/2016)
then get this error
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or...
June 13, 2016 at 12:02 pm
the COUNT will always exist, but it might be zero. that's not what you want to test. you want to test if any rows exist
instead just change to if exists...
June 13, 2016 at 11:53 am
rash3554 (6/13/2016)
Yes, I do really need a solution. This is not a student assignment but a company project.Thx
ok, so is this a find and replace in a paragraph, or are...
June 13, 2016 at 11:28 am
i got it, it's the leading char:
/*
NormalConvertBigEndianFinalResults
$1 egaP thgilF rof eeF noitcasnarTTransaction Fee for Flight Page 1
*1 egaP thgilF rof eeF...
June 13, 2016 at 11:13 am
ok i'm getting close;
if i switch your values to BigEndian instead of Little, i'm getting your string, but backwards; i cannot seem to get it converted back to the last...
June 13, 2016 at 11:09 am
there's a few threads on converting the opposite of this request/; numbers to words
the logic is basically the same, a bunch of find and replaces, the links and code samples...
June 13, 2016 at 10:59 am
Viewing 15 posts - 886 through 900 (of 13,445 total)