Viewing 15 posts - 16 through 30 (of 42 total)
To clarify, say we have three tables:
schemaA.MyTable
schemaB.MyTable
dbo.MyTable
If my current-logged in user's default schema is schemaA and the default schema for the database is schemaB. And we create a stored...
March 12, 2013 at 12:24 pm
I have a SQL server instructor (Bell) who told me it does require some CPU cycles to resolve a name if it is not qualified with a schema name. ...
March 12, 2013 at 12:19 pm
Dynamic SQL, what a drag.
Thanks for the link!
March 8, 2013 at 1:23 pm
I think you want something like this?
UPDATE {table}
SET [Col 2]=(SELECT [Col 2] FROM {table} WHERE [Col 1]=10000)
, [Col 3]=(SELECT [Col 3] FROM {table} WHERE [Col 1]=10000)
,...
March 8, 2013 at 6:03 am
opc.three (3/5/2013)
March 7, 2013 at 1:28 pm
Is this an issue with using the 64-bit transfer with a 32-bit odbc Jet driver? Maybe you could try to download the updated Microsoft Access Database Engine 2010. ...
March 7, 2013 at 6:24 am
Temp tables are created just like a persistent table- the difference is you do not typically specify the schema and you put a # before the name, such as:
CREATE TABLE...
March 5, 2013 at 5:51 pm
I'm glad it's working and Lowell concisely described how to name the returned attribute.
Still, I would love to see an alternative to this query.
March 5, 2013 at 11:32 am
You could try something like this (without having your tables, I couldn't test that this actually works):
SELECT POPRCTNM,
STUFF((SELECT ','+ CAST(ACTINDX AS varchar)
...
March 5, 2013 at 10:29 am
Change your query to:
SELECT A.final_owner, tblUser.tName, A._owner_m, cast(A._owner_m as int), tblUser.aUserID, cast(tblUser.aUserID as int)
FROM A INNER JOIN
tblUser ON cast(A._owner_m as int) = cast(tblUser.aUserID as int)
And post the results.
March 5, 2013 at 7:56 am
There are probably many ways to do this, and I'm not sure this is the proper way, but this is how I do queries like this:
SELECT items.*
FROM #items items
LEFT OUTER...
November 6, 2012 at 11:44 am
Oops... duplicate post... sorry.
November 6, 2012 at 11:40 am
qamar 52306 (9/6/2012)
Table1
recordid description
1001 ABC
1002 DEF
Table2
id Status ...
September 6, 2012 at 7:53 am
Usually "the query runs forever" is db speak for "an index is missing". So I think to diagnose this, we need to know how your database was 'migrated'.
Did you...
September 6, 2012 at 7:44 am
Autumnstorms (9/6/2012)
I am pretty new to SQL & SQL Server and i'm having some trouble converting some date and time stored in our database...
We have a ticket application which...
September 6, 2012 at 7:38 am
Viewing 15 posts - 16 through 30 (of 42 total)