I have the following sql statement:
SELECT ID,Nu,[Client ID],Max(Text4)Text4,Max(Text5)Text5,Max(Text8)Text8,Max(Combo4)Combo4,Max(Combo5)Combo5,Max(Age)Age, Sum(Total) as TotalsperStudent ...
I am trying to dynamically generate the query in this procedure. I am having a problem with the variable @docHandle. I have tried to leave the @docHandle as a literal in the dynamic SQL statem...
I have been trying to figure this out for more than a month, with no success. We have a SQL server cluster with 2 nodes in our environment. I tried to run the SQL Server 2005 Service Pack 3 Fa...
Hi,
I use sql 2005 and database mail for a while, with anonymous authentication, and that works fine.
I need now to use basic authentication with another smtp server, without SSL, and that...
Hi All,
I have a laptop and a desktop, both of which have SQL server Express 2008 intalled. They are both connected to a network work group. This part works well.
When I open Management ...
My sql server 2005 developer edition installation fails with the following log output.
i have windows xp professional Version 2002 service pack 3.
can someone tell me if there is any com...
I have a table that looks like this:
id column1 column2 column3
12 'hello' null null
12 null 'expert' 'exchange'
what I need...
I have a table with booked date and completed date. I need to calculate how many business days between these two days -- at this point I just want to exclude weekends. Is it possible to do thi...
I have a list:
ID Year
1 2007
2 2007
3 2007
4 2008
I want a query that will return:
ID Year YearID
1 2007 1
2 2007 2
3...
I am trying to import a csv file into an empty table using the SSIS in SQL 2005. I have looked through the other answers for this question, but they don't appear to answer my question.
When...
Hello - I'm using Visual Web Developer 2008 Express, and trying to add a new database connection to SQL Server 2005 Express. Everything works fine (even the "Test Connection"), but when I clic...
I havea table that looks like this
ID valueSet1 valueSet2
1 a,b,c 1,2,3
2 d,e,f 4,5,6
What I need to do is create a new table where it i...
I am trying to combine two fields into one field. My client changed their mind after I had all of the data setup and the database completed. Here is my issue. When I use the below query it doe...
Hi all.
I have the following two queries
select count (cast (ShipDate - OrderDate as int)) as duration from Orders
group by cast (ShipDate - OrderDate as int)
having cast (ShipDate - ...
Hi. I have a this column in microsoft sql and i want to remove the year part of the string to insert it in another column.
example:
Wine_Name ...
Hi Experts
Few questions
1. What is auto shrink option in SQL 2005?
2. How do I disable it?
3. What is the advantage and disadvantage of auto shrink?
Thanks
I have two instances of SQL 2005 Express. Is there a way to copy a table to a database in the other server?
I got the SQLCMD output this far, but need to get rid of dead space....
206227220030, 77257
206227220133, 506226
206227221023, ...
Hi
I've setup replication (transactional with subscriber updates) in SQL v2008. On the publisher I set up the table article so that the triggers I made WILL get replicated to the subscribers....
I have two tables
imei master
imei model color
and
imei master2
imei model color
both the tables have the exact structure.
I want to insert all the rows from imei mast...
hi
I would like to create a SSIS package that is going to be called by store procedures.
What i have done so far.
1) I created a Execute SQL task that come with this statement e.g. Se...
I have been investigating a problem with our production database / front end that at times causes a complete lock up of the system. We have a Microsoft Acess front end with linked tables to ou...
Hi..
I need assistance getting counts based upon values in a lookup table. Query must be as fast as possible.
My lookup table looks like this.
Description
_______
Apple
Oranges
Peac...
I have not beeing using autonumber fields in my tables until now. When adding, for example, a new contact record into a table, a contact_id bigint can be set to autonumber and the value of th...
I have a single SQL Server 2005 SP2 server running on Windows 2003 Standard R2. I am needing to accomplish 2 things:
Mirroring and Upgrade to 64 bit SQL Server.
My thoughts are to first s...
