Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

My Badges

Request Friendship



Upload Image

52 years old
Frankfurt / Gemany
Male

My Sections

Guenter
28 · 6% · 1887

Guenter's Home

My name is Guenter.I live in Germany . I work as BI Architect.
  • #0260-SQL Server-SOME or ANY-ISO versions of EXISTS

    Guenter learned 1 Years ago through Blogs
    Have you ever tried to write T-SQL code that conforms completely to the ISO standard? Since Microsoft SQL Server's T-SQL standard is based on the ISO standard, doing so is quite possible. Today, I explore the ISO equivalents of the EXISTS keyword - SOME...
    Nakul Vachhrajani
    4 · 36% · 11645
  • #0260-SQL Server-SOME or ANY-ISO versions of EXISTS

    Guenter Liked 1 Years ago through Blogs
    Have you ever tried to write T-SQL code that conforms completely to the ISO standard? Since Microsoft SQL Server's T-SQL standard is based on the ISO standard, doing so is quite possible. Today, I explore the ISO equivalents of the EXISTS keyword - SOME...
    Nakul Vachhrajani
    4 · 36% · 11645
  • #0222 - SQL Server - Stored procedures and temporary tables - Scope, Modification and some fun

    Guenter Liked 2 Years ago through Blogs
    How can one implement a scenario wherein a table needs to be passed over to a stored procedure, modify the table inside it and then consume the results outside of the procedure? We can share temporary tables through stored procedures and today we look a...
    Nakul Vachhrajani
    4 · 36% · 11645
  • Question of the month December 2012 - Why is last comma ignored in CREATE TABLE statement?

    Guenter Commented 2 Years ago through Blogs
    It really helps maintaining code especially when design changes reorder the rows or you temporarily want to remove a row. However, the benefit only comes in action when you use the syntax with one column per row, i.e. create table a ( fi...
    Madhivanan JR
    3 · 40% · 12947
  • How to make statistics work for this table/query

    Guenter Commented 2 Years ago through Ask
    Hi Dishdy, the way to specify a plan is quite straightforward: 1. start the profiler 2. run the query in doubt 3. retrieve the query text In my case, I started a "process full" on a partition in my cube. Then, just paste your query in t...
  • How to make statistics work for this table/query

    Guenter Commented 2 Years ago through Ask
    Mike, thanks for jumping in! The query is created by an SQL Server Analysis Services Cube, but it's basically a select {some columns} from {some view} where dataversion>=2012103100 and dataversion < 2012110100 The same query with another d...
  • SQL Server geography datatype

    Guenter Commented 2 Years ago through Ask
    Hi, if you have a field named GeoLoc and populate it like this UPDATE Table1 SET [GeoLoc] = geography::Parse('POINT(' + CAST([Longitude] AS VARCHAR(20)) + ' ' + CAST([Latitude] AS VARCHAR(20)) + ')') then you...
    Praveen
    85 · 2% · 654
  • How to make statistics work for this table/query

    Guenter Posted 2 Years ago through Ask
    <font face="Arial">Hi,<br><br>I have a BI solution that uses a "dataversion" as the primary key for all major tables. A dataversion is an integer that has the format yyyymmddxx, where xx is the number of dataversions for a given date.<br>My "date" table...
  • Using WITH to create a series of data

    Guenter knew 2 Years ago through Just Learned
    Using WITH statement you can create a series of data and use them in your queries. Sample 1. Integer-Series <pre> WITH T(ID) AS ( SELECT 1 ID UNION ALL SELECT ID + 1 FROM T WHERE ID < 1000 ) SELECT * FROM T OPTION (MAXRECURSION 1000) </pre> Sa...
    dsorokin
    625 · 0% · 57
  • Using WITH to create a series of data

    Guenter Liked 2 Years ago through Just Learned
    Using WITH statement you can create a series of data and use them in your queries. Sample 1. Integer-Series <pre> WITH T(ID) AS ( SELECT 1 ID UNION ALL SELECT ID + 1 FROM T WHERE ID < 1000 ) SELECT * FROM T OPTION (MAXRECURSION 1000) </pre> Sa...
    dsorokin
    625 · 0% · 57
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.