Topics
Started by
Posts
Last post
I've seeing a weird issue with a CTE when trying to convert a string column to a datetime. We have…
5 replies
Hello, I am trying to write a code that will 1. Query sysarticles and syspublications to get unique…
5 replies
We are starting to explore storing XML in our SQL 2005 database(s). I have a table with a row defin…
2 replies
Size DBName Date 1329476ABC2009-06-08 06:00:00.843 1329476ABC2009-06-15 06:00:01.120 13…
3 replies
Dear All, I have written a trigger on Update of a column in table. When we update single row it …
11 replies
Hi, I got a small script from someone to use but need little help on How to make table and Insert r…
4 replies
Hi everyone, I have one table and previously it was designed badly and they put the Logdatetime col…
22 replies
Hi There I need to know that, is there any way to insert a text from a variable for a formatted wor…
6 replies
I can successfully use the Nodes() and Value() syntax, but I'm having trouble based on the format o…
2 replies
thanks in advance. setup: two tables: 1 is full detail records of inventory items. 2 is history rec…
4 replies
I have a query that I am testing in SQL Server 2005. In that query, I have a varchar field that I d…
4 replies
I would like to use a wildcard in a where clause to find records based on the value being between t…
24 replies
Hi, I converted one of my stored procedures which used to use dynamic SQL to one that did not howe…
5 replies
Hi people. I have a requirement. I need to group the data into groups of tens. Issue: I have cost d…
8 replies
I want to convert this query in to SQL server please any one reply me.. "select bo.agency_no, …
2 replies
Viewing 15 topics - 3,976 through 3,990 (of 12,234 total)
You must be logged in to create new topics.