Search results for query: *

I have a table that contains xml documents blobbed up and stored as a text column. I would like to unblob them and either store them into a file and re-import them in or when the column is readable read it into another table for analysis. Is this possible without writing a windows app? Can...

woo hoo, it worked!! Thanks so much!

Thanks, that is great! Thanks for the tips as well. Is there a way to modify it so i have the column name and the sum of that column? For example: Column1 1020 Column2 5287 Column3 2587 .... I should have specififed this.

I need to get the sum of multiple columns in a table. The issue is the columns may change over time and i don't want to have to constantly readjust my code... I have a table called tbl_CenterInfo I know how to pull all the columns back: Select [Name] from sys.columns where object_ID...

I need to pull the previous Friday's date.. So, if today is Tuesday 8/31, i need to calculate the previous Friday's date (8/27). Any suggestions?

I am trying to create a script that will loop through each database and and resbuild indexes on all the tables. i have exec master.sys.sp_MSforeachdb ' USE [?]; DECLARE @starttime datetime, @endtime datetime print ''?'' EXEC sp_MSforeachtable @command1="DBCC DBREINDEX (''?'')" SELECT...

Perhaps, i need to be more clear. The database i am log shipping is called "MyDatabase" on database A. It is set up to log ship to database B. I need to still be able to perform full database backups on Mydatabase on database A. The application that uses it is not the best and allows...

please disregard - i didn't see the reponse below...

When setting up log shipping can you still do full database backups on the primary server? I have been trying to set it up and i have disabled the full backups/transaction log backups... But when i re-enable the full backups the databases seem to get out of sync. I just want to verify if...

I have set up log shipping. I need to restore our master database from a different environment. Once i do this, do i need to do an new initialize?

Thanks - I didn't think about that!

I have a database with two different groups having access to it. Group1 has datareader and denydatawriter Group2 has datareader, denydatawriter, execute on sprocs. I have one member who is in both groups, what level of access will this individual have? From what i can tell, they have the...

I have a column that is of type xml. The xml looks like ... <Person> <Name> <Address> <City> <State> <zip> <Primary>TRUE </Name> <Name> .... </Name> </Person> I want to return the firstname and lastname where the primary equals true. But i don't know which person will have that set to true...

I am writing a stored procedure where i am passing in a date (although not required). If it is passed it, i want to select all the records with a date greater than that: Select * from tblName where column > @DateVariable How do i check if null is passed in without writing several statements...

Perfect! Thanks!

I have a table that has has a date column but is varchar(20)... This table has 2008/2009 data in in. How do i sort by date I have tried: SELECT convert(varchar,Date,101) FROM autoissuelogdate order by convert(varchar,Date,101) desc but that returned 12/31/08 at the top of the list...

Figured it out - i didn't have my table bound to database (right click and update the dataset) doh!

I have created a report that uses a stored procedure and i pass in the name. Based on the name 0 to many records can be returned. If more than one record is returned, the same value is being repeated in all the columns. For Example: Name LName Address Joe Smith 1 Pub Street...

I have a column that has contains question number. A question can have 2a, 2b type order. How can i seperate the two? I would like to return: question, question order, question sub order. Thanks in advance.

I have a table that has date and total number of orders. I need to return something that looks like this: Date Total 5 12/2/08 10 12/1/08 585 Total for November 51 11/30/08 80 11/29/08 ..... Is this possible? I can get this information in two...