Viewing 15 posts - 3,091 through 3,105 (of 8,731 total)
john.w.walker (4/7/2016)
April 7, 2016 at 7:19 am
cstringham (4/7/2016)
Here's a tool called Snippets Generator[/url] that I've been using that allows you to past the SQL and generate the snippet.
It's nice, but it's still missing the...
April 7, 2016 at 7:17 am
SQLvis (4/7/2016)
Are there any examples for creating an MDX Snippet?
I'm sorry. SSMS still doesn't support snippets for MDX queries.
I'm not sure if Visual Studio has that capability.
April 7, 2016 at 7:16 am
Check the following article to get the best string splitter available.
April 6, 2016 at 2:32 pm
My wild guess is that you're missing some join criteria in your query. It's impossible to know without complete information.
Another option is that employees and products are completely unrelated. You...
April 6, 2016 at 2:10 pm
Why are you copying your table to a temp table?
Why does the temp table needs an identity column?
Why aren't you using sys.columns which has the column is_identity (and is_computed)?
The...
April 6, 2016 at 1:51 pm
Koen Verbeeck (4/6/2016)
Boooo, temp tables can be partitioned.
So I guess BOL should be corrected?
You can create local and global temporary tables. Local temporary tables are visible only in the...
April 6, 2016 at 7:28 am
Ed Wagner (4/6/2016)
Iwas Bornready (4/6/2016)
This is great. I didn't know this simple trick.This is a QOTD that's 3 1/2 years old.
And this functionality is no longer guaranteed to work as...
April 6, 2016 at 7:12 am
timotech (4/6/2016)
but please look below at the error being generated:
(1 row(s) affected)
Msg 208, Level 16, State 1, Line 8
Invalid object name 'dbo.DelimitedSplit8K'.
Please how do i overcome...
April 6, 2016 at 7:09 am
Using a recursive CTE can be very expensive. I'm using an alternative to split the string which is largely explained in this article: http://www.sqlservercentral.com/articles/Tally+Table/72993/
Ask any questions you might have.
DECLARE @tbl_MediumResults...
April 6, 2016 at 6:51 am
SQL-DBA-01 (4/5/2016)
Do we have any standard script available to extract any unknown JSON script to C# datagrid?
I tried with a fixed string with a designated set of columns and...
April 5, 2016 at 11:30 am
sks_989 (4/5/2016)
April 5, 2016 at 11:24 am
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
I constantly avoid that person's threads. It doesn't matter if...
April 5, 2016 at 10:35 am
How are you getting the values for your fourth parameter?
You could use a dataset with requires a parameter to assign the default value.
April 4, 2016 at 11:15 am
Sergiy (4/3/2016)
Luis Cazares (4/1/2016)
Sergiy (3/31/2016)
GilaMonster (3/31/2016)
snomadj (3/31/2016)
Can I drop a local temp table owned by myself in another session?
No. Temp tables are session-scoped, you cannot access a temp table created...
April 4, 2016 at 6:51 am
Viewing 15 posts - 3,091 through 3,105 (of 8,731 total)