If you want to search for a specific string

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1131

This should for a selected year

SELECT  DATENAME(month, Date_Occur) AS [Month],

 COUNT(*) AS [NumberOfTransactions]

FROM

 tblTransaction

WHERE

 Date_Occur >= CONVERT(DATETIME, '2006-01-01')  

AND

 Date_Occur < CONVERT(DATETIME, '2007-01-01')

GROUP BY

 DATENAME(month, Date_Occur),

 DATEPART(month,Date_Occur)

ORDER BY

 DATEPART(month,Date_Occur)

Thx

If the length of the text is less than 8000 characters you can store them in VARCHAR datatype columns. If it is more than 8000 characters you need to store...

I failed to understand your question, are u trying to understand how the data is inserted or do you want a solution for inserting the records as explained by you.

I assume that could be for end user presentation, it can be done on the client side also.

SELECT CONVERT(VARCHAR(8),GETDATE() ,112) replace GETDATE() with your datefield

Where do you want to preserve them? Do you mean in SQL tables or are you referring to any other format?

But he is running some scheduled process on the same tables, in which case he may have use the renamed tables for his processing aswell.

Yes, this is appropriate solution for your requirement, to set your report render format to EXCEL and render the report in excel and that way the user can manipulate as...

Well that was your script.

Thx

Try this, I believe there is some problem with the version of your databases.

declare @login sysname

declare @sid varbinary(85)

declare @dbname sysname

declare @db varchar(3000)

declare @cmd varchar(3000)

create table #tmplogin(msg varchar(3000)null, lname sysname)

select...

I am not sure if I got your question correct, static tables are the master tables that are populated with some canned data at the time of creation of the...

Write a stored procedure to insert data into a temporary table and you can manipulate on the data inserted to temp table to retrieve the output in your desired format.

Check if this link helps

http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp

Ok, if you are having both the databases on the same server, which as per your post I believe is the case.

Just use databasename..tablename in your query to access the...