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...

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...

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?

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...

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...

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...

I am attempting to find out when a stored procedure was altered. The table sys.all_objects has the last time it was modified - but is there another table that keeps a history of the changes (just date - not actually changes)? Thanks in advance!

I need to update a table.. but i am not sure how to do it.. I want to: Update tblTableName set dtStartDate = b.dtStartDate, txtClass = b.txtClass, txtCourseNumber b.txtCourseNumber, txtCourseName = b.txtCourseName from tblTable -- This is where i don't know what to do.. The...

How do you convert 3589 to 35.89?

Is it possible to track anyone who logs into a certain db without turning loggin on for everyone or running profiler or third part tools?

I am not sure if this is the correct board to post this on... I have a stored procedure that returns about 10 rows (record set).. How is that transferred across the network? Is it in plain text?

I have a table that has: Name Grade John A John B John C Eric C Seth B Seth A Tim A I want to retun only Name that have an 'A' but no B or C so in the above only Tim would be returned.. I tried Select * from tblTable where Grade = 'A' and Grade not...

I am attempting to install BAM (something i know nothing about).. and it seems to want Analysis services installed on the same server. Is this necessary? Currently, i have a db server and a analysis server.