Topics
Started by
Posts
Last post
I have a list of names like this: John Smith Bob Johnson Earl Time I need convert these to this: Sm…
6 replies
When constructing WHERE clauses, I know that non-sargable clauses should be avoided. Is this the ca…
5 replies
Hi! I'd like to perform the following query Select Name, ( SELECT ali.ItemValue FROM Attribu…
8 replies
I have a table which has structure something like ID ColA ColB ColC 1 1 1 0 2…
2 replies
Now I am not a big fan of using IN statements. I prefer to use a join whenever possible. However,…
2 replies
I log activity to one table in my database. In the case of nested stored procedures, when an error…
5 replies
I have an Arithmetic overflow error converting nvarchar to data type numeric. My query looks like …
5 replies
Here's what I'm trying to accomplish: Identify rows from table1 where table1.reg_id = table2.reg_id…
8 replies
Hello All, I am trying to setup a SP where by I would pass in an integer value and based on that va…
3 replies
Im trying to write a query that will take 2 dates, a start and an end date, from those it will retu…
2 replies
Hi I am trying to insert data from table A to table B. I need a trigger on table B to check the no…
6 replies
Hi there, Is there any equivalent function for this in SQL 2005 SQL? I need to DENSE_RANK() a colum…
1 replies
How do we get value in 1x1 table returning from a Stroed Procedure in side a StoredProcedure with…
10 replies
Hi all, I have written a query to export some data in a specific format and that works but I want t…
22 replies
We'd like to add monitoring of stored procedures to audit/log the following: - Stored procedure nam…
9 replies
Viewing 15 topics - 8,146 through 8,160 (of 12,230 total)
You must be logged in to create new topics.