Topics
Started by
Posts
Last post
I return from a select statement an id field, a description and an email address. Ideally I w…
7 replies
Is there a way to create a view using SELECT * from 2 tables (actually in my case it's from 2 other…
6 replies
I have three table Computers - computername,computer, model, OS, ServiceTag, users Software - Comp…
9 replies
I have a string and I would like to return only the first 10 words of the string and also some time…
39 replies
Hi, Is it possible to reference a user defined function via a linked server in the following way? e…
12 replies
Hi, I need to create a DTS job that will export a months worth of data. I need to get take the curr…
6 replies
How can I evaluate a mathmatical function that is stored in a column of a table? Here's&…
3 replies
I need to know the number of days that two date ranges have in common (in a view definition). …
8 replies
We have a program that's supposed to return a random set of rows from a rowset of 500-600 records.&…
2 replies
Hi, Our server was taken down. I don't have any backups of the database. But I have all the mdf and…
4 replies
we are planning to setup a disaster recovery process on our SQL server Box. Can I find any document…
4 replies
By: Anonymous
I want to change all columns which match a naming convention to be of int datatype. Some of them wi…
2 replies
[Cross post] Hi, I have to transfer the database from one hard drive (secondary) to another hard dr…
1 replies
Hi all, I have the following two queries where I need to COUNT values so that I can compare them, b…
4 replies
SELECT @@TranCount SELECT @@TranCount As A INTO #A SELECT * FROM #A …
3 replies
Viewing 15 topics - 6,046 through 6,060 (of 17,082 total)
You must be logged in to create new topics.