I have a table called "categories" which contains all categories of "widgets". Categories can be "sub_of" as well. There is a field. The structure looks like.
category_id int id
category_na...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22960810.html
Hi ,
I have a table that contains an ID, and a dateTime field. Now, I want select * from this table grouping the data by id and datetime field. More importantly, I want to ensure that the dateT...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23068849.html
Hi,
I am using MSSQL 2005
And I have to put around 16 million records in the database.
What would be the best approach?
Reports can be asked from anytime to anytime, If the parameters i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2311...
Please resolve the best way to make this work...
I know the below would never work, I've tried a hlaf dozen solutions including dynamic sql, but this is just the best way to describe what I'm tr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23128352.html
I have a need for a query that will combine multiple rows as one with all data
select model_id, rebox, weeknumber from tblname
where model_id = 'model'
what is currently being returned is as...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2326...
I have been working on a query for a little while now with some success. I have another issue. I have a query that will take multiple rows returns and place them on one line. Now I need to add anot...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2326...
I have two tables in my local database (MSSQL 2005) that I want to export to my hosting service which is also using MSSQL 2005. Each table has about 100,000 records.
What is the best way to do i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2326...
Ok, this one has been driving me crazy and has resulted in some horrible code from me already! It's complex to even explain so I'll do my best.
Here's the scenario:
I need to do some calcula...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23266662.html
Hi,
Anyone know the sample code for identifying a trigger type is insert, update or delete on the MSSQL 2005 in one trigger without separate several triggers.
Regards,
Man Pak Hong, Dave
m...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23345615.html
Greetings,
I have a C# application that calls a stored procedure to query the database (MSSQL 2005). I only have one field/column returned from the query but I need that column ordered.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2340...
