Viewing 15 posts - 6,331 through 6,345 (of 7,164 total)
What about changing the discussion? Is switching from SQL Authentication to Windows Authentication an option?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 25, 2011 at 9:07 am
There is some weirdness going on. Your initial post says the PK consists of one column named guid but there is no column in the DDL.
Then your last post is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 25, 2011 at 9:02 am
jasonmorris (5/25/2011)
We are trying to get a handle on who is using Office applications to connect to our databases.
Users have an application that connects to several databases...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 25, 2011 at 8:53 am
Happy to assist 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 25, 2011 at 8:41 am
Did you add the try/catch? I am only making out bits and pieces so far...if you post your entire script I am happy to take a look at it to...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 9:59 pm
One tweak I would make to mine is to trade in the two separate function calls to LEFT and LEN for one call to STUFF:
CREATE TABLE #temp
(
ae1 VARCHAR,
ae2...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 9:50 pm
LutzM (5/24/2011)
I would prefer an inline-Table valued function over of a stored procedure.The benefit: you can still use it like a view (e.g. SELECT * FROM your_function(param1))
Agreed on the iTVF...some...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 4:18 pm
There may be a more elegant solution that looks and/or performs better but this query gives the results you asked for:
CREATE TABLE #temp
(
ae1 VARCHAR,
ae2 VARCHAR,
ae3 VARCHAR,
ae4...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 4:02 pm
How about something along these lines:
WITH cte(test_num)
AS (
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 3:38 pm
venus.pvr (5/24/2011)
@opc.three: Thank you! It helped.
You're welcome!
I have other question though. I want to read the string between <MDX> and </MDX> tags. How can I do that? I am very...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 3:28 pm
Yes, you have an Encoding issue where you;re munging the data somewhere between the file and the database. I assume the data is correct in the file but you may...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 2:47 pm
Yes, please post DDL, DML to create sample data and example of expected results:
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 2:23 pm
Red Gate SQL Prompt Pro
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 2:21 pm
Basically this is how the CASE is executed by SQL Server...
SELECT CASE
WHEN (ABS(CAST(CAST(NEWID()...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 2:17 pm
I just ran across a couple nice blog posts by one of our SSC cohorts on this very topic:
> Creating Excel Templates in #SQLServer #SSIS
> Using #Excel Templates in #SSIS...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 24, 2011 at 1:58 pm
Viewing 15 posts - 6,331 through 6,345 (of 7,164 total)