Topics
Started by
Posts
Last post
I have just come across a slightly strange occurence in T-SQL and I'm hoping someone can explain it…
19 replies
Situation, I need to sum up data in a table A and then update table B, with the data in table …
1 replies
Hi Folks Apprecaite any help with this one as I am a bit stuck with this. Recently upsized an Acces…
1 replies
I'm attempting to add some new roles using a script and then grant the object rights to the role. W…
1 replies
Hello, I'll try to make clear my problem through a eaxmple: declare @MyVar integer select @MyVar= c…
2 replies
SELECT column_name, count(*) FROM table_name WHERE column_name like ‘%AAAA BBB%’ GROUP BY column_na…
3 replies
Hi, I've created some code that captures filesize using sp_helpfile. The column (filesize_kb) that …
1 replies
I tried to run a simple update statement with the REPLACE function to replace some portion of …
4 replies
Does anyone know if an implimentation of the dijkstra shortest path or similar algoritm is availabl…
7 replies
I have a DTS package that updates a table of about twenty fields from a view. We have h…
7 replies
Hi, I want to compare data in tables in multiple databases (rows, nulls etc..). Rather than script …
4 replies
Can someone tell me if function "IntListCount" get processed for each row or does MSSQL calculate i…
3 replies
Is there a simple (and fast) way to limit the records joined? Table A has one record in it. Table B…
11 replies
Looking for some help String 'Smith, John M' Note Space after , Looking to take a string Last, Fi…
4 replies
I need to convert a string that contains values like the following: 80 beds {could be any text in a…
4 replies
Viewing 15 topics - 10,906 through 10,920 (of 17,082 total)
You must be logged in to create new topics.