Share your SQL code snippets for SQL Prompt!


Postby Bill_Ross » Thu May 13, 2010 1:16 pm

I love the Over Partition:

row_number() OVER ( Partition BY <foreignkey, varchar> order by <foreignkey,varchar> ) AS [Seq]

Ctrl-Shit-M to populate
Posts: 14
Joined: Mon Mar 22, 2010 5:49 pm

Return to SQL Prompt code snippets

Who is online

Users browsing this forum: No registered users and 0 guests