Select distinct O.Name FROM dbo.SysComments C inner join dbo.SysObjects O on C.id = O.id where Text like '%Create view%' and O.XType = 'P' Order By O.Name

sql = "SELECT Count(tblLinkRequest.LinkRequestID) AS CountOfLinkRequestID, tblLinkRequest.DateSent FROM tblLinkRequest GROUP BY tblLinkRequest.DateSent HAVING (((tblLinkRequest.DateSent)='" & Date() & "'));"

1 - May I suggest that you normalize the design... it's not normal to see field1, field2 in a table definition.

2 - If you are only updating 1 table, I...

well if the procs work.. nothing. SysDepends is used when ou ask sql server to show the object dependencies (spa needs table1,view2 and vice-verca)... but this is not always...

You seem to be close.. can you send the ddl with some sample data. Also what results you are expecting also with what you are getting. It'll be...

What exactly are you trying to do?

2 ways of doing this :

1-

create myproc2 @somevariable as int

as

select 1

go

Create myproc1

as

set @somevariable = 3

exec myproc2 @somevariable

go

2-

Create myproc1 @SomeVariable int output

as

set @somevariable = 3

go

create myproc2 @SomeVariable int

as

select 1

go

declare @var...

1 - Why would you keep the same data in 2 different columns of the same data type?

2 - If you really want to do it you're gonna need a...

I've never seen such a variable in Sql server. The only thing comparable to that would be the line number provided with sql server's error messages. But I...

maybe a left() operation could be faster... but the question is : Is it always ok the truncate the decimal part or do you need to keep it if it's...

That's a very good question... one that I can't answer. However is is considered best pratice to explicitly declare the cursor as local or global.

tinyint = 1

smallint =2

int = 4

bigint = 8

bit = 1 (for the first 8, then 2 bytes from 9 to 16, 3 from 17 to 24...)

datetime = 8

smalldatetime =...

I've stopped counting how many times I forgot that .

If you get an error near the order by, it means that you must give an alias name to the table :

WHERE m.fkCouncilID = @CouncilId

) dtYourNameOfChoice -- End of virtual...

If you can then normalize... it's always the best option on the long run. But that would also mean rebuilding everything in the application.