Please note, the create and drop of the sample data table is there so that I would cleanup my Sandbox database.

Not quite what you asked for, but is this close? You can modify as needed and I kept the in-line function I added above as well.

CREATE TABLE [dbo].[E_TimeCards](

[TC_EMPNO] [nvarchar](9)...

As for the GO, no, do not put a ; after it as it will error.

Here is a best guess (with a little extra) without additional information.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[itvf_FormatTimeHHMM] (

@Date1 DATETIME,

@Date2 DATETIME

)

RETURNS TABLE...

Also, please be sure to include the expected output based on the sample data. Right now I am not quite sure what output you are expecting from your initial...

craigalaniz (5/22/2012)

---

Hi All

Here is my problem. I have a table that is used for time clock punches, the IN and OUT punches do not have any way of linking the...

I'm torn with this thread. Should we tell the OP that it is possible to hde structural changes to the tables of the database from application using views? ...

The following answers assume that the witness and principal server (database) are still working while the mirror server/database is down.

1) T log size of Adventureworks db on live server? will...

SQL Kiwi (5/22/2012)

---

David Benoit (5/22/2012)

---

I think the issue here though Paul is that you just stuck a language into the database realm where the people that support it had no...

kwe477 (5/22/2012)

---

Lowell (5/22/2012)

---

it looks to me like the cursor is calling a stored procedure [STAT_LK.dbo.stat_v3] for each row;

to change this to a set base, wer would need to see the...

dwain.c (5/22/2012)

---

Jeff Moden (5/22/2012)

---

The really cool part is that both of you rose to the occasion. 🙂

Shifting gears a bit... Lynn wrote...

I have learned to stay away from scalar...

If PRINT isn't working, take off...

This is where I would start my investigation: CWBCO1048 - A firewall blockage or time-out occurred trying to connect to the System i.

To start, I would probably set the max memory to 20GB (20480MB) on all three instances. This will 4GB for the OS. You can then monitor the instances...

Jeff Moden (5/22/2012)

---

The really cool part is that both of you rose to the occasion. 🙂

Shifting gears a bit... Lynn wrote...

I have learned to stay away from scalar functions....