Hi All, Can someone please help me with below access query to convert to sql ?
UPDATE tblEmp
SET emprank = IIf('[tblemp]![ID] Mod 3', '[tblemp]![ID] Mod 3', 3).
Thanks in advance
Re: Automating Access from Excel ... Thanks Andy!... Actually I got my code running - it was a syntax thing. ... > This might be a help for getting data to and from Excel and Access: ... > includes examples of using variables in SQL queries.... (microsoft.public.excel.programming)
Re: Query Help with IF stmt ... >Can someone please help me with below access query to convert to sql? ... Hi Andy,... The equivalent in proper SQL would probably be: ...UPDATE Employees... (microsoft.public.sqlserver.mseq)
Re: Grosse Tabellen wegsichern!? Bitte Eure Meinung! ..."Andy Haberer" schrieb im ... > Hi Christa,... > auch am sinnvollsten die Daten auf dem SQL Server zu belassen... ... >> Daten, di eälter als 6 Monate sind, in die neue Tabelle schreiben und aus ... (microsoft.public.de.sqlserver)
Re: Looping through recordset ... How to loop through a global variable Rowset..."Andy C" wrote in message ... > I have an SQL Execute task that returns a recordset. ... What I want to do is use this recordset to start a workflow of several objects for each row that is returned. ... (microsoft.public.sqlserver.dts)
Re: Table Copy (DTS) ... three dots for transform when you check a table, then click Edit SQL.... > "Andy Svendsen" wrote in message ... >> scripting it? ... >> This posting is provided "as is" with no warranties... (microsoft.public.sqlserver.tools)
