Viewing 4 posts - 16 through 19 (of 19 total)
First:
Define a function that maps employeeID to col1's value.. If you can create such a function all you have to do is:
update table1
set col1=select convertEmployeeIdToCol1(id)
My concern about this...
September 15, 2008 at 6:43 am
Rohit,
So you have a table, let's call it Table1 with columns Employeeid and Col1. You are wanting to update the potentially 20,000 rows of Table1 at one time with...
September 10, 2008 at 6:49 am
When I build dynamic SQL, I always start by writing it out by hand and formatting it properly to make sure it is exactly what I want. Only then...
August 29, 2008 at 8:06 am
This gives you a count of each day of the week between any two dates (inclusive).
DECLARE @FromDate smalldatetime
DECLARE @ToDate smalldatetime
DECLARE @TotalDays int
DECLARE @LeftoverDays int
DECLARE @FullWeeks int
DECLARE @Out TABLE(Sun int, Mon...
August 28, 2008 at 6:52 am
Viewing 4 posts - 16 through 19 (of 19 total)