SQLServerCentral / Discuss Content Posted by Cade Bryant / Article Discussions / Article Discussions by Author

Generate C# class code for table

cadebryant — Fri, 09 Nov 2007 11:35:42 GMT

Comments posted to this topic are about the item [B]Generate C# class code for table[/B]

Find the Nth Occurrence of a Character in a String

cadebryant — Mon, 24 Sep 2007 01:35:09 GMT

Comments posted to this topic are about the item [B]Find the Nth Occurrence of a Character in a String[/B]

REVISED Dynamic Crosstab Query

cadebryant — Mon, 24 Sep 2007 01:36:03 GMT

Comments posted to this topic are about the item [B]REVISED Dynamic Crosstab Query[/B]

Execute VBScript commands or .vbs files via T-SQL.

cadebryant — Mon, 24 Sep 2007 01:35:56 GMT

Comments posted to this topic are about the item [B]Execute VBScript commands or .vbs files via T-SQL.[/B]

Improving performance on joins to large tables.

cadebryant — Mon, 24 Sep 2007 01:36:14 GMT

Comments posted to this topic are about the item [B]Improving performance on joins to large tables.[/B]

Using UDFs to avoid cursors

cadebryant — Thu, 08 May 2008 15:37:56 GMT

Comments posted to this topic are about the item [B]Using UDFs to avoid cursors[/B]

FASTCOUNT() User-Defined Function (SQL 2000 only)

cadebryant — Sat, 15 Mar 2008 18:50:50 GMT

Comments posted to this topic are about the item [B]FASTCOUNT() User-Defined Function (SQL 2000 only)[/B]

adapting the solution---sooo desperate :(

delta dirac — Wed, 16 Jan 2008 08:22:28 GMT

hi ,i am an electronics engineer and i just have the general knowledge about sql server 2005(i am not too bad i am immediate), but i couldn't adapt your dynamic cross tab sp ,according to my problem if you help me i will very very appreciate and even i will pray for you :) promise:) cause i am desperate and helpless about this, here is my problem:i have just one table, named "collector" and the columns are:ledno(nvarchar(50))' the item number of a kind of led(a mini light source) which we useledname(nvarchar(50))' the name of the ledsquantity(int) ' how many leds we use on that partpartname(nvarchar(50) 'the parts nameand i want it to be this way;ledno ledname partname(part name goes dynamically according to our records(the header))202.a led-a 3 '(this is the total led-a used in the correct partname)205.b led-b 6'(this is the total led-b used in the correct partname)and the "partname" header musn't repeat itself (your sp does it well) i hope i am able to tell my problem, i know it's simple for you but i couldn't manage may self, thanks again.

Display Row Count for all Tables

cadebryant — Sat, 22 Sep 2007 08:48:43 GMT

Comments posted to this topic are about the item [B]Display Row Count for all Tables[/B]

Automatically generate SUID procs for any table

cadebryant — Fri, 09 Nov 2007 06:35:39 GMT

Comments posted to this topic are about the item [B]Automatically generate SUID procs for any table[/B]

Stored procedure sp_for

cadebryant — Mon, 15 Oct 2007 06:04:59 GMT

Comments posted to this topic are about the item [B]Stored procedure sp_for [/B]

Preventing accidental overwrites with update SPs

cadebryant — Sat, 13 Oct 2007 15:27:07 GMT

Comments posted to this topic are about the item [B]Preventing accidental overwrites with update SPs[/B]

An alternative to self-joins

cadebryant — Tue, 25 Sep 2007 02:44:00 GMT

Comments posted to this topic are about the item [B]An alternative to self-joins[/B]

Search all objects in all DBs for code fragments

cadebryant — Mon, 24 Sep 2007 17:20:45 GMT

Comments posted to this topic are about the item [B]Search all objects in all DBs for code fragments[/B]

Drop and re-create all stored procedures or views

cadebryant — Mon, 24 Sep 2007 14:18:03 GMT

Comments posted to this topic are about the item [B]Drop and re-create all stored procedures or views[/B]

Parsing an IP address into its separate octets

cadebryant — Mon, 24 Sep 2007 09:34:34 GMT

Comments posted to this topic are about the item [B]Parsing an IP address into its separate octets[/B]

View Input Buffers for all SPIDS

cadebryant — Mon, 24 Sep 2007 02:24:58 GMT

Comments posted to this topic are about the item [B]View Input Buffers for all SPIDS[/B]

"RESTORE..... WITH MOVE" all databases on a server

cadebryant — Mon, 24 Sep 2007 02:17:13 GMT

Comments posted to this topic are about the item [B]"RESTORE..... WITH MOVE" all databases on a server[/B]

Creating a Dynamic Crosstab Query

cadebryant — Mon, 24 Sep 2007 01:56:07 GMT

Comments posted to this topic are about the item [B]Creating a Dynamic Crosstab Query[/B]

View all settings for all databases on your server

cadebryant — Mon, 24 Sep 2007 01:38:07 GMT

Comments posted to this topic are about the item [B]View all settings for all databases on your server[/B]

The case against using single-line comments

cadebryant — Mon, 24 Sep 2007 01:37:19 GMT

Comments posted to this topic are about the item [B]The case against using single-line comments[/B]

Dynamically Generating HTML Tags from T-SQL

cadebryant — Mon, 24 Sep 2007 01:36:49 GMT

Comments posted to this topic are about the item [B]Dynamically Generating HTML Tags from T-SQL[/B]

SP for checking column uniqueness

cadebryant — Mon, 24 Sep 2007 01:36:13 GMT

Comments posted to this topic are about the item [B]SP for checking column uniqueness[/B]

A more efficient ForEach routine

cadebryant — Mon, 24 Sep 2007 01:35:34 GMT

Comments posted to this topic are about the item [B]A more efficient ForEach routine[/B]

Modified sp_who - more info & extra parameter

cadebryant — Mon, 24 Sep 2007 01:35:33 GMT

Comments posted to this topic are about the item [B]Modified sp_who - more info & extra parameter[/B]

Correction to "drop/recreate objects" script.

cadebryant — Mon, 24 Sep 2007 01:35:20 GMT

Comments posted to this topic are about the item [B]Correction to "drop/recreate objects" script.[/B]

A faster way to count rows in a table

cadebryant — Mon, 24 Sep 2007 01:35:14 GMT

Comments posted to this topic are about the item [B]A faster way to count rows in a table[/B]

Show all User-Defined Datatypes for all Databases

cadebryant — Mon, 24 Sep 2007 01:35:14 GMT

Comments posted to this topic are about the item [B]Show all User-Defined Datatypes for all Databases[/B]

It Cant be Done with SQL

cadebryant — Sun, 26 Oct 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/cbryant/itcantbedonewithsql.asp