I have to be honest in that I cheated. Where is it documented that not using % assumes % at the end? I thought that this was a...

What does your query look like for this graph?

Thank you for the script. I have updated this to a stored procedure that I can pass in the table name:

CREATE PROCEDURE dbo.UTIL_DynamicTable_SELECT

@mStrTable varchar(255)

AS

-----------------------------------------------

--Display the SELECT Statement for...

This is why you are the MASTER and I am the one seeking wisdom. When I stated DML i was thinking in terms of data manipulation but you are...

GillaMonster,

Our argument was not over SELECT statements but more over DML. Also if you were performing more than just an UPDATE or INSERT or DELETE he stated he would...

He did claim that he reserved procedures for complex items like a cascading delete of records that needed to be encapsulated in a transaction. However, he was insistent that...

Would you consider it bad programming to use SQL Stored Procs vs. Adhoc queries? His argument is that when you are hitting a large data set, the stored procedures...

The database is a SQL server database however the application will not be in our control once it is distributed to our clients. We can't demand that SSRS be...

Do you recommend any reporting tools to use for our custom .NET application or is this outside the scope of sqlservercentral and more intended for .NET developer sites?

Thank you for the response. I have a table called DBSpec which contains a list of fields and their respective table names. I also have the associated parent...

I found this on StackOverflow by U07CH:

Declare @TableUsers Table (User_ID, MyRowCount Int Identity(1,1)

Declare @i Int, @MaxI Int, @user-id nVarchar(50)

Insert into @TableUser

Select User_ID

From Users

Where...

So what you are saying is that if I change the code that you provided to the following, I would see a poor performance from the system? I anticipate...

I thought about this however not every field will be yes no. I am not trying to be nit picky and this is my example but I think that...

Can you elaborate on the Schema Bound UDF? Are you suggesting that I should create a function that refernces the correct column and return the appropriate value from the...

I am not giving you the exact code from my database but I have created a sample of 5 fields for you:

The lookup table is tblYN and has two columns...