Topics
Started by
Posts
Last post
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
I am trying to copy records to an archive table and am getting error 8152, "String or binary data w…
6 replies
Viewing 15 topics - 10,906 through 10,920 (of 17,081 total)
You must be logged in to create new topics.