Select columns from result set of stored procedure
I have a stored procedure that returns 80 columns, and 300 rows. I want to write a select that gets 2 of those … Read more
I have a stored procedure that returns 80 columns, and 300 rows. I want to write a select that gets 2 of those … Read more
Is it possible to specify a condition in Count()? I would like to count only the rows that have, for example, “Manager” in … Read more
I have a string that is up to 3 characters long when it’s first created in SQL Server 2008 R2. I would like … Read more
Using SQL Server, how do I split a string so I can access item x? Take a string “Hello John Smith”. How can … Read more
Why 1753? What do they have against 1752? My great great great great great great great grandfather would be very offended. 6 s … Read more
Scenario: Let’s say I have two tables, TableA and TableB. TableB’s primary key is a single column (BId), and is a foreign key … Read more
In SQL Server 2005 I have a table cm_production that lists all the code that’s been put into production. The table has a … Read more
Using MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the table with the … Read more
Which method provides the best performance when removing the time portion from a datetime field in SQL Server? a) select DATEADD(dd, DATEDIFF(dd, 0, … Read more
I know I’ve done this before years ago, but I can’t remember the syntax, and I can’t find it anywhere due to pulling … Read more