Topics
Started by
Posts
Last post
From the table below, for each Name, I need to find out how long each was stopped (I.e. the t…
7 replies
Hi All, I have this query: SELECT code_all.* FROM C_CODES code_all LEFT JOIN (SELECT t.t_code…
5 replies
Hi, The following insert statement was not compiled. INSE…
6 replies
I have an update statement that is being called in a stored procedure that isn't returning. (…
3 replies
Hi, Would someone please help me understand the difference between these two statements 1) SELECT D…
3 replies
Hi,,,, We have table (say table name “Store”) in which some columns are generated dynamically and d…
1 replies
We have table (say table name “Store”) in which some columns are generated dynamically and d…
1 replies
I have an oracle linked server setup with ODBC data source which uses OLE DB Provider for Oracle. R…
2 replies
COALESCE has always been my favorite when creating dynamic query. Yesterday, I was shocked to find …
7 replies
Hi I have a code table that has about 10 codes, and I want to concatenate them all together into on…
3 replies
I have a column with values like "050706" I would like to change this to datetime type. The varchar…
8 replies
Sub: Which master db extended stored procedures used in app. db Hi All Recently we got a recommenda…
2 replies
I have an insert…select statement that is violating the constraints of an index. I believe the dis…
4 replies
This is a request for someone to help prevent me getting the error message: Syntax error con…
6 replies
Here are sample data: create table #Item (I_ID int identity(1,1) ,ItemName varchar (100) ,Active …
6 replies
Viewing 15 topics - 6,346 through 6,360 (of 17,082 total)
You must be logged in to create new topics.