Viewing 15 posts - 6,331 through 6,345 (of 7,168 total)
This also stands out as a point of interest:
...the next ID is provided by them and is always the next sequential number.
Who is "them" and what programming mechanism are they...
May 25, 2011 at 10:43 am
I took a shot at this one...see if this one works for you:
IF OBJECT_ID(N'tempdb..#ProductAssembly ') > 0
DROP TABLE #ProductAssembly ;
GO
--Create temp table for example
CREATE TABLE...
May 25, 2011 at 10:35 am
What about changing the discussion? Is switching from SQL Authentication to Windows Authentication an option?
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...
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...
May 25, 2011 at 8:53 am
Happy to assist 😀
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...
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...
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...
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...
May 24, 2011 at 4:02 pm
How about something along these lines:
WITH cte(test_num)
AS (
...
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...
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...
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
May 24, 2011 at 2:23 pm
Viewing 15 posts - 6,331 through 6,345 (of 7,168 total)