Viewing 15 posts - 1 through 15 (of 112 total)
These extreme systems are so extremly fascinating to me.
The company im working at is still working with Cubes. We have Dimensions with sometimes like around a million entries and alot...
November 12, 2020 at 7:03 am
atleast post ur solution and not only "solved it", someoen might stumble upon this post and be like..
yeah thanks for nothing
October 28, 2020 at 6:45 am
post full query that leads to the error and use "insert/editcode sample" function plz
October 22, 2020 at 9:12 am
What solution did you go for?
October 21, 2020 at 9:37 am
Not sure from description what you are trying to accomplish.
Do you want all IDS from the Main table that are in Table 1 AND in Table2?
--> Filter from Main if...
October 21, 2020 at 8:31 am
These might be abominations not sure, first one is an if which is the easiest version if u can use it.
The 2nd version just uses a Dummyvalue if the values...
October 21, 2020 at 8:18 am
is there a reason why u are not doing it in one go? unless i might be overlooking something obvious here
select name ...
October 21, 2020 at 5:25 am
The query already drops tables in the query at the top.
It fetches each table name 1 by 1 out of the query and executes a drop table + table name
October 15, 2020 at 9:51 am
I was looking at this just yesterday feeling somewhat unwell going away from looking at it during my lunchbreak knowing i did only understand some of it. This throughout and...
October 14, 2020 at 5:11 am
That is something that is really bothering me.
There seems so be so much useful metadata stored and available in SQL Server, but i dont even know where to start or...
September 30, 2020 at 5:45 am
Not a solution since am at work, but for the future, if you have TSQL Questions, rather than what u did, its much more helpful and easier for you and...
September 17, 2020 at 9:15 am
Maybe take a look into this:
September 14, 2020 at 12:32 pm
Maybe the environment variables in the job?
August 27, 2020 at 9:19 am
For those are too lazy to copy paste for testing, added 2nd Colum for True False:
create table #temp ( Date1 datetime2 ,Wanted bit)insert into #tempvalues (cast('2020-08-26...
August 26, 2020 at 12:58 pm
I never got into reading no-technical books.
I am now 27 and i havent read a single non-technical book outside of those i had to read for schools.
On the other hand...
August 19, 2020 at 6:27 am