Topics
Started by
Posts
Last post
declare @FeatureList xml set @FeatureList = ' "True" "False" …
4 replies
Here's my situation, any help is appreciated. I have a 1TB db whose "Document" table is 500GB by it…
1 replies
How do I 'take' the results with the largest rank or any rank above 100 in a free text search? SE…
9 replies
I have an issue where a programmer has an insert sp which is is a varchar(9) where the first 2 char…
10 replies
Hi all, I have two almost similiar tables in sql server (Table1 has more columns and Table2 has few…
2 replies
We receive replication data from an external source and I want (you) to write a query that will 1. …
8 replies
I was passed a query from a developer... Basically it creates a temp table, sticks data in it, move…
3 replies
declare @c table(datasetid int) ;with cte as ( --there are a complex sql query here, so I ignore i…
3 replies
We use a similar script and recently partitiond a database. Now I receive a syntaxerror on this sta…
5 replies
I am writing a Stored procedure to drop a Column name using temperory table. But am getting followi…
4 replies
Hi All, I am a bit stuck with a problem which I hope someone can assist with resolving. I have a ma…
2 replies
Hi everybody, i have a column with values looking like this 'pp_uniline_usd:Entity', how do i remov…
3 replies
Hi all, There's a script below which may speak louder than my explanation of the problem. Hopefull…
2 replies
I have 1 million rows in a table and got 20 indexes on it but now i came to know that i need to rem…
5 replies
My Job role is Client Back-end Support and Back-end Coding.. If there is any problem in client live…
4 replies
Viewing 15 topics - 6,166 through 6,180 (of 12,234 total)
You must be logged in to create new topics.